<?php 
include ("include/makeSession.php");
require('fpdf/fpdf.php');

$pdf = new FPDF();
$pdf->AddPage('P');

 $student_id=$_REQUEST['id'];

if(!empty($student_id)){ 
                    $studentQ=mysqli_query($con,"select admission_enquiry_form.photos,admission_enquiry_form.email,admission_enquiry_form.dob,admission_enquiry_form.address,admission_enquiry_form.name,admission_enquiry_form.fname,
                    admission_enquiry_form.student_id,
                    admission_enquiry_form.mobileno,course.c_name,commenacademicyear.academictitle,commenacademicyear.academicenddate from admission_enquiry_form
                    left join course on course.id=admission_enquiry_form.course
                    left join commenacademicyear on commenacademicyear.id=admission_enquiry_form.academicyear
                    where student_id='".$student_id."'");
                     $studentR=mysqli_fetch_array($studentQ);
                
				$collage=mysqli_query($con,"select * from collageinfo" );
	            $collage=mysqli_fetch_array($collage);
	            
	            $addressss = explode(",",ucwords($collage['collageaddr']));
	            
	           // print_r($studentR); exit;
	            
	            //$photo = "images/StudentEnquiry/".$studentR['photos'];
	            
	            //
	             /*---------------------------1st  BLOCK-------------------------- */
	             $pdf->SetDrawColor(17,12,162);
	             $pdf->cell(89,51,"",1,0,'C');
	             $pdf->SetLineWidth(0.1);
                $pdf->SetFillColor(17,12,162);
	            $pdf->RoundedRect(10,9,89, 12, 1.5,'12', 'DF');
	            
	            $pdf->SetTextColor(255,255,255);
	            $pdf->SetFont('Arial','B',10.5);
                $pdf->text(12,15,$collage['collagename'],'C');
                
                $pdf->text(45,20,"ESTD: 2012",'C');
                 
                $pdf->SetTextColor(17,12,162); 
                $pdf->SetFont('Arial','',6.7);
                $pdf->text(12,25.5,"AT: AKALPOUSH, P.O-AKALPOUSH, P.S-DEBRA, DIST-PASCHIM MEDINIPUR",'C');
                
                $pdf->SetDrawColor(17,12,162);
                $pdf->SetFont('Arial','B',10);
                $pdf->SetLineWidth(0.3);
                $pdf->Line(10,27,99,27);
                
                $pdf->SetTextColor(216,88,14); 
                $pdf->SetFont('Arial','B',10.5);
                $pdf->text(13,31.5,$studentR['name'],'L');
                $pdf->ln(22.5);
                $pdf->SetTextColor(17,12,162); 
                $pdf->SetDrawColor(255,255,255);
                $pdf->SetFont('Arial','B',8);
                $pdf->SetWidths(array(68));
                $pdf->cell(2);
                $pdf->Row(array(trim($studentR['address'])));
                $pdf->SetFillColor(255,255,255);
                $pdf->SetDrawColor(17,12,162);
                $pdf->RoundedRect(79,32,20, 23, .5,'1234', 'DF');
                
                 $pdf->SetTextColor(216,88,14); 
                $pdf->SetFont('Arial','B',7.5);
                //$pdf->text(10,31.5,$studentR['name'],'L');
                $pdf->cell(2);
                $pdf->cell(20,3,"Date of Birth:".$studentR['dob'],0,1,'L');
                $pdf->cell(2);
                $pdf->cell(20,3,"Course:".$studentR['c_name']."(".$studentR['academictitle'].")",0,1,'L');
                $pdf->cell(2);
                $pdf->cell(20,3,"Student ID:".$studentR['student_id'],0,1,'L');
                $pdf->cell(2);
                $pdf->cell(20,3,"Mob:".$studentR['mobileno'],0,1,'L');
                //$pdf->cell(20,3,"Email:".$studentR['email'],0,1,'L');
                
                $pdf->SetTextColor(17,12,162);
                $pdf->SetFont('Times','I',8);
                $pdf->text(11,57,"Candidate Signature");
                
                 $pdf->text(50,57,"Secretary Signature");
                 //$pdf->text(13,63,"Student Signature",'L');
                 
                 
                $pdf->SetFillColor(17,12,162);
                $pdf->SetDrawColor(17,12,162);
                $pdf->RoundedRect(10,59,89, 5, 1.5,'34', 'DF');
	            
                
                
                /*---------------------------End of 1st  BLOCK-------------------------- */
                
                
	            $pdf->cell(10);
	            
	            
	            
	            
                
	  
	  
}

$pdf->Output();
			
?>