<?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') 
{
$Division=$_POST["Division"];
//mysqli_query($db,'INSERT INTO `devision` (`Name`) VALUES ($Division)');

$sql=mysqli_query($con,"select * from division where Name = '$Division' ");
$sql1=mysqli_num_rows($sql);
//echo $sql1;
if($sql1 != 0)
{
	?>
	<script>
	document.location="Division.php";
	alert("Duplicate Entry");

	</script>
	<?php
	
}else
{
	mysqli_query($con,"insert into division (`Name`)  values ('$Division')")or die(mysqli_error($con));

    		?>
	<script>
	alert("Entry Successfull");
	document.location="division.php";
	</script>
	<?php
    
}	
}else{
	
	header('location: index.php');
}



?>