
<?php
session_start();
 if (session_is_registered("valid_user")&&session_is_registered("password"))
{
?>
<html>
<head>
<title>Delete Complete </title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874"></head>
<body bgcolor="#FFFFFB">
<?php
    include("../include/FunctionDB.php");
    ConnectDB();
    /////Delete Std Data
        $strSQL = "DELETE FROM student_tb WHERE Student_id='$Student_id'";
        $result  = mysql_query( $strSQL) or die("Error".mysql_error());
   //// Delete Grade Data
        $strSQL1 = "DELETE FROM grade_tb WHERE Student_id='$Student_id'";
        $result1  = mysql_query( $strSQL1) or die("Error".mysql_error());
   /// Delete  Punishment
        $strSQL2 = "DELETE FROM punishment_tb WHERE Student_id='$Student_id'";
        $result2  = mysql_query( $strSQL2) or die("Error".mysql_error());
      /// Delete Absent
        $strSQL3 = "DELETE FROM std_absent_tb WHERE Student_id='$Student_id'";
        $result3  = mysql_query( $strSQL3) or die("Error".mysql_error());
      /// Delete Health
        $strSQL4 = "DELETE FROM std_health_tb WHERE Student_id='$Student_id'";
        $result4  = mysql_query( $strSQL4) or die("Error".mysql_error());
      /// Delete Punishment
        $strSQL5 = "DELETE FROM std_punish_tb WHERE Student_id='$Student_id'";
        $result5 = mysql_query( $strSQL5) or die("Error".mysql_error());
        if (!$result)
            return " Please check Query Again <br>";
         if ($result)
     { 
        echo"<center><font face=\"Tahoma\"size=\"6\" color=\"#FF0000\">Delete Complete</font></center>";
        echo"<meta http-equiv=\"refresh\" content=\"1;URL=EditStudentList.php\">";         
     }
    CloseDB();
?>
<p>&nbsp;</p>

</body>
</html>
<?php 
    }
else
{
       echo"<meta http-equiv=\"refresh\" content=\"3;URL=../../login.php\">\n";
}
?>