requireRole(['college', 'admin', 'super_admin']); $db = DB(); $id = intval($_GET['id'] ?? 0); $s = $db->fetchOne("SELECT s.*, c.course_name, c.course_code FROM students s JOIN courses c ON s.course_id = c.id WHERE s.id = ?", [$id]); // Check if published results exist in student_results table $subjectResults = $db->fetchAll("SELECT * FROM student_results WHERE student_id = ? AND is_published = 1 ORDER BY created_at DESC", [$id]); if (!empty($subjectResults)) { // Use published data $theorySubjects = array_filter($subjectResults, fn($sub) => stripos($sub['subject_name'], 'Practical') === false); $practicalSubjects = array_filter($subjectResults, fn($sub) => stripos($sub['subject_name'], 'Practical') !== false); // Note: The above filter is a bit heuristic, but student_results doesn't have a 'type' column } else { // Fallback to subjects + marks_entry (draft mode) $subjects = $db->fetchAll("SELECT s.*, m.obtained_marks FROM subjects s LEFT JOIN marks_entry m ON s.id = m.subject_id AND m.student_id = ? WHERE s.course_id = ? ORDER BY s.type, s.subject_name", [$id, $s['course_id']]); $theorySubjects = array_filter($subjects, fn($sub) => $sub['type'] === 'Theory'); $practicalSubjects = array_filter($subjects, fn($sub) => $sub['type'] === 'Practical'); } ?> Mark Sheet - <?= $s['registration_number'] ?>
IBVTE

INDIAN BOARD OF VOCATIONAL AND TECHNICAL EDUCATION

Autonomous Board Registered under NCT of Delhi, Government of India

60 Futa Road, Samar Garden Colony, Meerut (UP) – 250002

OFFICIAL STATEMENT OF MARKS
Roll Number:
Registration No.:
Student Name:
Father's Name:MR.
Course Name:
Institution:
Exam Session:
S.No. Subject Name Max Marks Min Pass Obtained
PART A: THEORY SUBJECTS
PART B: PRACTICAL / VIVA-VOCE
GRAND TOTAL -
PERCENTAGE
%
DIVISION
RESULT STATUS
Verified By
Result Declared Date:
Controller of Examination
For verification - Send documents to ibvtenewdelhi@gmail.com | Website: www.ibvte.com