| Server IP : 172.64.80.1 / Your IP : 172.69.7.193 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/entranceform/ |
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 | Biodata</title>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>
<body size="7" >
';
require_once('../connect.php');
$db=db_connect();
$matNo=$_SESSION['formNo'];
$deptID= $_SESSION['dept'];
$sqlDept="select * from dept where sn='$deptID'";
$ResultDept=$db->query($sqlDept);
$sqlDept_fetct=$ResultDept->fetch(PDO::FETCH_BOTH);
$deptName=$sqlDept_fetct['dOption'];
$biodataSQL="select * from stddata where formNo='$matNo'";
$biodataResult=$db->query($biodataSQL);
$biodataNum=$biodataResult->rowCount();
$biodataResult_fetch=$biodataResult->fetch(PDO::FETCH_BOTH);
$formNo=$biodataResult_fetch['formNo'];
$formTypea=$biodataResult_fetch['level'];
$adm=$biodataResult_fetch['admStatus'];
$jambNo=$biodataResult_fetch['jambNo'];
$admittedSQL=$db->query("select * from admitted where formNo='$matNo' or formNo='$jambNo'");
$admittedSQL_num=$admittedSQL->rowCount();
$adm=$admittedSQL_num;
switch($adm) {
case 1:
$admStatus = 'Admitted';
break;
default:
$admStatus = 'Not Admitted Yet';
}
$sqlNOK="select * from otherinfo where formNo='$formNo'";
$ResultNOK=$db->query($sqlNOK);
$sqlNOK_fetct=$ResultNOK->fetch(PDO::FETCH_BOTH);
$nameNOK=$sqlNOK_fetct['nName'];
$addressNOK=$sqlNOK_fetct['nAddress'];
$GSMNOK=$sqlNOK_fetct['nGsm'];
if ($formTypea=='preForm'){
$formType='Pre National Diploma';
}elseif ($formTypea=='hndForm') {
$formType = 'Higher National Diploma (Full Time)';
}elseif ($formTypea=='utmeForm') {
$formType = 'National Diploma (FT) Screening';
}elseif ($formTypea=='dptForm') {
$formType = 'National Diploma (Daily Part Time)';
}elseif ($formTypea=='ptForm') {
$formType = 'National Diploma (Regular Part Time)';
}
$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="731" height="95" /><br />
</p></td>
</tr>
<tr>
<td align="center" bgcolor="#CCCCCC"><strong id="cen"><h2>APPLICANT FORM</h2></strong></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" cellpadding="0" cellspacing="3">
<tr>
<td width="22%" colspan="1" id="lab"><b>Application No.</b></td>
<td width="1%"> </td>
<td colspan="3">'. $matNo.'</td>
<td width="31%" rowspan="4" colspan="2"><img src="../passportForm/'. $matNo.'.jpg" alt="" width="105" height="115" /></td>
</tr>
<tr>
<td colspan="1" id="lab"><b>Form Type</b></td>
<td> </td>
<td colspan="3"><strong>'. $formType.'</strong></td>
</tr>
<tr>
<td colspan="1" id="lab"><b>Full Name</b></td>
<td> </td>
<td colspan="3"><b><H4>'. strtoupper($biodataResult_fetch['surname'].' '. $biodataResult_fetch['otherNames']).'</H4></b></td>
</tr>
<tr>
<td colspan="1" id="lab"><b>Department</b></td>
<td> </td>
<td colspan="3">'.$biodataResult_fetch['dept'].'</td>
</tr>
<tr>
<td colspan="1" id="lab"><b>Phone No.</b></td>
<td> </td>
<td colspan="3">'.$biodataResult_fetch['gsm'].'</td>
</tr>';
if (($formTypea=='utmeForm') or($formTypea=='hndForm')) {
$mainBody .= ' <tr>
<td id="lab"><b>Jamb Reg. No.</b></td>
<td> </td>
<td width="26%">' . $biodataResult_fetch['jambNo'] . '</td>
<td width="18%" id="lab"><b>Jamb Score</b></td>
<td width="2%"> </td>
<td >' . $biodataResult_fetch['jambScore'] . '
</td>
</tr>';
}
$mainBody.='
<tr>
<td id="lab"><b>E-Mail</b></td>
<td> </td>
<td width="26%">'. $biodataResult_fetch['email'].'</td>
<td width="18%" id="lab"><b>Date of Birth</b></td>
<td width="2%"> </td>
<td >'.$biodataResult_fetch['dob'].'
</td>
</tr>
<tr>
<td id="lab"><b>State</b></td>
<td> </td>
<td>'. $biodataResult_fetch['state'].'</td>
<td id="lab"><b>LGA</b></td>
<td> </td>
<td >'.$biodataResult_fetch['lga'].'</td>
</tr>
<tr>
<td id="lab"><b>Sex</b></td>
<td> </td>
<td>'.$biodataResult_fetch['sex'].'</td>
<td id="lab"><b>Marital Status</b></td>
<td> </td>
<td >'.$biodataResult_fetch['maritalStatus'].'</td>
</tr>
<tr>
<td id="lab2"><b>Next of Kin</b></td>
<td> </td>
<td>'. $nameNOK.','.$addressNOK.'</td>
<td id="lab2"><strong>Admission Status</strong></td>
<td> </td>
<td colspan="2" style="color:blue; font-size:20px">'.$admStatus.'</td>
</tr>
<tr>
<td colspan="7" bgcolor="#CCCCCC" id="headingg"><b>O\' LEVEL RESULT</b></td>
</tr>
</table></td>
</tr>
<tr>
<td>
<table width="100%" cellpadding="0" cellspacing="3">
<tr>
<td colspan="5">
<table width="100%" cellspacing="5" cellpadding="3">';
$sql3="select * from preolevel where formNo='$matNo'";
$result3=$db->query($sql3);
$num3=$result3->rowCount();
$result3_fetch=$result3->fetch(PDO::FETCH_BOTH);
if ($num3>0){
$k=$result3_fetch['olevel1'];
$olevel=explode(',',$k);
$count=count($olevel);
$k2=$result3_fetch['olevel2'];
$olevel2=explode(',',$k2);
$count2=count($olevel2);
//echo mysql_result($result3,0,'olevel1')
$mainBody.='
<tr>
<td><table width="100%" cellspacing="5" cellpadding="0">
<tr><td><b>Exam Type: </b></td><td>'.$result3_fetch['eType1'].'</td></tr>
<tr><td><b>Exam Number: </b></td><td>'.$result3_fetch['examNo1'].'</td></tr>
<tr><td><b>Exam Date: </b></td><td>'.$result3_fetch['eYear1'].'</td></tr>
<tr><td colspan="2"><hr></td></tr>
';
for ($a=0;$a<$count-1;++$a){
$splitOlevel=explode('-',$olevel[$a]);
$mainBody.= '<tr><td>'.$splitOlevel[0].'</td><td>'.$splitOlevel[1].'</td>';
}
$mainBody.='</td></tr>
</table></td>
<td><table width="100%" cellspacing="5" cellpadding="0">
<tr>
<td>';
if ($result3_fetch['examNo2']!=''){
$mainBody.= '
<tr>
<td><table width="100%" cellspacing="5" cellpadding="0">
<tr><td><b>Exam Type: </b></td><td>'.$result3_fetch['eType2'].'</td></tr>
<tr><td><b>Exam Number: </b></td><td>'.$result3_fetch['examNo2'].'</td></tr>
<tr><td><b>Exam Date: </b></td><td>'.$result3_fetch['eYear2'].'</td></tr>
<tr><td colspan="4"><hr></td></tr>
';
}
$mainBody.='</td>
</tr>
<tr>
<td>';
if ($result3_fetch['noOfResult']==2){
for ($a=0;$a<$count2-1;++$a){
$splitOlevel2=explode('-',$olevel2[$a]);
$mainBody.= '<tr><td>'.$splitOlevel2[0].'</td><td>'.$splitOlevel2[1].'</td></tr>';
}
// $mainBody.= '';
}
}else{
$mainBody.= '<h1><b>Update Your O\'Level</b></h1>';
}
$mainBody.='</td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>' ;
if($formTypea=='hndForm'){
$sql_nd=$db->query("select * from ndresult where formNo='$formNo'");
$sql_nd_fetch=$sql_nd->fetch(PDO::FETCH_BOTH);
$sql_nd_count=$sql_nd->rowCount();
if ($sql_nd_count>0){
$inst=$sql_nd_fetch['inst'];
$ndMatNo=$sql_nd_fetch['rMatNo'];
$grade=$sql_nd_fetch['result'];
$gYear=$sql_nd_fetch['rYear'];
$itName=$sql_nd_fetch['itName'];
$itAddress=$sql_nd_fetch['itAddress'];
}else{
$inst='Nil';
$ndMatNo='Nil';
$grade='Nil';
$gYear='Nil';
$itName='Nil';
$itAddress='Nil';
}
$mainBody.='
<tr>
<td colspan="8" bgcolor="#CCCCCC" id="headingg"><b>ND INFORMATION</b></td>
</tr>
<tr>
<td colspan="8"><table>
<tr><td><b>Institution</b></td>
<td> </td>
<td>'.$inst.'</td>
<td ><b>Matric No</b></td>
<td> </td>
<td>'.$ndMatNo.'</td>
</tr>
<tr>
<td id="lab"><b>Grade</b></td>
<td> </td>
<td>'.$grade.'</td>
<td id="lab"><b>Year of Graduated</b></td>
<td> </td>
<td>'.$gYear.'</td>
</tr>
<tr>
<td id="lab"><b>IT Placement</b></td>
<td> </td>
<td>'.$itName.'</td>
<td id="lab"><b>Address</b></td>
<td> </td>
<td>'.$itAddress.'</td>
</tr></table>';
}
//echo $formNo;
$sql_venue=$db->query("select * from venuetb where formNo='$formNo'");
$sql_venue_num=$sql_venue->rowCount();
if ($sql_venue_num>0) {
$sql_venue_fetch = $sql_venue->fetch(PDO::FETCH_BOTH);
$dayID = $sql_venue_fetch['examDay'];
$venueID = $sql_venue_fetch['venue'];
$sessionID = $sql_venue_fetch['examSession'];
switch ($dayID) {
case 1:
$day = 'DAY 1 - (Wednesday, 4th October, 2017)';
break;
case 2:
$day = 'DAY 2 - (Thursday, 5th October, 2017)';
break;
case 3:
$day = 'DAY 3 - (Friday, 6th October, 2017)';
break;
case 4:
$day = 'DAY 4 - (Saturday, 7th October, 2017)';
break;
}
switch ($venueID) {
case 'South':
$venue = 'South Campus, ICT Center';
break;
case 'North':
$venue = 'North Campus, eace_edia Center';
break;
}
switch ($sessionID) {
case 1:
$sTime = 'Session 1 - (8:00 am - 1:00 pm)';
break;
case 2;
$sTime = 'Session 2 - (8:00 am - 1:00 pm)';
break;
case 3:
$sTime = 'Session 3 - (8:00 am - 1:00 pm)';
break;
case 4;
$sTime = 'Session 4- (12:00 Noon- 4:00 pm)';
break;
case 5:
$sTime = 'Session 5 - (12:00 Noon- 4:00 pm)';
break;
case 6;
$sTime = 'Session 6 - (12:00 Noon- 4:00 pm)';
break;
case 7;
$sTime = 'Session 7 - (12:00 Noon- 4:00 pm)';
break;
}
$mainBody .= '</table><table width="100%">
<tr>
<td colspan="8" bgcolor="#CCCCCC" id="headingg"><b>SCREENING TEST INFORMATION</b></td>
</tr>
<tr>
<td><b>Day:</b></td>
<td> </td>
<td>' . $day . '</td>
</tr>
<tr>
<td id="lab"><b>Venue:</b></td>
<td> </td>
<td>' . $venue . '</td>
</tr>
<tr>
<td id="lab"><b>Session/Time</b></td>
<td> </td>
<td>' . $sTime . '</td>
</tr>';
}
$sql_score=$db->query("select * from cbtscore where formNo='$formNo'");
$sql_score_num=$sql_score->rowCount();
if ($sql_score_num>0) {
$sql_score_fetch = $sql_score->fetch(PDO::FETCH_BOTH);
$score = $sql_score_fetch['score'];
$mainBody.='<tr>
<td id="lab"><b>Total Score</b></td>
<td> </td>
<td>'.$score.'%</td>
</tr>
</table>';
}
$mainBody.='<tr>
<td height="25" colspan="8" bgcolor="#CCCCCC" id="headingg"><b>NOTICE</b></td>
</tr>
<!-- <tr>
<td colspan="5" valign="top"><p>Original Certificate or Result Slip of SSCE, NECO or NABTEB ONLY will be accepted for the Screening.</p>
</td>
</tr>-->
<tr>
<td id="lab" colspan="8" style="font-size:15px">* Kindly come along to the examination venue with the printout of this slip.</td>
<td> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>';
//echo $mainBody;
include("../mpdf/mpdf.php");
$mpdf=new mPDF('c');
$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();
?>