| Server IP : 172.64.80.1 / Your IP : 172.70.131.126 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_main/ |
Upload File : |
<?php
ob_start();
session_start();
/*$asession=$_SESSION['asession'];
$asemester=$_SESSION['asemester'];
require_once('../../connect.php');
$db=db_connect();
$levelID= $_SESSION['levelID'];
*/
$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 | Courses Registered</title>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>
<body>';
//$matNo=$_SESSION['matNo'];
$mainBody.='
<table width="100%" align="center" cellpadding="3" cellspacing="5">
<tr>
<td >
<table align="center" cellpadding="1" cellspacing="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" alt="Federal Polytechnic Ede" /></p></td>
</tr>
<tr>
<td align="center"><h3>STUDENT INDUSTRIAL WORK EXPERIENCE SCHEME (SIWES)<br>2017 PLACEMENT LIST</h3></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td colspan="7">';
require_once('../connect.php');
$db=db_connect();
$mainBody.='</td>
</tr>
</table></td>
</tr>
<tr>
<td>
<table border="1" cellpadding="3" cellspacing="0" style="font-size: smaller">
<tr>
<td colspan="6"></td>
</tr>
<tr>
<td ><strong>SN</strong></td>
<td ><strong>Name of Student</strong></td>
<td colspan="1" ><strong>Matric No</strong></td>
<td ><strong>Course of Study</strong></td>
<td ><strong>Level of study</strong></td>
<td ><strong>Attachement Period</strong></td>
<td ><strong>Placement</strong></td>
</tr>
';
$sqlCourse=$db->query("select * from siwesbiodata");
$numCourse=$sqlCourse->rowCount();
if ($numCourse>0){
$i=0;
while ($row=$sqlCourse->fetch(PDO::FETCH_BOTH)){
$matNo=$row['matNo'];
$sql_data=$db->query("select * from realdata where matNo='$matNo' and matNo not like '%dpt%'");
$sql_fetch=$sql_data->fetch(PDO::FETCH_BOTH);
if ($sql_data->rowCount()>0) {
$mainBody .= '
<tr>
<td>' . $i . '</td>
<td>' . $sql_fetch['names'] . '</td>
<td colspan="1">' . $sql_fetch['matNo'] . '</td>
<td colspan="1">' . $sql_fetch['course'] . '</td>';
$level = $sql_fetch['levelID'];
$levelData = $db->query("select * from leveltb where id='$level'");
$level_fetch = $levelData->fetch(PDO::FETCH_BOTH);
$levelName = $level_fetch['levelName'];
$mainBody .= '
<td>' . $levelName . '</td>
<td>'.$row['fromYear'].'-'.$row['toYear'].'</td>
<td>'.$row['companyName'].'</td>
</tr>';
//if ($i==500){
// break;
}
++$i;
}
$mainBody.='
<tr>
<td colspan="4" align="right"><B>TOTAL REGISTERED</B></td>
<td colspan="3"><B>'. $i.'</B></td>
<td> </td>
</tr>';
}else{
$mainBody.='
<tr>
<td colspan="6">
No Student Registered Yet!
</td>
</tr>
';
}
$mainBody.='
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>';
//echo $mainBody;
include("../mpdf/mpdf.php");
$mpdf=new mPDF('c');
$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->mirrorMargins = true;
$mpdf->SetDisplayMode('fullpage','two');
$mpdf->WriteHTML($mainBody);
$mpdf->setFooter($customizedFooter) ;
$mpdf->Output();
exit;
ob_end_flush();
?>