query("SELECT *,r.id as marksheet_id FROM results as r,students as s WHERE r.id = '$marksheet_id' and r.enrollment_no = s.enrollment_no"); // echo '
';
// print_r($con);
$__S = ($result->fetch_assoc());
$institute = $con->query("SELECT * FROM centers where id = '".$__S['center_id']."'")->fetch_assoc();
$courseDetails = $con->query("SELECT * FROM courses WHERE id = '".$__S['course_id']."'")->fetch_assoc();
$course_duration = $courseDetails['duration'];
$course_duration_type = ucfirst($courseDetails['duration_type']);
$course_name = $courseDetails['course_name'];
$course_id = $courseDetails['id'];
$bg = '../format/marksheet.jpg';
$enroll_no = $__S['enrollment_no'];
$photo = '../uploads/students/'.$__S['photo'];
$serial_no = $__S['marksheet_id'];
$sr_no = $__S['sr_no'];
$res = $__S['result'];
$sex = ucwords($__S['gender']);
$name = ucwords($__S['name']);
$father = ucwords($__S['father']);
$dob = date('d-m-Y', strtotime($__S['dob']));
$mother = ucwords($__S['mother']);
// $course_name = ucwords($course['short_name']);
// $duration=$course['duration'];
$roll_no = $__S['roll_no'];
$center_name = $institute['institute_name'];
$center_number = $institute['center_number'];
$issue_date = $__S['issue_date'];
$isu = date('d-m-Y',strtotime($issue_date));
$examination = date('M-Y',strtotime($issue_date));
$grade = $__S['grade'];
$hidden_duration = $__S['duration'];
$examination_a = $__S['examination'];
$session = $__S['session'];
$duration = $__S['duration'] .' '. ucwords($__S['duration_type']);
function sup($i)
{
$i = ($i == 1) ? 'st' :
(($i == 2) ? 'nd' :
(($i == 3) ? 'rd' : 'th'));
return '' . $i . '';
}
include 'result.php';
}
?>