D:\host\scoreman.in\keralaopen2025closed\chestflex.php
<?php
include('dbconnect.php');
// include('jfunctions.php');
// include('functions.php');
// ?>
<html>
<head>
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Poppins:wght@400;800&display=swap" rel="stylesheet">
</head>
<body style='margin:auto; align:center;'>
<div style='float:left; width:96in; '>
<?php
$district=$_GET["dt"];
$databaseQuery = 'SELECT * FROM `championships` WHERE `district`="'.$district.'"';
$result3 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
$eventtitle="";
$eventdate="";
while($row = mysqli_fetch_array($result3))
{
$stat=trim($row["status"]);
$eventtitle=trim($row["championshiptitle"]);
$eventdate=trim($row["dates"]);
}
// echo $eventtitle;
$databaseQuery = 'SELECT appno,chno,sname,club,agegroup,gender,skatertype,repdistrict FROM applications where `repdistrict`="'.$con->real_escape_string($district).'" and chno!="" order by chno';
//echo $databaseQuery;
$result1 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
//echo $result1;
while($row = mysqli_fetch_array($result1))
{
$appno=trim($row["appno"]);
$chno=trim($row["chno"]);
$sname=trim($row["sname"]);
$club=trim($row["club"]);
$agegroup=trim($row["agegroup"]);
$gender=trim($row["gender"]);
$skatertype=trim($row["skatertype"]);
echo "<div style='width:6in;height:4in;float:left; border:1px solid black; padding:0.05in; align-content:center;'>
<center>
<table cellpadding=0 cellspacing=0 style='width:100%'>
<tr>
<td height=61 valign=middle bgcolor='#FF588C' style='vertical-align:middle;background:#FF588C; align:center;'>
<center><p style='vertical-align:middle;text-align:center;line-height:89%;text-align:center'><span lang=en-US style='font-size:13.0pt;line-height:89%;font-family:Arial;
color:white;font-weight:bold;text-transform:uppercase;language:en-US'>".$eventtitle."</span></p>
</center>
</td>
</tr>
<tr>
<td valign=middle bgcolor='#FFFFFF' style='vertical-align:middle;background:#FFFFFF align:center;'>
<center>
<p style='vertical-align:middle;text-align:center;line-height:87%;text-align:center'><span lang=en-US style='font-size:205.0pt;line-height:87%;font-family:Arial;
color:black;font-weight:bold;text-transform:uppercase;language:en-US'>".$chno."</span></p>
</center>
</td>
</tr>
<tr>
<td height=67 valign=middle bgcolor='#FF588C' style='vertical-align:middle;background:#FF588C; align:center;'>
<center>
<p style='vertical-align:middle;text-align:center;line-height:89%;text-align:center'><span lang=en-US style='font-size:23.0pt;line-height:89%;font-family:Arial;
color:white;font-weight:bold;text-transform:uppercase;language:en-US'>".$sname."</span></p>
<p style='margin-top:0; vertical-align:top;text-align:center;line-height:89%;text-align:center'><span lang=en-US style='font-size:10pt;line-height:89%;font-family:Arial;
color:white;font-weight:bold;text-transform:uppercase;language:en-US'>".$agegroup." ".$gender." ".$club." ".$skatertype."</span></p>
</center>
</td>
</tr>
</table>
</center>
</div>";
}
?>
</div>
</body>
</html>