<?php
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 06/02/2016
 * Time: 3:29 PM
 */
session_start();
$matNo=$_SESSION['matNo'];
require_once('../../connect.php');
$db=db_connect();
$sql=$db->query("select * from realdata where matNo='$matNo'");
$sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
$num=$sql->rowCount();

$sql2=$db->query("select * from siwesbiodata where matNo='$matNo'");
$sql2_fetch=$sql2->fetch(PDO::FETCH_BOTH);
$num2=$sql2->rowCount();
$placementName=$sql2_fetch['placementName'];
$eAddress=$sql2_fetch['eAddress'];
$companyName=$sql2_fetch['companyName'];

if ($num==1){
    $matNo=$sql_fetch['matNo'];
    $phoneNo=$sql_fetch['gsm'];
    $fullName=explode(' ',($sql_fetch['names']));
    $surname=strtoupper($fullName[0]);
    $othernames=$fullName[1].' '.$fullName[2];
    $sex=$sql_fetch['sex'];
    $dept=$sql_fetch['course'];
    if ($sex=='Male') {
        $title = 'Mr.';
        $tiH='his';
    }else{
        $title = 'Miss.';
        $tiH='her';
    }

   // $k=count($fullName);
}
$mainBody=
'<img src="../../images/siwesHead.png">
     <div style="font-size: 17px"><h2 align="center"><p></p><BR>
STUDENTS INDUSTRIAL WORK EXPERIENCE <br>SCHEME (SIWES)</h2>
    1. Name of student: <b>'. $surname .' '.$othernames.'</b><p>
    2. Department: <b>'.$dept. '</b>  &nbsp;&nbsp;&nbsp;&nbsp; Matric No: <b>'.$matNo.'</b><p>
    3. Name and Street Address of Establishment:<b> '.$companyName.', '.$eAddress.'</b><p>
    4. Phone No: <b>'.$phoneNo.'</b><p>
    <b><i>The above named student has been given a place for '.$tiH.' SIWES programme in our establishment.</i></b><p>
    <b>OFFICER IN CHARGE:<b><p>
    NAME:_________________________________________________________________________<p>
    POST:_________________________________________________________________________<p>
    SIGN & STAMP:_________________________________________________________________<p>
   <hr><p></p><b>  Please return this sheet to:<p>
    SIWES DIRECTOR<br>
    FEDERAL POLYTECHNIC,<br>
    P.M.B. 231<br>
    EDE, OSUN STATE<p></div>

    ';
$dat=date('l, M d, o, h:i:s a');
$customizedFooter='<img src="../../images/siwesfooter.png"><br><div align="right">'. $dat.'</div>';

include("../../mpdf/mpdf.php");
$mpdf=new mPDF('c');

$mpdf->setFooter($customizedFooter) ;
$mpdf->WriteHTML($mainBody);
$mpdf->Output();
exit;

?>