prepare(" SELECT qa.roll_no, SUM(qa.is_correct) AS correct_count, COUNT(*) AS total_count FROM question_attempts qa WHERE qa.roll_no = ? AND qa.track = 'final' "); $stmt->execute([$roll_no]); $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row && $row['total_count'] > 0) { $percent = round(($row['correct_count'] / $row['total_count']) * 100); if ($percent >= 60) { $verified = true; $data = [ 'roll_no' => $roll_no, 'concept' => $concept_id, 'score' => $percent, 'date' => date("d M Y") ]; } else { $error = "Certificate not eligible (final not passed)."; } } else { $error = "No final assessment found."; } } } ?> Certificate Verification

Certificate Verification

✅ Certificate Verified

Roll No:
Concept:
Score: %
Status: VALID
Date:
❌