query("SELECT max_marks FROM result_exam_structure WHERE id=$exam_structure_id")->fetch_assoc()['max_marks'] ?? 100); if ($marks_val !== null && $marks_val > $max) { echo json_encode(['success'=>false,'msg'=>"Marks cannot exceed $max"]); exit; } $entered_by = $_SESSION['admin_user'] ?? 'Admin'; $conn->query("INSERT INTO result_marks (student_id,exam_structure_id,marks_obtained,status,entered_by) VALUES ($student_id,$exam_structure_id,".($marks_val!==null?$marks_val:'NULL').",'$status','$entered_by') ON DUPLICATE KEY UPDATE marks_obtained=".($marks_val!==null?$marks_val:'NULL').",status='$status',entered_by='$entered_by',updated_at=NOW()"); echo json_encode(['success'=>true,'msg'=>'Saved']); exit; } // Filters $selected_class = intval($_GET['class_id'] ?? 0); $selected_term = intval($_GET['term_id'] ?? 0); $classes = $conn->query("SELECT rc.*, rs.session_name FROM result_classes rc JOIN result_sessions rs ON rc.session_id=rs.id ORDER BY rs.is_active DESC, rc.numeric_level, rc.section"); $terms = $conn->query("SELECT rt.*, rs.session_name FROM result_terms rt JOIN result_sessions rs ON rt.session_id=rs.id ORDER BY rs.is_active DESC, rt.display_order"); $students = []; $exam_structures = []; $subject_cols = []; if ($selected_class && $selected_term) { // Get students $stu_res = $conn->query("SELECT id, first_name, last_name, admission_no, roll_no FROM result_students WHERE class_id=$selected_class AND is_active=1 ORDER BY roll_no, first_name"); while($s = $stu_res->fetch_assoc()) $students[] = $s; // Get exam structures for this class + term $es_res = $conn->query("SELECT es.*, s.subject_name, s.grading_type, s.is_scholastic FROM result_exam_structure es JOIN result_subjects s ON es.subject_id=s.id WHERE es.term_id=$selected_term AND es.class_id=$selected_class ORDER BY s.subject_name, es.component_name"); while($e = $es_res->fetch_assoc()) { $exam_structures[$e['id']] = $e; $key = $e['subject_name'].($e['component_name'] ? ' ('.$e['component_name'].')' : ''); $subject_cols[$e['id']] = ['label'=>$key,'max'=>$e['max_marks'],'type'=>$e['grading_type']]; } // Get existing marks if (!empty($students) && !empty($exam_structures)) { $es_ids = implode(',',array_keys($exam_structures)); $s_ids = implode(',',array_column($students,'id')); $marks_res = $conn->query("SELECT student_id,exam_structure_id,marks_obtained,status FROM result_marks WHERE student_id IN($s_ids) AND exam_structure_id IN($es_ids)"); while($m = $marks_res->fetch_assoc()) { $marks_map[$m['student_id']][$m['exam_structure_id']] = $m; } } } ?> Marks Entry | Result System
Result System
BS Public School
Main
Dashboard Back to Admin
Setup
Sessions Classes Subjects Class-Subject Map Exam Terms Exam Structure Grading Scale
Students
Manage Students
Marks
Marks Entry Attendance Co-Scholastic Remarks
Reports
Report Cards Analytics
Logout

Marks Entry — Spreadsheet Mode

Auto-save ON
💡 Type marks directly. Auto-saved on Tab/Enter. 🔴 AB = Absent 🟡 ML = Medical Leave 🔵 EX = Exempted
No exam structure defined for this class & term. Set up Exam Structure first →
No students found in this class. Add students →
Students  |  Exam Components
$col): ?> $col): ?> $col) { $m = $marks_map[$s['id']][$eid] ?? null; $allMarks[$eid] = $m; if($m && $m['status']=='present' && $m['marks_obtained']!==null) { $totalObt += floatval($m['marks_obtained']); $totalMax += floatval($col['max']); } elseif (!$m) { $totalMax += floatval($col['max']); } } $pct = $totalMax>0 ? round(($totalObt/$totalMax)*100,1) : 0; $gradeInfo = getGrade($conn, $pct, 'PRIMARY'); ?> $col): $m = $allMarks[$eid]; $val = ''; $extraClass = ''; if ($m) { if ($m['status']=='absent') { $val='AB'; $extraClass='absent'; } elseif ($m['status']=='medical') { $val='ML'; $extraClass='absent'; } elseif ($m['status']=='exempted') { $val='EX'; $extraClass='absent'; } elseif ($m['marks_obtained']!==null) { $val=$m['marks_obtained']+0; $extraClass='saved'; } } ?>
# Student Name Roll No Total % Grade
Max:
%
📊
Select Class & Term to Load Marks Sheet

Choose a class and exam term above to start entering marks in spreadsheet mode.

Setup Exam Structure First Manage Students
Saving...