Manage Students

0) { $student = mysqli_fetch_assoc($student_result); $student_name = $student['full_name']; $enrollment = $student['enrollment_no']; // ✅ ONLY DELETE STUDENT $delete_query = "DELETE FROM students WHERE id=$id"; if(mysqli_query($conn, $delete_query)) { // Show success alert echo ""; exit(); } else { echo ""; exit(); } } else { echo ""; exit(); } } // Get all active students $students_query = "SELECT s.*, c.center_name FROM students s LEFT JOIN centers c ON s.center_id = c.id WHERE s.status='active' ORDER BY s.created_at DESC"; $students_result = mysqli_query($conn, $students_query); // Get student count $student_count = mysqli_num_rows($students_result); // If no students, add demo students if ($student_count == 0) { // Get all active centers $centers_query = "SELECT * FROM centers WHERE status='active'"; $centers_result = mysqli_query($conn, $centers_query); $centers = []; while($center = mysqli_fetch_assoc($centers_result)) { $centers[] = $center; } // Demo student data $demo_students = [ [ 'enrollment_no' => 'STU2026001', 'full_name' => 'Rajesh Patel', 'father_name' => 'Ramesh Patel', 'mobile' => '9876543210', 'email' => 'rajesh.patel@email.com', 'address' => 'Gandhinagar, Gujarat', 'id_proof_type' => 'Aadhar Card', 'id_proof_number' => '1234 5678 9012' ], [ 'enrollment_no' => 'STU2026002', 'full_name' => 'Priya Sharma', 'father_name' => 'Ravi Sharma', 'mobile' => '8765432109', 'email' => 'priya.sharma@email.com', 'address' => 'Ahmedabad, Gujarat', 'id_proof_type' => 'Aadhar Card', 'id_proof_number' => '2345 6789 0123' ], [ 'enrollment_no' => 'STU2026003', 'full_name' => 'Amit Verma', 'father_name' => 'Sunil Verma', 'mobile' => '7654321098', 'email' => 'amit.verma@email.com', 'address' => 'Vadodara, Gujarat', 'id_proof_type' => 'PAN Card', 'id_proof_number' => 'ABCDE1234F' ], [ 'enrollment_no' => 'STU2026004', 'full_name' => 'Sneha Joshi', 'father_name' => 'Mohan Joshi', 'mobile' => '6543210987', 'email' => 'sneha.joshi@email.com', 'address' => 'Surat, Gujarat', 'id_proof_type' => 'Aadhar Card', 'id_proof_number' => '3456 7890 1234' ] ]; // Add students foreach($centers as $index => $center) { for($i = 0; $i < 2 && isset($demo_students[$index * 2 + $i]); $i++) { $student = $demo_students[$index * 2 + $i]; $insert_query = "INSERT INTO students (enrollment_no, full_name, father_name, mobile, email, address, id_proof_type, id_proof_number, center_id, status, admission_date, created_by, created_at) VALUES ( '{$student['enrollment_no']}', '{$student['full_name']}', '{$student['father_name']}', '{$student['mobile']}', '{$student['email']}', '{$student['address']}', '{$student['id_proof_type']}', '{$student['id_proof_number']}', {$center['id']}, 'active', NOW(), '{$_SESSION['user_id']}', NOW() )"; mysqli_query($conn, $insert_query); $student_id = mysqli_insert_id($conn); // Assign random course $courses_query = "SELECT id, fees FROM courses WHERE status='active' ORDER BY RAND() LIMIT 1"; $courses_result = mysqli_query($conn, $courses_query); if(mysqli_num_rows($courses_result) > 0) { $course = mysqli_fetch_assoc($courses_result); $discount = rand(0, 20); $net_fee = $course['fees'] - ($course['fees'] * $discount / 100); $enroll_query = "INSERT INTO student_courses (student_id, course_id, fee, discount, net_fee, status, enrollment_date) VALUES ( $student_id, {$course['id']}, {$course['fees']}, $discount, $net_fee, 'active', NOW() )"; mysqli_query($conn, $enroll_query); } } } // Refresh query $students_result = mysqli_query($conn, $students_query); $student_count = mysqli_num_rows($students_result); } // Calculate statistics $month = date('m'); $year = date('Y'); $new_this_month_query = "SELECT COUNT(*) as count FROM students WHERE status='active' AND MONTH(admission_date) = $month AND YEAR(admission_date) = $year"; $new_month_result = mysqli_query($conn, $new_this_month_query); $new_month_data = mysqli_fetch_assoc($new_month_result); $new_this_month = $new_month_data['count'] ?? 0; // Get average course fees $avg_fees_query = "SELECT AVG(net_fee) as avg_fees FROM student_courses WHERE status='active'"; $avg_fees_result = mysqli_query($conn, $avg_fees_query); $avg_fees_data = mysqli_fetch_assoc($avg_fees_result); $avg_fees = $avg_fees_data['avg_fees'] ?? 0; // Calculate total pending fees $pending_fees = 0; // Get all active centers for filter $centers_query = "SELECT * FROM centers WHERE status='active' ORDER BY center_name"; $centers_result = mysqli_query($conn, $centers_query); // Display messages if (isset($_SESSION['success'])) { $success = $_SESSION['success']; unset($_SESSION['success']); } if (isset($_SESSION['error'])) { $error = $_SESSION['error']; unset($_SESSION['error']); } ?> Manage Students - Student Management

➕ Add New Student

✅

❌

Total Students

Active Students

New This Month

Pending Fees

₹

Total Due

Avg. Course Fees

₹

Per Student

All Students ( Students)

0): ?> = 10) { $phone = substr($phone, 0, 5) . ' ' . substr($phone, 5); } // Student courses count $course_query = "SELECT COUNT(*) as course_count FROM student_courses WHERE student_id = {$student['id']} AND status='active'"; $course_result = mysqli_query($conn, $course_query); $course_data = mysqli_fetch_assoc($course_result); $course_count = $course_data['course_count'] ?? 0; ?>

Enrollment No	Student Details	Center	Contact Info	Status	Actions
	Courses • Admission:	Not Assigned	📱 📧		👁️ View ✏️ Edit 🗑️ Delete 📚 Enroll

No students found. Add your first student using the button above.