query("SELECT * FROM admit_card WHERE enrollment_no = '$enrollment_no'");
$stu = $con->query("SELECT * FROM students WHERE enrollment_no = '$enrollment_no'");
if ($stu->num_rows > 0 && $admit->num_rows > 0) {
$s = $stu->fetch_assoc();
$a = $admit->fetch_assoc();
// Fetching related course and center details
$c = $con->query("SELECT * FROM centers WHERE id = '".$s['center_id']."'")->fetch_assoc();
$course = $con->query("SELECT * FROM courses WHERE id = '".$s['course_id']."'")->fetch_assoc();
// Prepare details for the admit card
$bg = '../format/admit.jpg';
$photo = '../uploads/students/'.$s['photo'];
$name = $s['name'];
$father = $s['father'];
$centercode = $c['center_number'];
$mother = $s['mother'];
$city = $s['distric'];
$dob = $s['dob'];
$enroll_no = $s['enrollment_no'];
$roll_no = isset($a['roll_no']) ? $a['roll_no'] : 'N/A';
$sl = str_pad($a['id'], 4, '0', STR_PAD_LEFT);
$course_name = $course['course_name'];
$course_short_name = $course['short_name'];
$exam_date = $a['exam_date'];
$exam_time = $a['exam_time'];
$year = $a['year'];
$session = $a['session'];
$exam_center = $a['exam_center'];
$center_code = $c['center_number'];
$center_name = $c['institute_name'];
// Include the admit card template
include 'admit_card.php';
exit;
} else {
echo '';
}
} else {
echo '';
}
?>