| 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/admin_main/ |
Upload File : |
<?php
ob_start();
ini_set('memory_limit', '512M');
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>2018 PLACEMENT LIST</h3></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td colspan="7">';
require_once('../connect.php');
$db=db_connect();
if (isset($_GET['start'])){
if (($_GET['start']) and ($_GET['start'])){
$start=$_GET['start'];
$end=$_GET['end'];
$ko=$end-$start+1;
}else{
$start=1;
$end=200;
$ko=$end-$start+1;
}
}else{
$start=1;
$end=200;
$ko=$end-$start+1;
}
$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>Bank Name</strong></td>
<td ><strong>Account No</strong></td>
<td ><strong>ISW Code</strong></td>
<td ><strong>Attachement Period</strong></td>
<td ><strong>Name & Address of Employer</strong></td>
</tr>
';
$sqlCourse=$db->query("select * from siwesbiodata order by matNo");
$numCourse=$sqlCourse->rowCount();
if ($numCourse>0){
$i=1;
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) {
if (($i>=$start) and ($i<=$end)){
$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['bankName'].'</td>
<td>'.$row['AccountNo'].'</td>';
$bank=$row['bankName'];
$bankData = $db->query("select * from bankdetail where bank_name='$bank'");
$bank_fetch = $bankData->fetch(PDO::FETCH_BOTH);
$bankCode = $bank_fetch['isw_code'];
$mainBody .= ' <td>'.$bankCode.'</td>
<td>'.$row['fromYear'].' To '.$row['toYear'].'</td>
<td>'.$row['companyName'].$row['eAddress'].'</td>
</tr>';
// if ($i==500){
// break;
}
++$i;
}
}
$i2=$i-1;
$mainBody.='
<tr>
<td colspan="4" align="right"><B> </B></td>
<td colspan="3"><B> Total Number of Records = '. $i2.'</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();
?>