prepare("SELECT * FROM students WHERE id = ?"); $stmt->bind_param("i", $id); $stmt->execute(); $result = $stmt->get_result(); $student = $result->fetch_assoc(); if (!$student) { die("Student not found!"); } // 2. Handle Update Logic if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['update_student'])) { $student_name = $_POST['student_name']; $student_name_pb = $_POST['student_name_pb']; $father_name = $_POST['father_name']; $father_name_pb = $_POST['father_name_pb']; $mother_name = $_POST['mother_name']; $mother_name_pb = $_POST['mother_name_pb']; $date_of_birth = $_POST['date_of_birth']; $date_of_admission = $_POST['date_of_admission']; $season = $_POST['season']; $class = $_POST['class']; $school_centre = $_POST['school_centre']; $photo_path = $student['photo_path']; // Purani photo default rakhein // Handle New Photo Upload if (isset($_FILES['photo']) && $_FILES['photo']['error'] == 0) { $ext = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION); $filename = $student['roll_no'] . '_' . time() . '.' . $ext; $target_file = PHOTO_PATH . $filename; if (move_uploaded_file($_FILES['photo']['tmp_name'], $target_file)) { // Purani photo delete karein agar exist karti hai if (!empty($student['photo_path']) && file_exists($student['photo_path'])) { unlink($student['photo_path']); } $photo_path = $target_file; } } $sql = "UPDATE students SET student_name=?, student_name_pb=?, father_name=?, father_name_pb=?, mother_name=?, mother_name_pb=?, date_of_birth=?, date_of_admission=?, season=?, class=?, school_centre=?, photo_path=? WHERE id=?"; $updateStmt = $conn->prepare($sql); $updateStmt->bind_param("ssssssssssssi", $student_name, $student_name_pb, $father_name, $father_name_pb, $mother_name, $mother_name_pb, $date_of_birth, $date_of_admission, $season, $class, $school_centre, $photo_path, $id); if ($updateStmt->execute()) { $_SESSION['success_msg'] = "Student details updated successfully!"; header("Location: students.php"); exit(); } else { $message = "
Update failed: " . $conn->error . "
"; } } include 'includes/header.php'; include 'includes/sidebar.php'; ?>
Edit Student:
Back to List

Leave empty to keep current photo