fetchOne(
"SELECT s.*, c.course_name, c.course_code, c.duration_text as duration, c.syllabus_text as course_syllabus, cat.name as course_category,
u.institution_name, u.institution_code
FROM students s
LEFT JOIN courses c ON s.course_id = c.id
LEFT JOIN course_categories cat ON c.category_id = cat.id
LEFT JOIN users u ON s.institution_id = u.id
WHERE s.id = ?",
[$studentId]
);
if (!$student) {
session_destroy();
header('Location: login.php');
exit;
}
// Check if admit card exists
$admitCard = $db->fetchOne("SELECT * FROM admit_cards WHERE student_id = ? ORDER BY created_at DESC LIMIT 1", [$studentId]);
// Get published results
$results = $db->fetchAll(
"SELECT * FROM student_results WHERE student_id = ? AND is_published = 1 ORDER BY created_at DESC",
[$studentId]
);
// Simplified fees display
$feesPending = in_array($student['payment_status'], ['pending', 'partial']);
$flash = getFlashMessage();
?>
Student Dashboard - <?= APP_SHORT_NAME ?>