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


require_once './config/config.php';
if(isset($_POST['student_payment']))
{
    $Stud_Id=$_POST["Stud_Id"];
    $head_ids=$_POST["Heads"];
    if ($head_ids != NULL)
    {
        foreach($head_ids as $head_id)
        {
            $r7=mysqli_query($con,"SELECT * FROM `head` WHERE `Head_Id` = '$head_id' ");
            while($row7=mysqli_fetch_array($r7))
            {
                //echo "$row7[Name]<br>";
                $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 "$row8[Sub_Id]<br>";
                    $Sub_Id = $row8["Sub_Id"];
                    $chk_duplicate = mysqli_query($con,"SELECT * FROM stud_basic2 where Stud_Id='$Stud_Id' AND Head_Id='$head_id' AND Subhead_Id='$Sub_Id'");
                    if (mysqli_num_rows($chk_duplicate) > 0) {
                        
                    }
                    else {
                        $r=mysqli_query($con,
                        "INSERT INTO `stud_basic2` 
                        ( `Stud_Id`, `Head_Id`, `Subhead_Id`, `Total_Amount`, `Paid`, `Balance`, `discription`) 
                        VALUES 
                        ('$Stud_Id', '$head_id', '$Sub_Id', '$row8[Amount]', '0', '$row8[Amount]', '')");
                    }

                }
                
            }
       
        }
    }
    echo"<script>window.location='Pay_fees.php?key=$Stud_Id'</script>";
}
?>