D:\host\scoreman.in\upstate2025closed\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 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.15in; align-content:center;'>
<center>
<table cellpadding=0 cellspacing=0 style='width:100%'>
<tr>
<td height=61 valign=middle bgcolor='#ff8829' style='vertical-align:middle;background:#ff8829; align:center;'>
<center><p style='width:6in;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'>11th UTTAR PRADESH STATE<BR/>ROLLER SKATING CHAMPIONSHIP 2025</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:800;text-transform:uppercase;language:en-US'>".$chno."</span></p>
</center>
</td>
</tr>
<tr>
<td height=67 valign=middle bgcolor='#a5c90f' style='vertical-align:middle;background:#a5c90f; 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>