| Server IP : 172.64.80.1 / Your IP : 172.69.17.157 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/js/ |
Upload File : |
<?php
$dept=$_POST['dept'];
$level=$_POST['level'];
require('../connect.php');
$db=db_connect();
$sqlE=$db->query("select * from dept where sn='$dept'");
$sqlE_fetch=$sqlE->fetch(PDO::FETCH_BOTH);
$deptE=$sqlE_fetch['dOption'];
if (($level>2 ) and ($level<5)){
$prefix=$sqlE_fetch['hnd'];
}else{
$prefix=$sqlE_fetch['nd'];
}
//die($dept.$level);
$sqlCurrent=$db->query("select * from current where sn=2");
$sqlCurrent_fetch=$sqlCurrent->fetch(PDO::FETCH_BOTH);
$asemester=$sqlCurrent_fetch['asemester'];
//die($prefix);
//die($deptE.' '.$level.' '.$prefix.' '.$asemester);
$query="SELECT distinct courseCode FROM coursereg WHERE (matNo like '$prefix%') and levelID='$level' and semester='$asemester'";
$rs=$db->query($query);
//die($query);
$out='<select name="courseCode" id="courseCode" class="form-control">';
while ($row=$rs->fetch(PDO::FETCH_BOTH)){
$out.='<option>'.$row['courseCode'].'</option>';
}
$out.='</select>';
echo $out;
?>