query("SELECT id FROM result_students WHERE admission_no='". $conn->real_escape_string($admission_no)."'"); if ($chk->num_rows > 0) { $err = "Admission No already exists!"; } else { $st = $conn->prepare("INSERT INTO result_students (admission_no,roll_no,first_name,last_name,dob,gender,father_name,mother_name,parent_mobile,class_id) VALUES (?,?,?,?,?,?,?,?,?,?)"); $st->bind_param("sissssssssi",$admission_no,$roll_no,$first_name,$last_name,$dob,$gender,$father_name,$mother_name,$mobile,$class_id); // fix bind: 10 params $st = $conn->prepare("INSERT INTO result_students (admission_no,roll_no,first_name,last_name,dob,gender,father_name,mother_name,parent_mobile,class_id) VALUES (?,?,?,?,?,?,?,?,?,?)"); $st->bind_param("siisssssssi",$admission_no,$roll_no,$first_name,$last_name,$dob,$gender,$father_name,$mother_name,$mobile,$class_id); // Actually fix properly: $adm = $conn->real_escape_string($admission_no); $fn = $conn->real_escape_string($first_name); $ln = $conn->real_escape_string($last_name); $dob_e = $conn->real_escape_string($dob); $gen = $conn->real_escape_string($gender); $fat = $conn->real_escape_string($father_name); $mot = $conn->real_escape_string($mother_name); $mob = $conn->real_escape_string($mobile); $conn->query("INSERT INTO result_students (admission_no,roll_no,first_name,last_name,dob,gender,father_name,mother_name,parent_mobile,class_id) VALUES ('$adm',$roll_no,'$fn','$ln','$dob_e','$gen','$fat','$mot','$mob',$class_id)"); if ($conn->affected_rows > 0) $msg = "✅ Student added successfully!"; else $err = "Error: ".$conn->error; } } // Handle Delete if (isset($_GET['del'])) { $did = intval($_GET['del']); $conn->query("DELETE FROM result_students WHERE id=$did"); $msg = "Student deleted."; } // Handle Edit if ($_POST['action'] ?? '' == 'edit') { $id = intval($_POST['student_id']); $fn = $conn->real_escape_string(trim($_POST['first_name'])); $ln = $conn->real_escape_string(trim($_POST['last_name'])); $dob = $conn->real_escape_string($_POST['dob']); $gen = $conn->real_escape_string($_POST['gender']); $fat = $conn->real_escape_string(trim($_POST['father_name'])); $mot = $conn->real_escape_string(trim($_POST['mother_name'])); $mob = $conn->real_escape_string(trim($_POST['mobile'])); $cid = intval($_POST['class_id']); $rno = intval($_POST['roll_no']); $conn->query("UPDATE result_students SET first_name='$fn',last_name='$ln',dob='$dob',gender='$gen',father_name='$fat',mother_name='$mot',parent_mobile='$mob',class_id=$cid,roll_no=$rno WHERE id=$id"); $msg = "✅ Student updated successfully!"; } // Filters $filter_class = intval($_GET['class_id'] ?? 0); $search = $conn->real_escape_string(trim($_GET['s'] ?? '')); $where = "rs.is_active=1"; if ($filter_class) $where .= " AND rs.class_id=$filter_class"; if ($search) $where .= " AND (rs.first_name LIKE '%$search%' OR rs.last_name LIKE '%$search%' OR rs.admission_no LIKE '%$search%')"; $students = $conn->query("SELECT rs.*, rc.class_name, rc.section, rc.numeric_level FROM result_students rs JOIN result_classes rc ON rs.class_id=rc.id WHERE $where ORDER BY rc.numeric_level, rs.roll_no, rs.first_name"); $classes = $conn->query("SELECT rc.*, rs.session_name FROM result_classes rc JOIN result_sessions rs ON rc.session_id=rs.id ORDER BY rc.numeric_level, rc.section"); $total = $conn->query("SELECT COUNT(*) as c FROM result_students rs JOIN result_classes rc ON rs.class_id=rc.id WHERE $where")->fetch_assoc()['c']; // For edit modal $edit_student = null; if (isset($_GET['edit'])) { $eid = intval($_GET['edit']); $edit_student = $conn->query("SELECT * FROM result_students WHERE id=$eid")->fetch_assoc(); } ?> Manage Students | 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 Bulk Import
Marks
Marks Entry Attendance Co-Scholastic Remarks
Reports
Report Cards Analytics
Logout

Students ()

Clear Bulk Import CSV
Students List
students
num_rows>0): while($s=$students->fetch_assoc()): $col = $colors[$i % count($colors)]; $i++; $initials = strtoupper(substr($s['first_name'],0,1).substr($s['last_name']?:$s['first_name'],0,1)); ?>
#StudentAdmission NoRollClassDOBFatherMobileActions
No students found. Add first student