Invalid Student ID'; require_once 'includes/footer.php'; exit(); } $id = (int)$_GET['id']; // Use prepared statement for security $stmt = $con->prepare("SELECT * FROM students WHERE id = ?"); $stmt->bind_param("i", $id); $stmt->execute(); $get = $stmt->get_result(); if($get->num_rows > 0) { $row = $get->fetch_assoc(); // Get center details $center_stmt = $con->prepare("SELECT * FROM centers WHERE id = ?"); $center_stmt->bind_param("i", $row['center_id']); $center_stmt->execute(); $center_result = $center_stmt->get_result(); $center = $center_result->fetch_assoc(); // Get course details $course_stmt = $con->prepare("SELECT * FROM courses WHERE id = ?"); $course_stmt->bind_param("i", $row['course_id']); $course_stmt->execute(); $course_result = $course_stmt->get_result(); $course = $course_result->fetch_assoc(); ?>
Sector-12, Gandhinagar, Gujarat - 382010
| Enrollment No. | =htmlspecialchars($row['enrollment_no'] ?? $row['id'])?> |
|---|---|
| Student Full Name | =htmlspecialchars($row['name'] ?? 'N/A')?> |
| Father's Name | =htmlspecialchars($row['father'] ?? $row['father_name'] ?? 'N/A')?> |
| Mother's Name | =htmlspecialchars($row['mother'] ?? $row['mother_name'] ?? 'N/A')?> |
| Date of Birth (As per Record) | =htmlspecialchars($row['dob'] ?? 'N/A')?> |
| Gender | =htmlspecialchars($row['gender'] ?? 'N/A')?> |
| Category | =htmlspecialchars($row['category'] ?? 'N/A')?> |
| Contact No. | =htmlspecialchars($row['mobile'] ?? 'N/A')?> |
| Email ID | =htmlspecialchars($row['email'] ?? 'N/A')?> |
| Aadhar No. (UID) | =htmlspecialchars($row['aadhar_no'] ?? 'N/A')?> |
| Permanent Address | =htmlspecialchars($row['address'] ?? 'N/A')?> |
| Institute / Study Center | =htmlspecialchars($center['institute_name'] ?? 'N/A')?> |
| Center Code | =htmlspecialchars($center['center_code'] ?? 'N/A')?> |
| Course Enrolled | =htmlspecialchars($course['course_name'] ?? 'N/A')?> |
| Course Duration | =htmlspecialchars($course['duration'] ?? 'N/A')?> |
| Academic Session | =htmlspecialchars($row['academic_year'] ?? date('Y').'-'.(date('Y')+1))?> |