Results & Marks - College Panel

requireRole(['college']); $db = DB(); $user = Auth()->getUser(); $flash = getFlashMessage(); // Handle Practical Marks Submission if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'save_marks') { $studentId = intval($_POST['student_id'] ?? 0); $practicalMarks = floatval($_POST['practical_marks'] ?? 0); // Check if student belongs to this college $student = $db->fetchOne("SELECT id FROM students WHERE id = ? AND institution_id = ?", [$studentId, $user['id']]); if ($student) { $max_marks = 100; $percentage = ($practicalMarks / $max_marks) * 100; $division = 'fail'; if ($percentage >= 60) { $division = 'first'; } elseif ($percentage >= 45) { $division = 'second'; } elseif ($percentage >= 30) { $division = 'third'; } $db->update('students', [ 'marks_obtained' => $practicalMarks, 'total_marks' => $max_marks, 'percentage' => $percentage, 'division' => $division ], ['id' => $studentId]); redirectWithMessage('results.php', 'Practical marks saved and division calculated successfully.', 'success'); } } // Fetch Students for Result Management // Only students with 'active' status can have marks entered $students = $db->fetchAll(" SELECT s.*, c.course_name, c.course_code FROM students s JOIN courses c ON s.course_id = c.id WHERE s.institution_id = ? ORDER BY s.full_name ASC ", [$user['id']]); ?> Results & Marks - College Panel

Exam & Result Management

Student Name	Course	Reg. No	Marks Obtained	Division	Result Status	Actions
No students found
Roll:			/		Declared Pending

Exam & Result Management

Enter Practical Marks