query("SELECT * FROM certificates 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();
$c = $con->query("SELECT * FROM centers where id = '".$s['center_id']."'")->fetch_assoc();
$r = $con->query("SELECT * FROM results WHERE enrollment_no = '$enrollment_no' order by id DESC limit 1")->fetch_assoc();
$ad = $con->query("SELECT * FROM admit_panel where enrollment_no = '$enrollment_no' order by id DESC limit 1")->fetch_assoc();
// print_r($r);
// exit;
$course = $con->query("SELECT * FROM courses where id = '".$s['course_id']."'")->fetch_assoc();
$bg = '../format/certificate.jpg';
$enroll_no = $s['enrollment_no'];
$photo = '../uploads/students/'.$s['photo'];
$name = $s['name'];
$father = $s['father'];
// $mother = $s['mother'];
$duration = $course['duration'];
$duration_type = ucwords($course['duration_type']);
$dob = $s['dob'];
$roll_no = $ad['roll_no'];
$du_start = $s['dur_start'];
$du_end = $s['dur_ends'];
$issue_date = $a['issue_date'];
$certificate_number = $c['id'];
// $certificate_number = date("YmdHis", $issue_date);
$isu_date = date("d-m-Y", strtotime($issue_date));
// print_r($isu_date);exit;
$course_name = $course['course_name'];
$course_short_name = $course['short_name'];
$center_code = $c['center_number'];
$center_name = $c['institute_name'];
$course = $course['short_name'];
$grade = $r['grade'];
include 'view_certificate.php';
exit;
?>
Certificate
Institute Name
Enrollment No.
Roll No.
Student Name
Father Name
Mother Name
Course
alert("Enrollment or date of birth not matched.");location.href="get_certificate.php"';
}
}
else
{
require_once 'includes/header.php';
echo front_header_navigarion('CERTIFICATE VERIFICATION');
echo '
