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

<?php
include('headMain.php');
extract($_POST);
echo $email=$email;
echo $surname=$surname;
echo $firstname=$firstname;
echo $othername=$othername;

$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 surname='$surname', firstname='$firstname', othername='$othername', display_fullname='$full' where email='$email'";
$aspoa_forms=$dbC->query("UPDATE forms SET surname='$surname', firstname='$firstname', othername='$othername', display_fullname='$full' where email='$email'");
if ($aspoa_forms){
    echo "<br>Form Table Updated!";
}

$k2="UPDATE register SET surname='$surname', firstname='$firstname', othername='$othername' where email='$email'";
$aspoa_register=$dbC->query("UPDATE register SET surname='$surname', firstname='$firstname', othername='$othername' where email='$email'");
if ($aspoa_register){
    echo "<br>Register Table Updated!";
}

$k3= "UPDATE stdprofile SET  surname='$surname', firstname='$firstname', othername='$othername', names='$full' where email='$email'";
$aspoa_stddata=$dbC2->query("UPDATE stdprofile SET  surname='$surname', firstname='$firstname', othername='$othername', names='$full' where email='$email'");
if ($aspoa_stddata){
    echo "<br>stdprofile Table Updated!";
}
$k4= "UPDATE realdata SET  names='$full' 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:editName.php?status=1 &ID=<?php echo $email; ?>');
}else{
    header('location:editName.php?status=2 &ID=<?php echo $email; ?>');
}
?>