<?php
extract($_POST);
switch ($mode) {

    case 1:
        $mode = 'DPT';
        $mode_value='8';
        break;
    case 2:
        $mode = 'RPT';
        $mode_value='5';
        break;
    case 3:
        $mode = 'NFT';
        $mode_value='1';
        break;
    case 4:
        $mode = 'HFT';
        $mode_value='3';
        break;
    case 5:
        $mode = 'HDPT';
        $mode_value='11';
        break;
}


require('../connect.php');
$db=db_connect();
 $courseC=$course.'('.$old_mode.')';

//echo $dept;
 $sql_dept="select * from dept where sn='$dept'";
$result_dept=$db->query($sql_dept) or die("No Departmentd selected");
if ($result_dept->rowCount()>0){
    $result_dept_fetch=$result_dept->fetch(PDO::FETCH_ASSOC);
     $courseNew=$result_dept_fetch['dOption'];
    if(strtoupper($matNo)==strtoupper($formNo)){
        $db->query("UPDATE realdata set course='$courseNew',courseChanged='$courseC',levelID='$mode_value',mode='$mode' where formNo='$formNo'");
        $db->query("UPDATE admitted set course='$courseNew',levelID='$mode_value',mode='$mode' where formNo='$formNo'");
        echo "Department changed From ".$course." to ".$courseNew."(".$mode_value.") Successfully";
    }else{
        echo 'Mat No: '.$matNo .'<br>';
        echo 'Form No:'.$formNo;
    }
}else{
    echo "No Department Selected";
}
?>