<?php
$sqlCourse=$db->query("select sum(courseunit) as sumUnit from coursereg where matNo='$matNo' and semester='$asemester' and asession='$asession'");
$sumUnit_fetch=$sqlCourse->fetch(PDO::FETCH_BOTH);
$sumUnit=$sumUnit_fetch['sumUnit'];
//die($sumUnit);

$prefix=substr($matNo,0,2);
$sql=$db->query("select ndMaxUnit,hndMaxUnit,ndPTMaxUnit from dept where nd='$prefix' or hnd='$prefix'");
$sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
//if ($sql_fetch['ndMaxUnit']>1) {
 $levelID;
if (($levelID==1) or($levelID==2)or ($levelID==8)or ($levelID==9)) {
 $maxUnit = $sql_fetch['ndMaxUnit'];
}else if (($levelID==5) or($levelID==6)or ($levelID==7)) {
     $maxUnit = $sql_fetch['ndPTMaxUnit'];
}else if (($levelID==3) or($levelID==4)) {
       $maxUnit = $sql_fetch['hndMaxUnit'];
}

$session_split=explode('/',$asession);
$session_gena=$session_split[0]-1;
$session_genb=$session_split[1]-1;
$session_gen=$session_gena.'/'.$session_genb;

//echo $asemestera='%'.$asemester. '%';


function rdb_connect()
{
    try
    {
        $dbh = new PDO("mysql:host=localhost;dbname=fpe_result", "aspoa", "wBg0&l28");
        // $dbh = new PDO("mysql:host=localhost;dbname=fedpoly", "db_admin", "Edni7#74_fedPoly");
        return ($dbh);
    }
    catch (PDOException $e)
    {
        print ("Could not connect to server.\n"); print ("getMessage(): " . $e->getMessage () . "\n");

    }
}


$dbh=rdb_connect();
 $result_table=$_SESSION['result_table'];

// $ff="select * from ".$result_table." where MatricNo='$matNo' and remark like 'Prob%'";
 $sq=$db->query("select * from rawcgpa where matNo='$matNo' and remark like 'Prob%' and asession='$session_gen' and `level`  like '%Second%'")->rowCount();
//$sq=$dbh->query($ff)->rowCount();
if ($sq>0){
switch ($levelID) {
    case 1:
        $maxUnit = 18;
        break;
    case 2:
        $maxUnit = 22;
        break;
    case 3:
        $maxUnit = 18;
        break;
    case 4:
        $maxUnit = 18;
        break;
    case 5:
        $maxUnit = 15;
        break;
    case 6:
        $maxUnit = 15;
        break;
    case 7:
        $maxUnit = 15;
        break;
    case 8:
        $maxUnit = 18;
        break;
    case 9:
        $maxUnit = 22;
        break;
    case 10:
        $maxUnit = 1;
        break;
}

//echo $maxUnit;
}

?>