| Server IP : 172.64.80.1 / Your IP : 172.69.58.211 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 : |
<!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 | Admission List</title>
</head>
<?php
session_start();
require_once('../connect.php');
$db=db_connect();
extract($_POST);
$dept=$_POST['dept'];
$sql_current=$db->query("select * from current");
$sql_current_fetch=$sql_current->fetch(PDO::FETCH_BOTH);
$num_current=$sql_current->rowCount();
if ($num_current>0){
// $asemester=$_SESSION['asemester']="Summer Semester";
$asession=$_SESSION['asession']=$sql_current_fetch['asession'];
}
?>
<body>
<table width="80%" align="center" cellpadding="3" cellspacing="5">
<tr><td align="center"><img src="../images/siwesHead.png" alt="" /></td></tr>
<tr><td align="center"><H2>LIST OF ADMITTED STUDENT FOR <?php echo $asession;?></H2></td></tr>
<tr>
<td>
<fieldset>
<?php
$sqlE=$db->query("select * from dept where sn='$dept'");
$sqlE_fetch=$sqlE->fetch(PDO::FETCH_BOTH);
$deptE= $sqlE_fetch['dOption'];
$_SESSION['dept']=$deptE;
$_SESSION['level']=$level;
$sql="select * from admitted where `course`='$deptE' and mode='$level' order by names";
//die();
$sqlExcel="select * from admitted where `course`='$deptE' and mode='$level' order by names";
$result1=$db->query($sql);
$num=$result1->rowCount();
$i=0;
if ($format=='Normal Format'){
echo '<b>Department: </b>'.$deptE;
echo '<b><br>Level: </b>'. $level;
?>
<table width="100%" align="center" cellpadding="5" cellspacing="0">
<tr bgcolor="#0099CC">
<td><em><strong>SN</strong></em></td>
<td><em><strong>Admitted No</strong></em></td>
<td><em><strong>Name</strong></em></td>
</tr>
<tr>
<td colspan="4"><hr/></td>
</tr>
<?php
while ($row=$result1->fetch(PDO::FETCH_BOTH)){
if ($i%2==0){
echo '<tr> ';
}else{
echo '<tr bgcolor="#CCCCCC">';
}
?>
<td><?php echo $i+1; ?></td>
<td><?php echo $row['formNo']; ?></td>
<td><?php echo strtoupper($row['names']); ?></td>
</tr>
<?php
++$i;
}
?>
<tr>
<td colspan="4"><hr/><b><font size="-2">Total Record =
<?php echo $num; ?></font></b></td>
</tr>
</table>
</fieldset></td>
</tr>
</table>
<?php
}else if ($format=='Excel Format') {
// include('../externalCall/SpreadsheetAPI_pdo_admitted.php');
// function recordSetToJson($mysql_result, $jsonencode = false, $marker = "")
// {
// $return_arr = array();
// while ($datarow = mysql_fetch_assoc($mysql_result)) {
// $return_arr[] = $datarow;
// }
// if (!$jsonencode)
// return $return_arr;
// else {
// if ($marker != "")
// return json_encode(array($marker => $return_arr));
// else
// return json_encode($return_arr);
// }
// }
//
////
// $filename = "extraction.xls";
//
// // require('../connect.php');
// // $db = db_connect();
// if (isset($_REQUEST['VIEW']) && $_REQUEST['VIEW'] == 'TRUE') {
// $Query = "SELECT * from vwAllPayments order by paymentType";
// } else {
// // $Query = "SELECT * from vwAllPayments order by paymentType";
//
// /*$Query1 = $db->query("DROP TABLE IF EXISTS export2016_17; CREATE TABLE export2016_17 (SELECT a.matNo, d.formNo, a.names, a.course, a.levelID, orderID, remitaRRR, transDate, amtPaid, paymentType, transApproved, remark, d.status
// FROM remitaorder b, realdata a
// LEFT JOIN rawcgpa c ON a.matNo = c.matNo
// LEFT JOIN admitted d ON a.formNo = d.formNo
// WHERE (
// a.matNo = b.regNo
// OR a.formNo = b.regNo
// )
// AND transApproved = 'True' and MONTH(transDate) = '$mt' and Year(TransDate) = '$yr' group by b.remitaRRR order by b.paymentType)");
// */
// $Query = "select * from admitted";
// }
//
// if (isset($_REQUEST['JSON'])) {
// $result = $db->query($Query);
// if ($result->rowCount() == 0)
// echo "NOT_FOUND";
// else
//
// echo recordSetToJson($results, true);
// } else {
// //$result=$result1->fetchAll(PDO::FETCH_BOTH);
// // $result=mysql_query($Query,$db);
// //echo 'here';
// // $result = $db->query($Query);
//
// xlsProcess($filename);
// exit;
// }
echo '<h2><a href="../externalCall/excelAdmitted.php">Click Here to continue download '. $deptE
.' ('.$level.')</a></h2>';
}
?>
</body>
</html>