| Server IP : 172.64.80.1 / Your IP : 108.162.241.67 Web Server : Apache System : Linux mail.federalpolyede.edu.ng 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64 User : federalpolyede.edu.ng_idh35skikv ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/federalpolyede.edu.ng/httpdocs_backup/admin_student/ |
Upload File : |
<?php
ob_start();
session_start();
$mainBody='
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ePortal | Library Form</title>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>
<body>';
$matNo=$_SESSION['matNo'];
require_once('../../connect.php');
$db=db_connect();
$asession=$_SESSION['asession'];
$scholar = $db->query("select * from scholar where matNo='$matNo' and asession='$asession'");
$scholar_count = $scholar->rowCount();
$sqlBank="select * from remitaorder where regNo='$matNo'and paymenttype='School Fees'";
$resultBank=$db->query($sqlBank);
$countBank=$resultBank->rowCount();
if (($countBank>0) or ($scholar_count==1)){
$biodataSQL="select * from realdata where matNo='$matNo'";
$biodataResult=$db->query($biodataSQL);
$biodataNum=$biodataResult->rowCount();
$biodataResult_fetch=$biodataResult->fetch(PDO::FETCH_BOTH);
$formNo=$biodataResult_fetch['formNo'];
$asession=$_SESSION['asession'];
$asemester=$_SESSION['asemester'];
$mainBody.='
<table width="100%" align="center" cellpadding="3" cellspacing="5">
<tr>
<td><table width="100%" cellspacing="1" cellpadding="1">
<tr>
<td valign="top"><table width="100%" cellspacing="1" cellpadding="1">
<tr>
<td align="center" valign="top"><p><img src="../../images/siwesHead.png" width="100%" height="95" /></p></td>
</tr>
<tr>
<!--<td align="center" bgcolor="#CCCCCC"><strong id="cen"> LIBRARY ACCESS FORM</strong></td>-->
</tr>
</table></td>
</tr>
<tr>
<td><!--<table width="100%" cellspacing="5" cellpadding="1">
<tr>
<td colspan="7" align="center" id="lab"><em>Note: This form will be required each time you want to make use of the school library.</em></td>
</tr>
<tr>
<td colspan="1">Matric No.</td>
<td > </td>
<td>'.$matNo.'</td>
<td colspan="4" rowspan="4" align="center"><img src="../../passport/Reg'. $matNo.'.jpg" alt="" width="115" height="125" /></td>
</tr>
<tr>
<td colspan="1" id="lab"> Reg No.</td>
<td colspan="1"> </td>
<td colspan="1">'. $biodataResult_fetch['formNo'].'</td>
</tr>
<tr>
<td colspan="1" id="lab">Name</td>
<td> </td>
<td colspan="1"><b><H3>'. strtoupper($_SESSION['names']).'</H3></b></td>
</tr>
<tr>
<td colspan="1" id="lab">Session</td>
<td> </td>
<td colspan="1">'. $asession.'</td>
</tr>
<tr>
<td colspan="1" id="lab">Semester</td>
<td> </td>
<td colspan="1">'.$asemester.'</td>
</tr>
<tr>
<td >Department</td>
<td> </td>
<td>'.$_SESSION['course'].'</td>
<td> </td>
<td >Level</td>
<td > </td>
<td>-->
';
$levelID= $_SESSION['levelID'];
$sqlLevel=$db->query("select * from leveltb where id='$levelID'");
$numLevel=$sqlLevel->rowCount();
$sqlLevel_fetch=$sqlLevel->fetch(PDO::FETCH_BOTH);
$_SESSION['asemester']='Second Semester';
if ($numLevel>0){
//$mainBody.=$sqlLevel_fetch['levelName'];
}else{
// $mainBody.='No Level Attached';
}
$mainBody.='</td>
</tr>
<tr>
<!-- <td id="lab">Date of Birth</td>
<td> </td>
<td>'. $biodataResult_fetch['dob'].'</td>
<td> </td>
<td id="lab">Phone No.</td>
<td> </td>
<td>'.$biodataResult_fetch['gsm'].'</td>
</tr>
<tr>
<td id="lab">Sex</td>
<td> </td>
<td>'. $biodataResult_fetch['sex'].'</td>
<td> </td>
<td id="lab">State</td>
<td> </td>
<td>'. $biodataResult_fetch['state'].'</td>
</tr>
<tr>
<td id="lab">L.G.A.</td>
<td> </td>
<td>'.$biodataResult_fetch['lga'].'</td>
<td> </td>
<td id="lab">E-Mail</td>
<td> </td>
<td>'. $biodataResult_fetch['email'].'</td>
</tr>
<tr>
<td id="lab">Address</td>
<td> </td>
<td>'. $biodataResult_fetch['address'].'</td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="4" ><p>Student\'s Signature:_____________________</p></td>
<td colspan=3>H.O.D\'s Comment &Sign.:__________________</p></td>
</tr>
<tr>
<td colspan="7" bgcolor="#666666" id="headingg">LIBRARY ACCESS CERTIFICATE( '.$_SESSION['asession'].' SESSION)</td>
</tr>
</table></td>
</tr>
<tr>
<td>
<table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td colspan="7" ><table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td><em><strong>Circulation Librarian</strong></em></td>
</tr>
<tr>
<td colspan="3">Date Received:_________________</td> <td colspan="4">Name:_______________________</td>
</tr>
<tr>
<td colspan="3">Result of Application:_________________</td>
<td colspan="4">Sign:_________________________</td>
</tr>
<tr>
<td colspan="7" align="right"><hr /></td>
</tr>
<tr>
<td colspan="7" align="right">www.federalpolyede.edu.ng - '. date('d M, o').'</td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="7" align="center" bgcolor="#FFFFFF"><hr style="border-bottom-style:dashed" /></td>-->
</tr>
<tr>
<td colspan="7" bgcolor="#FFF000" align="center"><h3>CLASS ATTENDANCE CLEARANCE ( '.$_SESSION['asemester'].' - '. $_SESSION['asession'].' SESSION)</h3></td>
</tr>
<tr><td> </td></tr>
<tr>
<td colspan="6" align="justify" ><div style="font-size: 25px" ><p>This is to certify that <b>'. strtoupper($_SESSION['names']).'</b> of '.$_SESSION['course']. '-
';
/*$levelID= $_SESSION['levelID'];
$sqlLevel=$db->query("select * from leveltb where id='$levelID'");
$sqlLevel_fetch
$numLevel=$sqlLevel->rowCount();
*/
if ($numLevel>0){
$mainBody.=$sqlLevel_fetch['levelName'];
}else{
$mainBody.='No Level Attached';
}
$mainBody.='
with Registration Number '. $matNo.' has completed all registration and is hereby certified to attend classes.</p>
</td><td> </td><td rowspan="6" colspan="1" valign="top"><img src="../../passport/Reg'.$matNo.'.jpg" alt="" width="115" height="125" /></td></tr>
<tr><td>
<table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td ><h3>SCHOOL OFFICER</h3></td>
<td > </td>
</tr>
<tr>
<td>Name:____________________ </td>
<td>Sign and Stamp:'.date('d M, o').'</td>
</tr>
</table></td>
</tr>
</div>
</table></td>
</tr>
<tr>
<td colspan="5"><table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td align="right"><hr /></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
';
}else{
$mainBody.=header('location:'.'schoolFee.php');
}
$mainBody.='
</body>
</html>';
include("../../mpdf/mpdf.php");
$mpdf=new mPDF('c','A5');
$mpdf->AddPage('L','','','','',5,5,5,5,5,5);
$mpdf->SetWatermarkImage('../../images/logoBack.png');
$mpdf->showWatermarkImage = true;
$dat=date('l, M d, o, h:i:s a');
$customizedFooter='<img src="../../images/siwesfooter.png"><br><div align="right">'. $dat.'</div>';
$mpdf->WriteHTML($mainBody);
$mpdf->setFooter($customizedFooter) ;
$mpdf->Output();
exit;
ob_end_flush();
?>