D:\host\scoreman.in\assisi2026\certificates.php

<?php
include('dbconnect.php');
include('jfunctions.php');
include('functions.php');
$configs = include('conf.php');
//phpinfo();
$maxperheat=10000;

$discipline=$_GET["discipline"];


if($discipline=="" || $discipline==NULL)
{
	$discipline="";
}
   $bankacno="";

			     $bankifsc="";
			      $bankacname="";
			       $bankname="";
	$eventtitle="";
	$eventdate="";
	$contact="";
$repdistrict=$_SESSION['teamf'];

    if ($_SESSION["username"]!="secretary") {

    	loginbox();

    	}

if($repdistrict=="")
{
	$repdistrict=$_SESSION['currentdistrict'];
}

?>


<?php


	$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))
  {
	
			       $eventtitle=trim($row["championshiptitle"]);
			        $eventdate=trim($row["dates"]);

	   }

	   $feeamt=$fees;

?>

<?php

	$team=$_SESSION['teamf'];
	$teampr=$team;
	if($team=="")
{
    $teampr=$_SESSION["username"];
}
	
// echo "<h5>District / Team : ".$teampr." </h5>";
//echo renderScoresheet(scoresheet($con, "rink2", 6,$repdistrict));

//echo '<br/><a href="scoresheet.php?raceid='.$raceid.'&racetitle='.$racetitle.'&maxperheat='.$maxperheat.'" target="_blank" class="noprint ui-btn ui-btn-raised ui-btn ui-btn-inline waves-effect waves-button"><i class="zmdi zmdi-print zmd-2x"></i> Print Scoresheet</a>';

//echo renderScoresheet(scoresheet($con, $raceid, $maxperheat,$repdistrict), $racetitle, $raceid,$repdistrict);
	//renderScoresheet(array $rows, $eventTitle = 'Start List', $raceName = '', $repdistrict = '') 


// $groups = consolidateResults($con, $raceid, $repdistrict); // e.g. $racename = 'rink2'
// echo renderConsolidatedResults($groups, $eventtitle, $racetitle, $repdistrict);
// Build the data

// 1) HTML (print or Save as PDF from browser)
$html = buildCertificatesHTML($con, $repdistrict,$discipline);
echo $html;

// 2) Or stream a PDF (requires dompdf installed + autoload):
// require 'vendor/autoload.php';
// $html = buildCertificatesHTML($con, $repdistrict);
// if (!outputCertificatesPdfDompdf($html, 'certificates-'.$repdistrict.'.pdf')) {
//   // fallback to HTML if dompdf missing
//   echo $html;
// }

?>