query("SELECT * FROM admit_card WHERE id = '$id'");
$enrollment_no = 0;
if($admit->num_rows){
$a = $admit->fetch_assoc();
$enrollment_no = $a['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();
// print_r($s);
// exit;
// 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();
$subjects = $con->query("SELECT * FROM subjects WHERE course_id = '".$s['course_id']."' and duration = '".$a['duration']."' and duration_type = '".$a['duration_type']."'");
// 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'];
$exam_center = $a['exam_center'];
$center_code = $c['center_number'];
$center_name = $c['institute_name'];
$year = $a['year'];
$session = $a['session'];
$examHeld = $a['exam_held'];
$duration = $a['duration'];
$issu_date = date('d-m-Y',strtotime($a['timestamp']));
$subjectsDetails = json_decode($a['subjects'],true);
// echo '';
// print_r($subjectsDetails);
// exit;
// Include the admit card template
include 'admit_card.php';
exit;
} else {
echo '';
}
}
?>