<?php 

    // First we execute our common code to connection to the database and start the session 
    require("common.php"); 
     
    // At the top of the page we check to see whether the user is logged in or not 
    if(empty($_SESSION['user'])) 
    { 
        // If they are not, we redirect them to the login page. 
        header("Location: login.php"); 
         
        // Remember that this die statement is absolutely critical.  Without it, 
        // people can view your members-only content without logging in. 
        die("Redirecting to login.php"); 
    } 
     
    // Everything below this point in the file is secured by the login system 
     
    // We can display the user's username to them by reading it from the session array.  Remember that because 
    // a username is user submitted content we must use htmlentities on it before displaying it to the user. 

?>
<?php

require_once './config/config.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') 
{
	$stud_id= $_POST["Std_Id"];
 $Std_Name=$_POST["Std_Name"];
 $Sex=$_POST["Sex"];
 if($Sex=="")
 {
     $Sex='Male';
 }
$Reg_Number=$_POST["Reg_Number"];
$Class=$_POST["Class"];
$Division=$_POST["Division"];
$Phone=$_POST["Phone"];
$bus_info=$_POST["bus_info"];

mysqli_query($con,"ALTER TABLE `stud_basic` ADD `bus_info` VARCHAR(500) NOT NULL AFTER `status`;");

// echo "UPDATE `stud_basic` SET `Name` = '$Std_Name',  `Class` = '$Class', `Division` = '$Division', `Reg_No` = '$Reg_Number', `Phone` = '$Phone' WHERE `stud_basic`.`Stud_Id` = '$stud_id'"; exit;
mysqli_query($con,"UPDATE `stud_basic` SET `Name` = '$Std_Name',  `Class` = '$Class', `Division` = '$Division', `Reg_No` = '$Reg_Number', `Phone` = '$Phone', bus_info = '$bus_info' WHERE `stud_basic`.`Stud_Id` = '$stud_id'");

?>
<script>
alert("Update Successfull");
document.location="Student_view.php";
</script>

<?php

}else{
	
	header('location: dashboard.php');
}
?>