Print Application real_escape_string($appno).'" AND dob= "'.$con->real_escape_string($dob).'")'; // echo $databaseQuery ; $result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); } if($result) { $rescnt= mysqli_num_rows ($result ); if($rescnt!=1) { echo '

Application No. Not found. Try Again

'; echo ''; return; } $row = mysqli_fetch_array($result); /* if($_SESSION['username'] !="secretary") { if(trim($row["club"]) != $_SESSION['username']) { echo "

Please dont try to open other distirct participant details."; exit(); } }*/ $appno=trim($row["appno"]); $sname=trim($row["sname"]); $skaterid=trim($row["skaterid"]); $dob=trim($row["dob"]); $age=trim($row["age"]); $ag=trim($row["agegroup"]); $gender=trim($row["gender"]); //$club=trim($row["club"].",".$row["school"]); $school=$row["school"]; $club=trim($row["club"]); $clubname=trim($row["clubname"]); $fathername=trim($row["fathername"]); $address=trim($row["address"]); $city=trim($row["city"]); $pin=trim($row["pin"]); $phone=trim($row["phone"]); $email=trim($row["email"]); $blood=trim($row["bloodgroup"]); $skatertype=trim($row["skatertype"]); $parentoccupation=trim($row["parentoccupation"]); $photourl=$row["photourl"]; $nodob=""; $doburl=$row["doburl"]; if($doburl=='NA') { $nodob="true"; } $adjrink1=trim($row["adjrink1"]);if($adjrink1=="P"){$adjrink1="Race-1, ";}else{$adjrink1=" ";} $adjrink2=trim($row["adjrink2"]);if($adjrink2=="P"){$adjrink2="Race-2, ";}else{$adjrink2=" ";} $adjrink3=trim($row["adjrink3"]);if($adjrink3=="P"){$adjrink3="Race-3, ";}else{$adjrink3=" ";} $u8race1q=trim($row["u8race1q"]);if($u8race1q=="P"){$u8race1q="Quad-Race-1, ";}else{$u8race1q=" ";} $u8race2q=trim($row["u8race2q"]);if($u8race2q=="P"){$u8race2q="Quad-Race-2, ";}else{$u8race2q=" ";} $u8race1i=trim($row["u8race1i"]);if($u8race1i=="P"){$u8race1i="Inline-Race-1, ";}else{$u8race1i=" ";} $u8race2i=trim($row["u8race2i"]);if($u8race2i=="P"){$u8race2i="Inline-Race-2, ";}else{$u8race2i=" ";} $under8=trim($u8race1q.$u8race2q.$u8race1i.$u8race2i); if($under8=="") { $under8="NA"; } $rink1=trim($row["rink1"]);if($rink1=="P"){$rink1="Rink - I (1 Lap [200M]), ";}else{$rink1=" ";} $rink2=trim($row["rink2"]);if($rink2=="P"){$rink2="Rink - II (2 Lap / 500+D), ";}else{$rink2=" ";} $rink3=trim($row["rink3"]);if($rink3=="P"){$rink3="Rink - III (3 Lap / 4 Lap / 1000 M), ";}else{$rink3=" ";} $road1=trim($row["road1"]);if($road1=="P"){$road1="Road - I (1 Lap), ";}else{$road1=" ";} $road2=trim($row["road2"]);if($road2=="P"){$road2="Road - II (1500 / 3000 M), ";}else{$road2=" ";} $quad=trim($rink1.$rink2.$rink3.$road1.$road2); if($quad=="") { $quad="NA"; } $rink4=trim($row["rink4"]);if($rink4=="P"){$rink4="Rink - IV
(1 Lap [200M]), ";}else{$rink4=" ";} $rink5=trim($row["rink5"]);if($rink5=="P"){$rink5="Rink - V
(500+D), ";}else{$rink5=" ";} $rink6=trim($row["rink6"]);if($rink6=="P"){$rink6="Rink - VI
(1000 M), ";}else{$rink6=" ";} $road3=trim($row["road3"]);if($road3=="P"){$road3="Road - III (100 M), ";}else{$road3=" ";} $road4=trim($row["road4"]);if($road4=="P"){$road4=">Road - IV (1 Lap), ";}else{$road4=" ";} $road5=trim($row["road5"]);if($road5=="P"){$road5="Road - V (3000 M), ";}else{$road5=" ";} $p2p=trim($row["p2p"]);if($p2p=="P"){$p2p="Point to Point + Eli. - Rink (10000 M), ";}else{$p2p=" ";} $elim=trim($row["elim"]);if($elim=="P"){$elim="Elimination - Rink (5000 / 10000 M), ";}else{$elim=" ";} $p2prd=trim($row["p2prd"]);if($p2prd=="P"){$p2prd="Point to Point - Road (10000 M), ";}else{$p2prd=" ";} $elimrd=trim($row["elimrd"]);if($elimrd=="P"){$elimrd="Elimination - Road (15000 M), ";}else{$elimrd=" ";} $relay=trim($row["relay"]);if($relay=="P"){$relay="RELAY, ";}else{$relay=" ";} $marathon=trim($row["marathon"]);if($marathon=="P"){$marathon="MARATHON, ";}else{$marathon=" ";} $inline=trim($rink4.$rink5.$rink6.$p2p.$elim.$road3.$road4.$road5.$p2prd.$elimrd.$relay.$marathon); if($inline=="") { $inline="NA"; } $figure=trim($row["figure"]);if($figure=="P"){$figure="FIGURE, ";}else{$figure=" ";} $free=trim($row["free"]);if($free=="P"){$free="FREE, ";}else{$free=" ";} $combined=trim($row["combined"]);if($combined=="P"){$combined="COMBINED, ";}else{$combined=" ";} $pair=trim($row["pair"]);if($pair=="P"){$pair="PAIR, ";}else{$pair=" ";} $pairpartnername=trim($row["pairpartnername"]); $pairpartnerag=trim($row["pairpartnerag"]); $inlinefree=trim($row["inlinefree"]);if($inlinefree=="P"){$inlinefree="INLINE-FREE, ";}else{$inlinefree=" ";} $solodance=trim($row["solodance"]);if($solodance=="P"){$solodance="SOLODANCE, ";}else{$solodance=" ";} $pairdance=trim($row["pairdance"]);if($pairdance=="P"){$pairdance="COUPLE-DANCE, ";}else{$pairdance=" ";} $coupledancepartnername=trim($row["coupledancepartnername"]); $coupledancepartnerag=trim($row["coupledancepartnerag"]); $quartet=trim($row["quartet"]);if($quartet=="P"){$quartet="QUARTET, ";}else{$quartet=" ";} $precision=trim($row["precisionskating"]);if($precision=="P"){$precision="PRECISION, ";}else{$precision=" ";} $showgroup=trim($row["showgroup"]);if($showgroup=="P"){$showgroup="SHOWGROUP, ";}else{$showgroup=" ";} $artistic=trim($figure.$free.$combined.$pair.$inlinefree.$solodance.$pairdance.$quartet.$precision.$showgroup); if($artistic=="") { $artistic="NA"; } $quadhockey=trim($row["quadhockey"]);if($quadhockey=="P"){$quadhockey="ROLLER-HOCKEY, ";}else{$quadhockey=" ";} $inlinehockey=trim($row["inlinehockey"]);if($inlinehockey=="P"){$inlinehockey="INLINE-HOCKEY, ";}else{$inlinehockey=" ";} $hockey=trim($quadhockey.$inlinehockey); if($hockey=="") { $hockey="NA"; } $classicslalom=trim($row["classicslalom"]);if($classicslalom=="P"){$classicslalom="CLASSIC-SLALOM, ";}else{$classicslalom=" ";} $speedslalom=trim($row["speedslalom"]);if($speedslalom=="P"){$speedslalom="SPEED-SLALOM, ";}else{$speedslalom=" ";} $freestyle=trim($classicslalom.$speedslalom); if($freestyle=="") { $freestyle="NA"; } $alpine=trim($row["alpine"]);if($alpine=="P"){$alpine="ALPINE, ";}else{$alpine=" ";} $downhill=trim($row["downhill"]);if($downhill=="P"){$downhill="DOWNHILL, ";}else{$downhill=" ";} $rollerderby=trim($row["rollerderby"]);if($rollerderby=="P"){$rollerderby="ROLLER-DERBY, ";}else{$rollerderby=" ";} $rollerfreestyle=trim($row["rollerfreestyle"]);if($rollerfreestyle=="P"){$rollerfreestyle="ROLLER-FREESTYLE, ";}else{$rollerfreestyle=" ";} $skateboarding=trim($row["skateboarding"]);if($skateboarding=="P"){$skateboarding="SKATEBOARDING, ";}else{$skateboarding=" ";} $other=trim($alpine.$downhill.$rollerderby.$rollerfreestyle.$skateboarding.$precision.$showgroup); if($other=="") { $other="NA"; } echo '
'; echo ''; ?> '; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; //echo ''; echo ''; //echo ''; //echo ''; //echo ''; //echo ''; echo ''; echo ''; echo ''; /*echo '';*/ echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
Conducted by Trivandrum District Roller Skating Association (TDRSA)
Under the auspices of Karnataka Roller Skating Association
(Recognised by Karnataka State Sports Council)

21 & 22 Sep. - Artistic, Freestyle & Other Games. 22nd Sep. - Below 5 years(Recreational). 26 to 29 Sep. - Speed & Hockey.

SKATER ENTRY FORM
Application No :'.$appno.'

RSFI Annual Skater Registration Application No. :'.$skaterid.'
Name :'.$sname.'
Date of Birth :'.$dob.'
Age : '.$age.' '; echo ' , Age Group : '.$ag.' (as on 31-12-2019)
Gender :'.$gender.'
Team / Club :'.$club.' '.$clubname.'
School :'.$school.'
Blood Group :'.$blood.'
Father Name :'.$fathername.'
Phone & Email : '.$phone.' '.$email.'
Address, City, Phone & Email :As Entered Online.
City :'.$city.'
Phone :'.$phone.' '.$email.'
Address :'.$address.' '.$city.' '.$pin.'
Participation Details
Adjustable '; //echo $rink1; if($adjrink1=='true') { echo ' Rink I, '; } if($adjrink2=='true') { echo ' Rink II, '; } if($adjrink2a=='true') { echo ' Rink II A, '; } if($adjrink1!='true' && $adjrink2!='true' && $adjrink2a!='true') { echo 'NA'; } echo '
Below 5 - Quad '; //echo $rink1; echo $under8; echo '
Speed-Quad '; //echo $rink1; echo $quad; echo '
Speed-Inline '; echo $inline; echo '
Artistic '; echo $artistic; echo '
Hockey '; echo $hockey; echo '
Inline-FreeStyle '; echo $freestyle; echo '
Other '; echo $other; echo '
'; ?>


Signature of Skater                                                                              Signature of Parent/Guardian (for Under 17)

Seal & Signature of Secretary of the Club

(If the Club is not recognized by TDRSA then not required to put any signature here)



Note:Copy of Online Entry Form, Copy of Annual Skaters Registration Form, Entry Fee, Annual Skaters Registration Fee & Original Date of Birth Certificate, to be submitted to Hon.Gen.Secretary-TDRSA, Lourdes Cottage, T.C.26/510,Near Adhyapaka Bhavan, Trivandrum-695001 on or before 18.09.2019(Before 7.00PM) for Artistic-Freestyle-Below 5 years-Other Games & on or before 23.09.2019(Before 7.00PM) for Above 5 Years:Speed-Hockey.


For Office use Only
Signed Copy RSFI Annual Skaters Registration Form( ).Annual Skaters Registration Fee:( )
Signed Copy of Championship Entry Form:( ). Championship Entry Fee:( )
Original Date of Birth Certificate:( )


    
'; echo '
'; //echo $doburl; /*if($doburl!='NA') { echo ''; } */ if(strpos($tnrsaid,'TEMP') !== false) { echo 'Please attach original bonafied certificate / DOB Proof . Please note.. Scanned Copy & Hard Copy Should be exactly same. If not.. scan & upload new one.'; } echo '
'; echo'
'; } } ?>