requireRole(['super_admin', 'admin']); $db = DB(); $flash = getFlashMessage(); $courseId = intval($_GET['course_id'] ?? 0); $course = $db->fetchOne("SELECT * FROM courses WHERE id = ?", [$courseId]); if (!$course) { die("Course not found."); } // Edit Subject Fetch $editSub = null; if (isset($_GET['edit_id'])) { $editSub = $db->fetchOne("SELECT * FROM subjects WHERE id = ? AND course_id = ?", [intval($_GET['edit_id']), $courseId]); } // Add/Edit Subject Save if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['save_subject'])) { $name = cleanInput($_POST['subject_name']); $type = $_POST['type']; $max = intval($_POST['max_marks']); $pass = intval($_POST['pass_marks']); $sid = intval($_POST['subject_id'] ?? 0); if ($name && $max > 0) { $data = [ 'course_id' => $courseId, 'subject_name' => $name, 'type' => $type, 'max_marks' => $max, 'pass_marks' => $pass ]; if ($sid > 0) { $db->update('subjects', $data, ['id' => $sid]); $msg = "Subject updated successfully!"; } else { $db->insert('subjects', $data); $msg = "Subject added successfully!"; } redirectWithMessage("manage-subjects.php?course_id=$courseId", $msg, "success"); } } // Delete Subject if (isset($_GET['delete_id'])) { $db->query("DELETE FROM subjects WHERE id = ? AND course_id = ?", [intval($_GET['delete_id']), $courseId]); redirectWithMessage("manage-subjects.php?course_id=$courseId", "Subject deleted.", "info"); } $subjects = $db->fetchAll("SELECT * FROM subjects WHERE course_id = ? ORDER BY type, subject_name", [$courseId]); ?> Manage Subjects - <?= htmlspecialchars($course['course_name']) ?>

Manage Subjects

Course: ()

New

$s): ?>

S.No	Subject Name	Type	Max	Pass	Action
No subjects added yet.
					Edit Delete