D:\host\scoreman.in\keralaopen2025closed\application.php
<?php
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
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>Registration Complete</title>
</head>
<body onload="window.print()">
<style>
p {
margin:2px !important;
}
</style>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'GET')
{
$appno=$_GET["appno"];
$name=$_GET["k"];
if($appno)
{
// $databaseQuery = 'SELECT * FROM applications where (appno= "'.$con->real_escape_string($appno).'" AND sname= "'.$con->real_escape_string($name).'")';
//$databaseQuery = 'SELECT * FROM applications where (appno= "'.$con->real_escape_string($appno).'" AND (sname="'.$con->real_escape_string($name).'" OR hashcode="'.$con->real_escape_string($name).'"))';
$databaseQuery = 'SELECT * FROM applications where (appno= "'.$con->real_escape_string($appno).'" )';
//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>Name / 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"]);
$repdistrict=trim($row["repdistrict"]);
$fees=trim($row["fees"]);
$photourl=$row["photourl"];
$nodob="";
$doburl=$row["doburl"];
if($doburl=='NA')
{
$nodob="true";
}
$adjrink1=trim($row["adjrink1"]);if($adjrink1=="P"){$adjrink1="Adjustable-Quad, ";}else{$adjrink1=" ";}
$adjrink2=trim($row["adjrink2"]);if($adjrink2=="P"){$adjrink2="Adjustable-Inline, ";}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 / 2000 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=" ";}
$rink7=trim($row["rink7"]);if($rink7=="P"){$rink7="Rink - VII DUAL TT(200 M), ";}else{$rink7=" ";}
$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=" ";}
$mixedrelay=trim($row["mixedrelay"]);if($mixedrelay=="P"){$mixedrelay="MIXED RELAY, ";}else{$mixedrelay=" ";}
$marathon=trim($row["marathon"]);if($marathon=="P"){$marathon="MARATHON, ";}else{$marathon=" ";}
$inline=trim($rink4.$rink5.$rink6.$rink7.$p2p.$elim.$road3.$road4.$road5.$p2prd.$elimrd.$relay.$mixedrelay.$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=" ";}
$mixedrollerhockey=trim($row["mixedrollerhockey"]);if($mixedrollerhockey=="P"){$mixedrollerhockey="MIXED-ROLLER-HOCKEY, ";}else{$mixedrollerhockey=" ";}
$hockey=trim($quadhockey.$mixedrollerhockey.$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=" ";}
$pairslalom=trim($row["pairslalom"]);if($pairslalom=="P"){$pairslalom="PAIR-SLALOM, ";}else{$pairslalom=" ";}
$freestyle=trim($classicslalom.$speedslalom.$pairslalom);
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=" ";}
$rollerscooter=trim($row["scooter"]);if($rollerscooter=="P"){$rollerscooter="ROLLER-SCOOTER, ";}else{$rollerscooter=" ";}
$other=trim($alpine.$downhill.$rollerderby.$rollerfreestyle.$skateboarding.$rollerscooter);
if($other=="")
{
$other="NA";
}
$order_status=$row["order_status"];
$order_id=$row["order_id"];
$tracking_id=$row["tracking_id"];
$payment_mode=$row["payment_mode"];
$trans_date=$row["trans_date"];
$amt=$row["fees"];
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; ">';
$bankacno="";
$bankifsc="";
$bankacname="";
$bankname="";
$eventtitle="";
$eventdate="";
$contact="";
$databaseQuery = 'SELECT * FROM `championships` WHERE `district`="'.$con->real_escape_string($repdistrict).'"';
$result3 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
while($row = mysqli_fetch_array($result3))
{
$stat=trim($row["status"]);
$bankacno=trim($row["bankacno"]);
$bankifsc=trim($row["bankifsc"]);
$bankacname=trim($row["bankacname"]);
$bankname=trim($row["bankname"]);
$eventtitle=trim($row["championshiptitle"]);
$eventdate=trim($row["dates"]);
$lastdate=trim($row["lastdate"]);
$contact=trim($row["contact"]);
}
$feeamt=$fees;
$payurl=rawurlencode("upi://pay?pa=".$bankacno."@".$bankifsc.".ifsc.npci&pn=".$bankacname."&am=".$feeamt."&tn=".$appno."&cu=INR");
?>
<tr>
<td colspan="3" style="font-size:14px; text-align:center; border-bottom:1px solid #000; ">
<center>
<!-- <img src="districtlogos/<?php echo $repdistrict; ?>.png" width="75%" /> -->
</center>
<div style="border:0px solid #000; font-weight:bold; "><?php echo $eventtitle; ?></div>
<!-- <font size="2">Conducted by <b>Karnataka Roller Skating Association (KRSA)<br/>Recognised by Karnataka State Sports Council</b></font><br/>
<font size="2"> Under the auspices of Roller Skating Federation of India<br/></font> -->
<?php echo $eventdate; ?>
<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="17" style=" vertical-align:top;">
<center>
<img style="width:138px; " src="'.$photourl.'"/><br />
<br/>
<table style="border:1px solid black; text-align:left; width:220px; font-size:10px;" >
<tr><td>Fee </td><td>: Rs.'.$amt.'</td></tr>
</table>
<!--Fee Amt : Rs.'.$fees.'/-<br /> -->
';
echo '</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-2025)</td></tr>';
echo '<tr><td>Gender </td> <td>:'.$gender.'</td></tr>';
echo '<tr><td>Team / District </td> <td><strong>:'.$club.'<br/>Ref : '.$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>';
if($adjrink1!="" ||$adjrink2!="")
{
echo '<tr><td><strong>'.$adjrink1.$adjrink2.'</strong> </td><td>';
echo '</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 '</td></tr>';
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<br/><br/>Seal & Signature of Secretary of the District Unit</strong><br/><br/><br/><br/>
Note:Copy of Online Entry Form, Copy of Annual Skaters Registration Form, Entry Fee & Original Date of Birth Certificate, to be submitted to the championship office at registration time.
</p>
<?php
echo '</td></tr>';
echo '</table>';
echo '<br/>';
//echo $doburl;
/*if($doburl!='NA')
{
echo '<img style="width:620px; " src="'.$doburl.'"/>';
}
*/
echo '</center>';
echo'<br/>';
}
}
?>
</body>
</html>