printableResume.php

<?php
	require ('fpdf181/fpdf.php');
	include ('connect.php');
	

	
class PDF extends FPDF{
	
	function header(){
		$today = date("F j, Y"); 
		 $this->SetFont('Arial','I',8);
		 $this->Cell(0,0,$today,0,0,"R");
	
		$this->Cell(12);
		$this->Image('aa.png', 70,10,70);
		$this->Cell(12);
		$this->Cell(59, 5, '',0,1);//end of line
		$this->Cell(59, 5, '',0,1);//end of line
		
		$this->Cell(59, 5, '',0,1);//end of line
		
	}
	function Footer()
{
	
    //Position at 1.5 cm from bottom
    $this->SetY(-15);
    //Arial italic 8
    $this->SetFont('Arial','I',8);
    //Page number
    $this->Cell(0,0,'Page '.$this->PageNo(),0,0,"C");
	//$this->Cell(0,0,$today,0,1);
}
	
}
	$id = $_GET['id'];
	$selectID = "SELECT *FROM tbl_application WHERE id = '$id'";
	$resultSelect = $conn->query($selectID);
	while($data = mysqli_fetch_array($resultSelect)){
	//$app_date = date("F d, Y", strtotime($data['Timestamp']);
		
		$pdf = new PDF();
		$pdf->AddPage();
		$pdf->SetFont('Arial','B',15);
		$pdf->Cell(10,10,'Application Form',0,1);
		$pdf->Cell(59, 5, '',0,1);//end of line
		
		
	$pdf->SetFont('Arial','B',13);
	$pdf->Cell(130, 5,$data['NAME'],0,0,"L");
	$pdf->Cell(59, 5, '',0,1);//end of line
	$pdf->Cell(130, 5, '',0,0);
	$pdf->Cell(59, 5, '',0,1);//end of line
	
	$pdf->SetFont('Arial','I',11);
	$pdf->Cell(35, 5, 'Application Date:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5,date("F d, Y", strtotime($data["Timestamp"])),0,1);
	$pdf->Cell(59, 5, '',0,1);
	//end of line
	
	//position
	$pdf->Cell(35, 5, 'Position Applying for:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(55, 5, $data['POSITION'],0,1);//end of line
	$pdf->SetFont('Arial','I',9);
	$pdf->Cell(59, 5, '',0,1);
	//date of employment
	
	//shifting schedule
	$pdf->SetFont('Arial','',11);
	$pdf->Cell(73, 5, 'Are you Amenable for Shifting Schedule?',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(21, 5, $data['SHIFTING_SCHEDULE'],0,0);
	$pdf->Cell(50, 5, 'Available Date for employment:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['EMPLOYMENT_DATE'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//expected salary
	
	//work on holidays/weekends
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(73, 5, 'Are you willing to work on weekends/holiday? ',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(21, 5, $data['WEEKENDS_HOLIDAYS'],0,0);//end of line
	$pdf->SetFont('Arial','I',11);
	$pdf->Cell(30, 5, 'Expected Salary:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['SALARY'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	
	//personal information
	
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Personal Information',0,1,"L");//END OF LINE
	$pdf->Cell(59, 5, '',0,1);
	//nickname
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(20, 5, 'Nickname:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(65, 5, $data['NICKNAME'],0,0);//end of line
	//status
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Civil Status:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['CIVIL STATUS'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//nickname
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(20, 5, 'Birth Date:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(65, 5, $data['DATE OF BIRTH'],0,0);//end of line
	//status
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Age:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['AGE'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//nickname
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(25, 5, 'Place of Birth:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(60, 5, $data['PLACE OF BIRTH'],0,0);//end of line
	//status
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Gender:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['GENDER'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//nickname
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(25, 5, 'Blood Type:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(60, 5, $data['BLOODTYPE'],0,0);//end of line
	//status
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Religion:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['RELIGION'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//nickname
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(25, 5, 'Height:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(60, 5, $data['HEIGHT'],0,0);//end of line
	//status
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Weight:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['WEIGHT'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	
	//current address
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(35, 5, 'Current Address:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(60, 5, $data['CURRENT ADDRESS'],0,0);//end of line
	$pdf->Cell(59, 5, '',0,1);
	$pdf->Cell(59, 5, '',0,1);
	
	//provincial address
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(35, 5, 'Provincial Address:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(60, 5, $data['PROVINCIAL_ADDRESS'],0,0);//end of line
	$pdf->Cell(59, 5, '',0,1);
	
	//CONTACT INFORMATION
	$pdf->Cell(59, 5, '',0,1);
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Contact Information',0,1,"L");//END OF LINE
	$pdf->Cell(59, 5, '',0,1);
	//MOBILE NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(20, 5, 'Mobile No.:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(65, 5, $data['MOBILE_NUMBER'],0,0);//end of line
	//HOME TEL NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Home Tel Number:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['HOME_TELNUM'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//OPTIONALNUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Optional Mob. #:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(55, 5, $data['MOBILE_NUMBER2'],0,0);//end of line
	//OPTIONAL NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Optional Mob. #:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['MOBILE_NUMBER3'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//EMAIL ADDRESS
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(25, 5, 'Email Address:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(60, 5, $data['EMAIL ADDRESS'],0,0);//end of line
	//SKYPE
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Skype:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['SKYPE_USERID'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//FB ACCNT
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(25, 5, 'Facebook:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(60, 5, $data['FB_Account'],0,0);//end of line
	//TWITTER ACCNT
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Twitter:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['Twitter_Account'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//CONTACT PERSON
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Contact Person:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(55, 5, $data['CONTACT NAME'],0,0);//end of line
	//CONTACT PERSON'S NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Contact Detail:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['CONTACT DETAILS'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	
	//FAMILY BACKGROUND
	
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Family Background',0,1,"L");//END OF LINE
	$pdf->Cell(59, 5, '',0,1);
	
	if ((!empty($data['SPOUSE\'S NAME']))){
	
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(25, 5, 'Spouse Name:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(60, 5, $data['SPOUSE\'S NAME'],0,0);//end of line
	//CONTACT PERSON'S NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Occupation:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['SPOUSE\'S OCCUPATION'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line;
	}else{
		$pdf->Cell(59, 5, '',0,1);//end of line;
	}
	
	//CONTACT PERSON
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, "Father's Name:",0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(60, 5, $data['FATHER\'S NAME'],0,1);//end of line
	$pdf->Cell(59, 5, '',0,1);
	//CONTACT PERSON'S NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Place of Birth:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['FATHER PLACEBIRTH'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, "Mother's Name:",0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(60, 5, $data['MOTHER\'S MAIDEN NAME'],0,1);//end of line
	$pdf->Cell(59, 5, '',0,1);
	//CONTACT PERSON'S NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(30, 5, 'Place of Birth:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['MOTHER PLACEBIRTH'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	
	$selectSiblings = mysqli_query($conn, "Select * from tbl_siblings where `ID` = '$id'");
	while($siblings=mysqli_fetch_array($selectSiblings)){
	if (!empty($siblings['SIBLING_NAME'])) {
			 //nickname
			echo	$pdf->SetFont('Arial','I',10);
			echo	$pdf->Cell(30, 5, "Sibling's Name:",0,0);
			echo	$pdf->SetFont('Arial','',10);
			echo	$pdf->Cell(65, 5, $siblings['SIBLING_NAME'],0,0);//end of line
				//status
			echo	$pdf->SetFont('Arial','I',10);
			echo	$pdf->Cell(30, 5, 'Age:',0,0);
			echo	$pdf->SetFont('Arial','',10);
			echo	$pdf->Cell(10, 5, $siblings['SIBLING_AGE'],0,1);
			echo	$pdf->Cell(59, 5, '',0,1);//end of line;
		}else{
			echo	$pdf->Cell(59, 5, '',0,1);//end of line;
		}
	}
	$selectChild = mysqli_query($conn, "Select * from tbl_child where `ID` = '$id'");
	while($child=mysqli_fetch_array($selectChild)){
	if (!empty($child['CHILD_NAME'])) {
			 //nickname
			echo	$pdf->SetFont('Arial','I',10);
			echo	$pdf->Cell(30, 5, "Sibling's Name:",0,0);
			echo	$pdf->SetFont('Arial','',10);
			echo	$pdf->Cell(65, 5, $child['CHILD_NAME'],0,0);//end of line
				//status
			echo	$pdf->SetFont('Arial','I',10);
			echo	$pdf->Cell(30, 5, 'Age:',0,0);
			echo	$pdf->SetFont('Arial','',10);
			echo	$pdf->Cell(10, 5, $child['CHILD_AGE'],0,1);
			echo	$pdf->Cell(59, 5, '',0,1);//end of line;
		}else{
			echo	$pdf->Cell(59, 5, '',0,1);//end of line;
		}
		$dependentCounter++;
	}
	
	//EDUCATIONAL BACKGROUND
	$pdf->Cell(59, 5, '',0,1);

	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Educational Background',0,1,"L");//END OF LINE
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Primary',0,1,"L");//END OF LINE
	$pdf->Cell(59, 5, '',0,1);
		//ELEM School NAME
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(35, 5, 'Name of School:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(75, 5, $data['ELEM_Name of School'],0,1);//end of line
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(25, 5, 'Scholarship:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(35, 5, $data['ELEM_Scholarship/ Academic Honors Received'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line

	//DATE
	$explodeElemDates = explode("-", $data['ELEM_Inclusive Dates of Attendance']);
	if (!empty($explodeElemDates[1])) {
			$ElemDates = $explodeElemDates[1];
		}
		else{
			$ElemDates = "";
		}
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(10, 5, 'From:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(30, 5, $explodeElemDates[0],0,0);//end of line
	//CONTACT PERSON'S NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(10, 5, 'To:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $ElemDates,0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//HIGH School NAME
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Seconday',0,1,"L");//END OF LINE
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(35, 5, 'Name of School:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(75, 5, $data['HS_Name of School'],0,1);//end of line
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(25	, 5, 'Scholarship:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['HS_Scholarship/ Academic Honors Received'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line

	//DATE
	$explodeHSDates = explode("-", $data['HS_Inclusive Dates of Attendance']);
	if (!empty($explodeHSDates[1])) {
			$HSDates = $explodeHSDates[1];
		}
		else{
			$HSDates = "";
		}
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(10, 5, 'From:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(30, 5, $explodeHSDates[0],0,0);//end of line
	//CONTACT PERSON'S NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(10, 5, 'To:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $HSDates,0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	//HIGH School NAME
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Tertiary',0,1,"L");//END OF LINE
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(35, 5, 'Name of School:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(75, 5, $data['COL_Name of School'],0,1);//end of line
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(20, 5, 'Course:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(75, 5, $data['COL_Degree Course'],0,1);//end of line
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(25	, 5, 'Scholarship:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['COL_Scholarship/ Academic Honors Received'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line

	//DATE
	$explodeColDates = explode("-", $data['COL_Inclusive Dates of Attendance']);
	if (!empty($explodeColDates[1])) {
			$ColDates = $explodeColDates[1];
		}
		else{
			$ColDates = "";
		}
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(10, 5, 'From:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(30, 5, $explodeColDates[0],0,0);//end of line
	//CONTACT PERSON'S NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(10, 5, 'To:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $ColDates,0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	
	if (!empty($data['GRAD_Name of school'])){
		
		echo	$pdf->Cell(35, 5, 'Name of School:',0,0);
	echo	$pdf->SetFont('Arial','',10);
	echo	$pdf->Cell(75, 5, $data['GRAD_Name of School'],0,1);//end of line
	echo	$pdf->Cell(59, 5, '',0,1);
	echo	$pdf->SetFont('Arial','I',10);
	echo	$pdf->Cell(35, 5, 'Course:',0,0);
	echo	$pdf->SetFont('Arial','',10);
	echo	$pdf->Cell(75, 5, $data['GRAD_Degree Course'],0,1);//end of line
	echo	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(25	, 5, 'Scholarship:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $data['GRAD_Scholarship'],0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	$pdf->Cell(59, 5, '',0,1);
	$explodeGradDates = explode("-", $data['GRAD_Inclusive Dates of Attendance']);
	if (!empty($explodeGradDates[1])){
			$GradDates = $explodeGradDates[1];
		}
		else{
			$GradDates = "";
		}
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(10, 5, 'From:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(30, 5, $explodeGradDates[0],0,0);//end of line
	//CONTACT PERSON'S NUMBER
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(10, 5, 'To:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10, 5, $GradDates,0,1);
	$pdf->Cell(59, 5, '',0,1);//end of line
	}else{
		$pdf->Cell(59, 5, '',0,1);//end of line
	}
	//WORK EXPERIENCE
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Work Experience',0,1,"L");//END OF LINE
	$counter = 1;
	while($counter < 6){
		
			if(!empty($data[$counter.'. Inclusive Dates'])){
			$explodeSupervisor = explode("/", $data[$counter.'.3 Name_Position and Contact No. of Immediate Supervisor']);
			$explodeDates = explode("-", $data[$counter.'. Inclusive Dates']);
			$explodeCompany = explode("/", $data[$counter.'.1 Employer\'s Name, Address and Phone']);
				if (!empty($explodeSupervisor[2])) {
					$supervisorContact = $explodeSupervisor[2];
				}
				else{
					$supervisorContact = "";
				}
				if (!empty($explodeDates[1])) {
					$CompanyDate = $explodeDates[1];
				}
				else{
					$CompanyDate = "";
				}
				echo	$pdf->Cell(59, 5, '',0,1);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(35, 5, $counter,0,1);
				echo	$pdf->Cell(35, 5, 'Position Title:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $data[$counter.".2 Position Title"],0,1);//end of line
				echo	$pdf->Cell(59, 5, '',0,1);
				echo	$pdf->Cell(35, 5, 'Company Name:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $explodeCompany[0],0,1);
				$pdf->Cell(59, 5, '',0,1);
				$pdf->SetFont('Arial','I',10);
				$pdf->Cell(10, 5, 'From:',0,0);
				$pdf->SetFont('Arial','',10);
				$pdf->Cell(30, 5, $explodeDates[0],0,0);//end of line
				//CONTACT PERSON'S NUMBER
				$pdf->SetFont('Arial','I',10);
				$pdf->Cell(10, 5, 'To:',0,0);
				$pdf->SetFont('Arial','',10);
				$pdf->Cell(10, 5, $explodeDates[1],0,1);
				$pdf->Cell(59, 5, '',0,1);//end of line
				echo	$pdf->Cell(35, 5, 'Monthly Salary:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $data[$counter.'.4 Monthly Salary'],0,1);
				$pdf->Cell(59, 5, '',0,1);
				echo	$pdf->Cell(35, 5, 'Name of Supervisor:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $explodeSupervisor[0],0,1);
				$pdf->Cell(59, 5, '',0,1);
				echo	$pdf->Cell(35, 5, 'Contact No.:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $supervisorContact,0,1);
				$pdf->Cell(59, 5, '',0,1);
				echo	$pdf->Cell(35, 5, 'Reason of Leaving:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $data[$counter.'.5 Reason for Leaving'],0,1);
				$pdf->Cell(59, 5, '',0,1);
				
							
			}
			$counter++;
			
			
		}
		//Professional Qualifications
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Professional Qualifications',0,1,"L");//END OF LINE	
	$profCounter = 1;
			$profnumber = 1;

			while ($profCounter < 4) {
				if (!empty($data['PROF_License'.$profCounter])) {
					echo 
				$pdf->Cell(59, 5, '',0,1);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(40, 5, 'Liscense Certification:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $data['PROF_License'.$profCounter],0,1);
				$pdf->Cell(59, 5, '',0,1);
				echo	$pdf->Cell(30, 5, 'Liscense Number:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $data['PROF_Licensennum'.$profCounter],0,1);
					
				}
			$profCounter++;
			$profnumber++;
			}
			
	//LANGUAGE PROFICIENCY
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Language Proficiency',0,1,"L");//END OF LINE	
	$languages = ['ONE_','TWO_', 'THREE_', 'FOUR_', 'FIVE_'];
			foreach ($languages as $lang) {
				if (!empty($language[$lang.'LANGUAGE'])) {
					echo 
					$pdf->Cell(59, 5, '',0,1);
				echo	$pdf->Cell(35, 5, 'Language:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $language[$lang.'LANGUAGE'],0,0);
				
				echo	$pdf->Cell(35, 5, 'Speak:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $language[$lang.'SPEAK'],0,1);
					$pdf->Cell(59, 5, '',0,1);
				echo	$pdf->Cell(35, 5, 'Read:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $language[$lang.'READ'],0,0);
				
				echo	$pdf->Cell(35, 5, 'Write:',0,0);
				echo	$pdf->SetFont('Arial','',10);
				echo	$pdf->Cell(75, 5, $language[$lang.'WRITE'],0,1);
				}
			}
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Other Information',0,1,"L");//END OF LINE
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',10);
	$pdf->Cell(45, 5, 'Last Physical Check-up:',0,0);
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(30, 5, $data['Physical Checkup'],0,0);//end of line
	$pdf->Cell(59, 5, '',0,1);
	
	//CHARACTER REFERENCE
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Character Reference',0,1,"L");//END OF LINE
	$referenceCounter = "";

			while ($referenceCounter < 4) {
				if (!empty($data['REF_Name'.$referenceCounter])) {
					echo 
					$pdf->Cell(59, 5, '',0,1);
					$pdf->SetFont('Arial','I',10);
					$pdf->Cell(30, 5, 'Name:',0,0);
					$pdf->SetFont('Arial','',10);
					$pdf->Cell(30, 5, utf8_decode($data['REF_Name'.$referenceCounter]),0,0);//end of line
					$pdf->Cell(59, 5, '',0,1);
					$pdf->Cell(59, 5, '',0,1);
					echo	$pdf->Cell(35, 5, 'Company Name:',0,0);
					echo	$pdf->SetFont('Arial','',10);
					echo	$pdf->Cell(75, 5, utf8_decode($data['REF_Address'.$referenceCounter]),0,1);
					$pdf->Cell(59, 5, '',0,1);
					echo	$pdf->Cell(35, 5, 'Contact Number:',0,0);
					echo	$pdf->SetFont('Arial','',10);
					echo	$pdf->Cell(75, 5, $data['REF_ContactNum'.$referenceCounter],0,1);
					
				}
			$referenceCounter++;
			}
	//INTERVIEWER COMMENT
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Interviewer Comment',0,1,"L");//END OF LINE
	$pdf->Cell(59, 5, '',0,1);

	$commentsql =
"

		SELECT tbl_interview.Comment, tbl_interview.interviewerFirstname, tbl_interview.interviewerLastname, tbl_interview.interviewerMiddlename, tbl_application.REFERENCE_NO, tbl_application.id

		FROM tbl_interview, tbl_application

		WHERE tbl_interview.InterviewStage = 'Initial Interview' AND tbl_application.id = '$id' AND tbl_interview.ReferenceNo = tbl_application.REFERENCE_NO";



		$result = $conn->query($commentsql);

		$row = $result->fetch_assoc();

		echo 
		$pdf->SetFont('Arial','I',10);
		$pdf->Cell(30, 5, "Initial Interviewer:",0,0);
		$pdf->SetFont('Arial','',10);
		$pdf->Cell(60, 5, $row["interviewerLastname"].", ".$row["interviewerFirstname"]." ".$row["interviewerMiddlename"],0,1);//end of line
		$pdf->Cell(59, 5, '',0,1);
		//CONTACT PERSON'S NUMBER
		$pdf->SetFont('Arial','I',10);
		$pdf->MultiCell(175, 5, nl2br($row['Comment']),0,0);
		$pdf->Cell(59, 5, '',0,1);
	$commentsql2 = "

		SELECT tbl_interview.Comment, tbl_interview.interviewerFirstname, tbl_interview.interviewerLastname, tbl_interview.interviewerMiddlename, tbl_application.REFERENCE_NO, tbl_application.id

		FROM tbl_interview, tbl_application

		WHERE tbl_interview.InterviewStage = 'Second Interview' AND tbl_application.id = '$id' AND tbl_interview.ReferenceNo = tbl_application.REFERENCE_NO";



		$result = $conn->query($commentsql2);

		$row = $result->fetch_assoc();

		echo
			$pdf->SetFont('Arial','I',10);
			$pdf->Cell(30, 5, "Second Interviewer:",0,0);
			$pdf->SetFont('Arial','',10);
			$pdf->Cell(60, 5, $row["interviewerLastname"].", ".$row["interviewerFirstname"]." ".$row["interviewerMiddlename"],0,1);//end of line
			$pdf->Cell(59, 5, '',0,1);
			//CONTACT PERSON'S NUMBER
			$pdf->SetFont('Arial','I',10);
			$pdf->MultiCell(175, 5, nl2br($row['Comment']),0,0);
			$pdf->Cell(59, 5, '',0,1);
		



	$commentsql3 = "

		SELECT tbl_interview.Comment, tbl_interview.interviewerFirstname, tbl_interview.interviewerLastname, tbl_interview.interviewerMiddlename, tbl_application.REFERENCE_NO, tbl_application.id

		FROM tbl_interview, tbl_application

		WHERE tbl_interview.InterviewStage = 'Third Interview' AND tbl_application.id = '$id' AND tbl_interview.ReferenceNo = tbl_application.REFERENCE_NO";



		$result = $conn->query($commentsql3);

		$row = $result->fetch_assoc();

		echo
			$pdf->SetFont('Arial','I',10);
			$pdf->Cell(30, 5, "Third Interviewer:",0,0);
			$pdf->SetFont('Arial','',10);
			$pdf->Cell(60, 5, $row["interviewerLastname"].", ".$row["interviewerFirstname"]." ".$row["interviewerMiddlename"],0,1);//end of line
			$pdf->Cell(59, 5, '',0,1);
			//CONTACT PERSON'S NUMBER
			$pdf->SetFont('Arial','I',10);
			$pdf->MultiCell(175, 5, nl2br($row['Comment']),0,0);
			$pdf->Cell(59, 5, '',0,1);



	$commentsql4 = "

		SELECT tbl_interview.Comment, tbl_interview.interviewerFirstname, tbl_interview.interviewerLastname, tbl_interview.interviewerMiddlename, tbl_application.REFERENCE_NO, tbl_application.id

		FROM tbl_interview, tbl_application

		WHERE tbl_interview.InterviewStage = 'Final Interview' AND tbl_application.id = '$id' AND tbl_interview.ReferenceNo = tbl_application.REFERENCE_NO";



		$result = $conn->query($commentsql4);

		$row = $result->fetch_assoc();

		echo
			$pdf->SetFont('Arial','I',10);
			$pdf->Cell(30, 5, "Final Interviewer:",0,0);
			$pdf->SetFont('Arial','',10);
			$pdf->Cell(60, 5, $row["interviewerLastname"].", ".$row["interviewerFirstname"]." ".$row["interviewerMiddlename"],0,1);//end of line
			$pdf->Cell(59, 5, '',0,1);
			//CONTACT PERSON'S NUMBER
			$pdf->SetFont('Arial','I',10);
			$pdf->MultiCell(175, 5, nl2br($row['Comment']),0,0);
			$pdf->Cell(59, 5, '',0,1);
			
	//ESSAY PART
	$pdf->Cell(59, 5, '',0,1);
	$pdf->SetFont('Arial','I',12);
	$pdf->Cell(10, 5, 'Essay',0,1,"L");//END OF LINE
	$pdf->Cell(59, 5, '',0,1);
	$ref_number = $_GET['ref'];

						$cnt_res = $conn->query("SELECT * from tbl_application where REFERENCE_NO = '$ref_number'");

							

							while($row10 = $cnt_res->fetch_assoc()) {

								$myID = $row10['ID']; 

							}

						

							$cnt_res = $conn->query("SELECT * from tbl_question");

							$row_cnt = $cnt_res->num_rows;

							echo
							$pdf->SetFont('Arial','I',10);
							//$pdf->Cell(59, 5, $row_cnt,0,1);'<input type="hidden" id="question_count" name="question_count" value="'.$row_cnt.'">';

							$cnt = 1;

							

							while($row4 = $cnt_res->fetch_assoc()) {

									$question = utf8_encode($row4['Question']);

									$questionID = $row4['Question_ID'];

								$get_ans = $conn->query("SELECT * from tbl_essay where Question_ID = '$questionID' and APPLICANT_ID = '$myID'");

								if($get_ans->num_rows > 0){

									while($row5 = $get_ans->fetch_assoc()) {

										$answer = $row5["Answer"];

										echo
										$pdf->Cell(59, 5, '',0,1);
										$pdf->SetFont('Arial','B',11);
										$pdf->Cell(10, 5, $cnt,0,0);
										
										$pdf->Cell(30, 5, $question,0,0);//end of line
										$pdf->Cell(59, 5, '',0,1);
										$pdf->Cell(59, 5, '',0,1);
										$pdf->SetFont('Arial','',11);
										$pdf->Cell(15, 5, 'Answer:',0,0);
										$pdf->MultiCell(175, 5, $answer,0,1);

										$cnt++;
									}
									
								}else{

								for ($x = 1; $x <= 4; $x++) {

									echo
									$pdf->Cell(59, 5, '',0,1);
										$pdf->SetFont('Arial','I',10);
										$pdf->Cell(30, 5, $question,0,0);
										$pdf->SetFont('Arial','',10);
										$pdf->Cell(30, 5, $question,0,0);//end of line
										$pdf->Cell(59, 5, '',0,1);
										$pdf->Cell(59, 5, '',0,1);
										echo	$pdf->Cell(35, 5, '',0,0);
									
								}

							}
						}			
		
		$pdf->Output();
		
		
		
		
		
		
	}



?>