D:\host\scoreman.in\keralaopen2025closed\reprint.php
<?php
include('dbconnect.php');
$configs = include('conf.php');
$username = $_SESSION['username'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Print Application</title>
</head>
<body onload="window.print()">
<style>
p {
margin:2px !important;
}
</style>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
$appno=$_POST["reprintappno"];
$dob=$_POST["reprintdob"];
$dob=substr($dob,8,2)."-".substr($dob,5,2)."-".substr($dob,0,4);
if($appno)
{
$databaseQuery = 'SELECT * FROM applications where (appno= "'.$con->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 '<h2>Application No. Not found. Try Again</h2>';
echo '<script type="text/javascript">
function closeWindow() {
setTimeout(function() {
window.close();
}, 4000);
}
window.onload = closeWindow();
</script>';
return;
}
$row = mysqli_fetch_array($result);
/* if($_SESSION['username'] !="secretary")
{
if(trim($row["club"]) != $_SESSION['username'])
{
echo "<br/><br/>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<br/>(1 Lap [200M]), ";}else{$rink4=" ";}
$rink5=trim($row["rink5"]);if($rink5=="P"){$rink5="Rink - V<br/>(500+D), ";}else{$rink5=" ";}
$rink6=trim($row["rink6"]);if($rink6=="P"){$rink6="Rink - VI<br/>(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 '<center>';
echo '<table width="740px" border="0" style=" padding-left:12px; padding-right:12px; text-align:left; font-family:verdana;font-size:12px; border:1px solid black; ">';
?>
<tr>
<td colspan="3" style="font-size:14px; text-align:center; border-bottom:1px solid #000; ">
<center>
</center>
<div style="border:1px solid #000; font-weight:bold; "><?php echo $configs['eventtitle']; ?></div>
<font size="2">Conducted by <b>Trivandrum District Roller Skating Association (TDRSA)</b></font><br/>
<font size="2"> Under the auspices of Karnataka Roller Skating Association<br/>(Recognised by Karnataka State Sports Council)</font><br/>
21 & 22 Sep. - Artistic, Freestyle & Other Games. 22nd Sep. - Below 5 years(Recreational). 26 to 29 Sep. - Speed & Hockey.
<br />
</font></font></p></td></tr>
<tr><td colspan="3" style="font-size:12px; text-align:center;"><strong>SKATER ENTRY FORM</strong></td></tr>
<?php
echo '<tr><td width="120px">Application No </td> <td width="422px;"><strong>:'.$appno.'</strong></td>
<td rowspan="14" style=" vertical-align:top;">
<center>
<img src="https://chart.googleapis.com/chart?cht=qr&chl='.$appno.'&chs=100x100&choe=UTF-8&chld=L|2" ><br />
<img style="width:138px; " src="'.$photourl.'"/>
</center></td></tr>';
echo '<tr><td colspan=2>RSFI Annual Skater Registration Application No. <strong>:'.$skaterid.'</strong></td></tr>';
echo '<tr><td>Name </td> <td style="text-align:left; font-family:verdana;font-size:14px;" ><strong>:'.$sname.'</strong></td></tr>';
echo '<tr><td>Date of Birth </td> <td><strong>:'.$dob.'</strong></td></tr>';
echo '<tr><td>Age </td><td>: '.$age.' ';
echo ' , Age Group : '.$ag.' (as on 31-12-2019)</td></tr>';
echo '<tr><td>Gender </td> <td>:'.$gender.'</td></tr>';
echo '<tr><td>Team / Club </td> <td><strong>:'.$club.' '.$clubname.'</strong></td></tr>';
//echo '<tr><td>School </td> <td><strong>:'.$school.'</strong></td></tr>';
echo '<tr><td>Blood Group </td> <td>:'.$blood.'</td></tr>';
//echo '<tr><td>Father Name </td> <td>:'.$fathername.'</td></tr>';
//echo '<tr><td>Phone & Email :</td> <td>'.$phone.' '.$email.'</td></tr>';
//echo '<tr><td colspan=2>Address, City, Phone & Email :As Entered Online.</td></tr>';
//echo '<tr><td>City </td> <td>:'.$city.'</td></tr>';
echo '<tr><td>Phone </td> <td><strong>:'.$phone.' '.$email.'</strong></td></tr>';
echo '<tr><td>Address :</td><td colspan="1">'.$address.' '.$city.' '.$pin.'</td></tr>';
echo '<tr><td colspan="2"><strong>Participation Details</strong> </td></tr>';
/*echo '<tr><td><strong>Adjustable</strong> </td><td>';
//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 '</td></tr>';*/
echo '<tr><td><strong>Below 5 - Quad</strong> </td><td>';
//echo $rink1;
echo $under8;
echo '</td></tr>';
echo '<tr><td><strong>Speed-Quad</strong> </td><td>';
//echo $rink1;
echo $quad;
echo '</td></tr>';
echo '<tr><td><strong>Speed-Inline</strong> </td><td>';
echo $inline;
echo '</td></tr>';
echo '<tr><td><strong>Artistic</strong> </td><td colspan="2">';
echo $artistic;
echo '</td></tr>';
echo '<tr><td><strong>Hockey</strong> </td><td colspan="2">';
echo $hockey;
echo '</td></tr>';
echo '<tr><td><strong>Inline-FreeStyle</strong> </td><td colspan="2">';
echo $freestyle;
echo '</td></tr>';
echo '<tr><td><strong>Other</strong> </td><td colspan="2">';
echo $other;
echo '<tr><td colspan="3">';
?>
</center>
<p style="font-size:8px; text-align:justify;">
<?php echo $configs['declaration']; ?>
</p>
<br/>
<p style="font-size:10px; text-align:justify;"><strong>Signature of Skater Signature of Parent/Guardian (for Under 17)<br/><br/>Seal & Signature of Secretary of the Club</strong><br/>(If the Club is not recognized by TDRSA then not required to put any signature here)<br/><br/><br/><br/>
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.
</p>
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="font-size:10px; text-align:justify;">
<tr><hr/>
<td height="43" style="text-align:left; font-size:10px;">For Office use Only
<br/>
Signed Copy RSFI Annual Skaters Registration Form( ).Annual Skaters Registration Fee:( )<br/>
Signed Copy of Championship Entry Form:( ). Championship Entry Fee:( ) <br/>
Original Date of Birth Certificate:( )
</p></td>
<td colspan="3" style="text-align:right;font-size:10px;"><br />
</td></tr>
</table>
<?php
echo '</td></tr>';
echo '</table>';
echo '<br/>';
//echo $doburl;
/*if($doburl!='NA')
{
echo '<img style="width:620px; " src="'.$doburl.'"/>';
}
*/
if(strpos($tnrsaid,'TEMP') !== false)
{
echo '<font size="1">Please attach original bonafied certificate / DOB Proof . Please note.. Scanned Copy & Hard Copy Should be exactly same. If not.. scan & upload new one.</font>';
}
echo '</center>';
echo'<br/>';
}
}
?>
</body>
</html>