<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 03/31/2023
 * Time: 09:25
 */
include('headMain_light.php');
require_once('connect.php');
$db_con=db_con_connect();
extract($_POST);
$dept=$dept;
$mode=$mode;
//require_once('check_amount_Consultant.php');


//echo $level_name;
//echo $aspoa1->rowCount();
echo "<div align='right'><a href=\"javascript:history.go(-1)\" >GO BACK</a></div>";
$aspoa=$db->query("select * from dept where sn='$dept'");
if ($aspoa->rowCount()==1){
    $aspoa_fet=$aspoa->fetch(PDO::FETCH_BOTH);
    $dept_name=$aspoa_fet[3];
}else{
    $dept_name=0;
}

?>

<table width="60%" border="0">
    <tr><td>School Name: </td><td><?php echo $school;?></td></tr>
    <tr><td>Department/Course Name: </td><td><?php echo $dept_name;?></td></tr>
    <tr><td>Mode: </td><td><?php echo $mode;?></td></tr>
<!--    <tr><td>Semester: </td><td>--><?php //echo $semester;?><!--</td></tr>-->
</table>
<hr>
<table  width="70%" border="1">
    <tr><th>SN</th><th>App. ID</th><th>Jamb No</th><th>Names</th></tr>


<?php

//echo "select * from coursepool where dept='$dept_name' and levelID='$levelN' and semester='$semester'";
//echo "select * from forms where progtype='$mode' and dept='$dept_name' and student_status='Admitted' order by display_fullname";
$asp=$db->query("select * from forms where progtype='$mode' and dept='$dept_name' and student_status='Admitted' order by display_fullname");
//echo $asp->rowCount();
$sn=1;
$sumUnit=0;
//$s = "select * from forms where progtype='$mode' and student_status='Admitted'";
//$r = $db_con->query($s);
//$n = $r->rowCount();

//echo "select * from forms where progtype='$mode' and student_status='Admitted' order by display_fullname";
while ($row=$asp->fetch(PDO::FETCH_BOTH)){
    $sumUnit=$sumUnit+1;
   echo ' <tr><td>'.$sn.'</td><td>'.$row['applicant_id'].'</td><td>'.$row['Jambno'].'</td><td>'.$row[display_fullname].'</td></tr>';
    ++$sn;
}
echo '<tr><th colspan="3">Total Unit</th><th>'.$sumUnit.'</th></tr>'
?>

</table>
<hr>
<div style="color: #b05b0a">NOTE: Kindly visit ICT Directorate or Contact (07061230735 - WhatsApp ONLY) For ANY CORRECTION. Thanks</div>
<hr>