<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>

<?php
include('headMain.php');
extract($_POST);
 $email=$email;
 $surname=$surname;
 $firstname=$firstname;
 $othername=$othername;
 $dept=$dept;
 $deptcode=$deptcode;
//die();
$dbC = db_con_forms_connect();
$dbC2 = db_con_connect();
$db=db_connect();

//$aspoa="select * from forms limit 0,2000";
$full=$surname . ' '.$firstname. ' '.$othername;
$k1="UPDATE forms SET dept='$dept', deptcode='$deptcode' where email='$email'";
$aspoa_forms=$dbC->query($k1);
if ($aspoa_forms){
    echo "<br>Form Table Updated!";
}

$k2="UPDATE stddata SET `option`='$dept' where email='$email'";
$aspoa_register=$db->query($k2);
if ($aspoa_register){
    echo "<br>Stddata Table Updated!";
}

$k3= "UPDATE stdprofile SET  Dept='$dept', Deptcode='$deptcode' where email='$email'";
$aspoa_stddata=$dbC2->query($k3);
if ($aspoa_stddata){
    echo "<br>stdprofile Table Updated!";
}
$k4= "UPDATE realdata SET  course='$dept' where email='$email'";
$aspoa_realdata=$db->query($k4);
if ($aspoa_realdata){
    echo "<br>Realdata Table Updated!";
}
//echo "Old name: ".
    echo "New Name: ".$full;
//echo
if ($aspoa_forms){
//    echo "i am here";
    header('location:editDept.php?status=1 &ID=<?php echo $email; ?>');
}else{
    header('location:editDept.php?status=2 &ID=<?php echo $email; ?>');
}
?>