prepare("
SELECT
c.certificate_code,
u.name as user_name,
comp.title as competition_title,
s.uploaded_at
FROM certificates c
JOIN submissions s ON c.submission_id = s.id
JOIN users u ON s.user_id = u.id
JOIN competitions comp ON s.competition_id = comp.id
WHERE c.certificate_code = ?
");
$stmt->execute([$certificate_code]);
$certificate = $stmt->fetch();
if (!$certificate) {
die("Invalid certificate code.");
}
?>
Certificate of Achievement