<?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. 


if ($_SERVER['REQUEST_METHOD'] == 'POST') 
{
	



$x=$_SESSION["h"];
 $y=$_SESSION["c"];
$z=$_SESSION["d"];

include "config/config.php";
$a=$_POST["a"];
foreach ($a as $sid ) 
{
//echo "$sid";
/*$r=mysqli_query($con,"DELETE FROM `stud_basic2` 
WHERE `Stud_Id` = '$sid'  and  `Head_Id` = '$x' ");*/
//echo "DELETE FROM `stud_basic2` 
//WHERE `Stud_Id` = '$sid'  and  `Head_Id` = '$x' ";
   /* $r=mysqli_query($con,"DELETE FROM `stud_basic2` 
    WHERE `Stud_Id` = '$sid'  and  `Head_Id` = '$x' ");*/
    
    $r7=mysqli_query($con,"SELECT * FROM `stud_basic2` WHERE `Stud_Id` = '$sid'  and  `Head_Id` = '$x' ");
	while($row7=mysqli_fetch_array($r7))
	{
		//echo "$row7[Name]<br>";
		$subhead=$row7['Subhead_Id'];
	    $r8=mysqli_query($con,"SELECT * FROM `sub_head` WHERE `Sub_Id` = '$subhead' ");
		$row8=mysqli_fetch_array($r8);
		$sub_amount=$row8['Amount'];
		if($row7['Balance']>=$sub_amount)
		{
		    mysqli_query($con,"UPDATE stud_basic2 SET Total_Amount=Total_Amount-$sub_amount,Paid=Paid,Balance=Balance-$sub_amount where Stud_Id=$sid and Head_Id=$x and `Subhead_Id` = '$subhead' ");
	    }
	}
}
?>
<script>
 document.location="Apply_fees_code_delete.php";
</script>
<?php
}
else
{
	?>
<script>
document.location="dashboard.php";
</script>

<?php
}

?>