<?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();
if ($num==1){
    $matNo=$sql_fetch['matNo'];
    $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.';
    }else{
        $title = 'Miss.';
    }

   // $k=count($fullName);
}
$mainBody=
    '<img src="../../images/siwesHead.png">
<p>____________________________<p>
    ____________________________<p>
    ____________________________<p>
    Dear Sir/Ma,<p>
   <strong> <h2>STUDENT INDUSTRIAL WORK EXPERIENCE SCHEME</h2></strong>
   <div style="font-size: 17px">
   <p align="justify">
   We are pleased to introduce  <b>'.$title.' '.$surname.' '.$othernames.'</b> a Student of <b>'.$dept.'</b> Department in this Polytechnic to your establishement for suitable placement for the Students\' Industrial Work Experience Scheme (SIWES).
   <p align="justify"> The Scheme which is for a period of four months is a requirement for the award of National Diploma in the Institution. The tentative SIWES 2017 period shall be ...... to ..... .
   During which the students are expected to work Monday to Friday and within the working hour not exceeding eight (8) hours excluding nights unless those arranged exclusively with students. <p align="justify">Kindly endorse and stamp the attached form and return same to us.
    <p> Thank you for your kind consideration.
    <p>
    <p>
    Yours faithfully,
    <p>
    <br>
    <img src="../../images/siwesSign.jpg" width="60px" height="40px"><br>
    Engr. Dr. A. S. Amusan
    <br> SIWES Director
</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->WriteHTML($mainBody);
$mpdf->setFooter($customizedFooter) ;
$mpdf->Output();
exit;

?>