fetchOne("
SELECT s.*,
c.institution_name as college_name,
crs.course_name,
crs.course_code
FROM students s
LEFT JOIN users c ON s.institution_id = c.id
LEFT JOIN courses crs ON s.course_id = crs.id
WHERE s.id = ? AND s.result_declared = 1
", [$id]);
if (!$student) {
$error = "Invalid certificate or verification ID.";
}
?>
Verify Certificate - <?= APP_SHORT_NAME ?>