query($update_query)) { echo ''; } else { echo ''; } } else { // Update with photo $img = photo_upload('image', 'students'); if($img['status']) { $update_query = "UPDATE `students` SET `center_id` = '$center_id', `enrollment_no` = '$enrollment_no', `status` = '$mystatus', `dur_start` = '$dur_start', `dur_ends` = '$dur_ends', `name` = '$name', `gender` = '$gender', `father` = '$father', `mother` = '$mother', `dob` = '$dob', `mobile` = '$mobile', `email` = '$email', `state` = '$state', `distric` = '$distric', `address` = '$address', `exam_pass` = '$exam_pass', `marks` = '$marks', `board` = '$board', `year` = '$year', `username` = '$username', `password` = '$password', `course_id` = '$course_id', `photo` = '".$img['file_name']."' WHERE `id` = '$id'"; if($con->query($update_query)) { // Delete old photo if(!empty($_POST['file']) && file_exists("../uploads/students/".$_POST['file'])) { unlink("../uploads/students/".$_POST['file']); } echo ''; } else { echo ''; } } else { echo ''; } } exit(); } // Fetch student data $get = $con->query("SELECT * FROM students WHERE id = '".mysqli_real_escape_string($con, $_GET['id'])."'")->fetch_assoc(); // Redirect if student not found if(!$get) { echo ''; exit(); } ?>
Back to List
View Student
Personal Information
Enrollment No.
*
Full Name
*
Gender
*
>
Male
>
Female
Father's Name
*
Mother's Name
*
Date of Birth
*
Contact Information
Mobile No.
*
Email ID
*
State
District
Address
<?= htmlspecialchars($get['address']) ?>
Academic Information
Select Center
*
-- Select Center --
query("SELECT * FROM centers ORDER BY institute_name ASC"); while($c = $centers->fetch_assoc()) { $se = $c['id'] == $get['center_id'] ? "selected" : ""; echo '
'.ucwords($c['institute_name']).'
'; } ?>
Select Course
*
-- Select Course --
query("SELECT * FROM courses ORDER BY course_name ASC"); while($c = $courses->fetch_assoc()) { $se = $c['id'] == $get['course_id'] ? "selected" : ""; echo '
'.ucwords($c['course_name']).'
'; } ?>
Status
>Active
>Inactive
Session Start
*
Session Ends
*
Exam Passed
Marks (%)
Board
Year
Account Information
Username
Password
Student Photo
Upload New Photo
Leave empty to keep current photo. Max size: 2MB
Current Photo
Update Student Details