D:\host\scoreman.in\tldt2025\helmeta3.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; '>
<?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;
$pageno=0;
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"]);
$pageno++;
$pbrk="";
if($pageno%8 == 0)
{
$pbrk="left";
}
echo "<div style='width:5.35in;height:2.7in;float:left; padding:0.13in; align-content:center; page-break-before:".$pbrk."; '>
<center>
<table cellpadding=0 cellspacing=0 style='width:100%; height:2.4in; border:1px solid #FF588C; border-radius:10px; margin:10px; page-break-inside: avoid;'>
<tr>
<td height=30 valign=middle style='vertical-align:middle; align:center;'>
<center><p style='vertical-align:middle;text-align:center;line-height:89%;text-align:center'><span lang=en-US style='font-size:12.0pt;line-height:89%;font-family:Arial;
color:#FF588C;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;text-align:center'><span lang=en-US style='font-size:165.0pt;line-height:92%;font-family:Arial;
color:black;font-weight:900;text-transform:uppercase;language:en-US'>".$chno."</span></p>
</center>
</td>
</tr>
<tr>
<td valign=middle style='vertical-align:middle; align:center;'>
<center>
<p style='vertical-align:top;text-align:center;text-align:center'><span lang=en-US style='font-size:14.0pt;line-height:82%;font-family:Arial; overflow:hidden;
color:#FF588C;font-weight:bold;text-transform:uppercase;language:en-US'>".$sname."<br/><small style='font-size:9px'>".$agegroup." ".$gender." ".$club." ".$skatertype."</small></p>
</center>
</td>
</tr>
</table>
</center>
</div>";
}
?>
</div>
</body>
</html>