<?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
$a=0;



$r7=mysqli_query($con,"SELECT * FROM `head`");
	while($row7=mysqli_fetch_array($r7))
	{
		
		//echo "$row7[Name]";
		$subhead=explode("/",$row7['SubHeads']);
		
		foreach($subhead as $sub)
		{
			$r8=mysqli_query($con,"SELECT * FROM `sub_head` WHERE `Sub_Id` = '$sub' ");
			$row8=mysqli_fetch_array($r8);
		//echo "$sub"."-"."$row8[Amount]<br>";
		?>
		<script>
		//alert("<?php echo "$a".""."$row8[Amount]"; ?>");
		</script>
		
		<?php
		$a=$a+$row8['Amount'];
		//echo "$a";
		
		}
		//$c=$c+$a;
		//echo "-"."$a<br>";
	mysqli_query($con,"UPDATE `stud_basic2` SET `Amount` = '$a' WHERE `Head_Id` = '$row7[Head_Id]'" );
	//echo "UPDATE `stud_basic2` SET `Amount` = '$a' WHERE `Head_Id` = '$row7[Head_Id]'";
	mysqli_query($con,"UPDATE `stud_basic2_master` SET `Amount` = '$a' WHERE `Head_Id` = '$row7[Head_Id]' ");
	$a=0;
	}
	
	

	?>