prepare("SELECT * FROM RESULTS WHERE STUDENT_ID = ? AND TERM = ? AND YEAR = ?");
$stmt_end->execute([$student_id, $term, $year]);
$end_result = $stmt_end->fetch(PDO::FETCH_ASSOC);
// Fetch MIDTERM results from MIDTERM_RESULTS table
$stmt_mid = $pdo->prepare("SELECT * FROM midterm_results WHERE STUDENT_ID = ? AND TERM = ? AND YEAR = ?");
$stmt_mid->execute([$student_id, $term, $year]);
$mid_result = $stmt_mid->fetch(PDO::FETCH_ASSOC);
if (!$end_result && !$mid_result) {
http_response_code(404);
echo "No results found for this student in the selected term/year.";
exit;
}
$pdf = new TCPDF('P', PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf->SetCreator('Luzira COU Primary School');
$pdf->SetAuthor('Luzira COU Primary School');
$pdf->SetTitle("Student Report - $student_id");
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetMargins(5, 5, 5);
$pdf->SetAutoPageBreak(TRUE, 10);
$pdf->SetFont('helvetica', '', 10);
$pdf->AddPage();
$pdf->Image('logo.png', 7, 5, 20);
$pdf->SetFont('helvetica', 'B', 16);
$pdf->Cell(0, 10, 'LUZIRA CHURCH OF UGANDA PRIMARY SCHOOL', 0, 1, 'C');
$pdf->SetFont('helvetica', 'B', 12);
$pdf->Cell(0, 5, "STUDENT'S PROGRESSIVE REPORT - $term $year", 0, 1, 'C');
$pdf->Ln(8);
// Basic student info
$source = $end_result ?: $mid_result;
$pdf->SetFont('helvetica', '', 11);
$pdf->writeHTML("
Student ID: {$source['STUDENT_ID']}
Name: {$source['STUDENT_NAME']}
Class: {$source['CLASS']}
Sex: {$source['SEX']}
", true, false, false, false, '');
// === Midterm Results Section ===
if ($mid_result) {
$pdf->Ln(5);
$pdf->SetFont('helvetica', 'B', 11);
$pdf->Cell(0, 6, 'MIDTERM RESULTS', 0, 1, 'L');
$pdf->SetFont('helvetica', '', 11);
// Styled midterm table
$mid_table = '
';
foreach ($mid_result as $key => $value) {
if (!in_array($key, ['STUDENT_ID', 'STUDENT_NAME', 'CLASS', 'SEX', 'TERM', 'YEAR'])) {
$label = ucwords(strtolower(str_replace('_', ' ', $key)));
$mid_table .= "| $label | $value |
";
}
}
$mid_table .= '
';
$pdf->writeHTML($mid_table, true, false, false, false, '');
}
// === End of Term Results Section ===
if ($end_result) {
$pdf->Ln(8);
$pdf->SetFont('helvetica', 'B', 11);
$pdf->Cell(0, 6, 'END OF TERM RESULTS', 0, 1, 'L');
$pdf->SetFont('helvetica', '', 11);
// Styled end term table
$end_table = '
';
foreach ($end_result as $key => $value) {
if (!in_array($key, ['STUDENT_ID', 'STUDENT_NAME', 'CLASS', 'SEX', 'TERM', 'YEAR'])) {
$label = ucwords(strtolower(str_replace('_', ' ', $key)));
$end_table .= "| $label | $value |
";
}
}
$end_table .= '
';
$pdf->writeHTML($end_table, true, false, false, false, '');
}
// Signature
$pdf->Ln(12);
$pdf->writeHTML('Headteacher\'s Signature:', true, false, false, false, '');
$pdf->Image('signature.png', $pdf->GetX(), $pdf->GetY(), 30);
$pdf->Ln(20);
// Disclaimer
$pdf->SetFont('', 'BI');
$pdf->SetTextColor(255, 255, 255);
$pdf->SetFillColor(0, 0, 0);
$pdf->Cell(0, 6, 'Disclaimer: These results can be verified via our website https://luziracouprimaryschool.com/', 0, 1, 'R', true);
$pdf->SetTextColor(0, 0, 0);
ob_end_clean();
$pdf->Output("Student_Report_$student_id.pdf", 'I');
exit;
}
?>
Verify Student Report
Verify Student Report