fetchOne(
"SELECT s.*, c.course_name, c.course_code, c.description as course_desc,
cat.name as course_category, c.course_type, c.duration_text as duration, c.dur_months as duration_months,
c.eligibility, c.syllabus_text as course_syllabus, c.mode,
c.assessment_pass_percent,
sub.name as sub_name,
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 course_sub_categories sub ON c.sub_category_id = sub.id
LEFT JOIN users u ON s.institution_id = u.id
WHERE s.id = ?",
[$studentId]
);
if (!$student) { session_destroy(); header('Location: login.php'); exit; }
// Parse syllabus - could be JSON or plain text
$syllabus = $student['course_syllabus'] ?? '';
$syllabusItems = [];
if (!empty($syllabus)) {
$decoded = json_decode($syllabus, true);
if (is_array($decoded)) {
$syllabusItems = $decoded;
} else {
// Plain text - split by newline or bullet
$syllabusItems = array_filter(array_map('trim', preg_split('/[\n\r,;]+/', $syllabus)));
}
}
// Get all subjects for this course from marks_entry
$subjects = $db->fetchAll(
"SELECT DISTINCT su.id, su.subject_name, su.max_marks, su.type
FROM subjects su
WHERE su.course_id = ?
ORDER BY su.id",
[$student['course_id']]
);
?>
Course & Syllabus - <?= APP_SHORT_NAME ?>