<?php 	require('db.php');
include("auth.php");

?>
<!DOCTYPE html>
<html>
<head>
<title>Add New Records</title>
<meta charset="utf-8">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script>
$(document).ready(function() {
    $("#email_error").hide();
	$("#fname_error").hide();
	$("#name_error").hide();
	$("#rollnumber_error").hide();
	
	var error_name = false;
	var error_fname = false;
	var error_rollnumber = false;
	var error_email = false;
	   
	$("#name").focusout(function() {
        check_name();
    });
	$("#fname").focusout(function() {
        check_fname();
    });
	$("#email").focusout(function() {
        check_email();
    });
	$("#rollnumber").focusout(function() {
        check_rollnumber();
    });
	function check_name()
	{
		var a = $("#name").val().length;
		if(a == 0)
		{
			$("#name_error").html("Please Enter Student Name");
			$("#name_error").show();
			error_name = true;
		}
		else{
			$("#name_error").hide();
		}
		
	}
	function check_fname()
	{
		var a = $("#fname").val().length;
		if(a == 0)
		{
			$("#fname_error").html("Please Enter Father Name");
			$("#fname_error").show();
			error_fname = true;
			
		}
		else{
			$("#fname_error").hide();
		}
		
	}
	function check_email()
	{
		var a = $("#email").val().length;
		if(a == 0)
		{
			$("#email_error").html("Please Enter Student Email");
			$("#email_error").show();
			error_email= true;
		}
		else{
			$("#email_error").hide();
		}
		
	}
	function check_rollnumber()
	{
		var a = $("#rollnumber").val().length;
		if(a == 0)
		{
			$("#rollnumber_error").html("Please Enter Student Roll Number");
			$("#rollnumber_error").show();
			error_rollnumber = true;
		}
		else{
			$("#rollnumber_error").hide();
		}
		
	}
	$("#st").submit(function() {
		error_name = false ;
		error_fname = false ;
		error_email = false ;
		error_rollnumber = false ;
		check_name();
		check_fname();
		check_email();
		check_rollnumber();
		
        if(error_name == false && error_fname == false && error_email == false && error_rollnumber == false )
		{
			return true;
		}
		else{
			return false;
		}
    });
});
</script>
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <style>
  .navbar{
	  border-radius:0;
  }
  </style>
  
</head>

<body >
<nav class="navbar navbar-inverse">
  <div class="container-fluid">
  <div class="navbar-header">
      <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#myNavbar">
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>                        
      </button>
      <a class="navbar-brand" href="index.php">Student Management System</a>
    </div>
    <div class="collapse navbar-collapse" id="myNavbar">
    <ul class="nav navbar-nav">
      <li ><a href="settimetable.php">Add Schedule</a></li>
      <li><a href="query.php">View Query</a></li>
    </ul>
     <ul class="nav navbar-nav navbar-right">
      <li><a href="logout.php"><span class="glyphicon glyphicon-user"></span> Logout</a></li>
    </ul>
  </div>
</nav>
<div class="container">
<h1 align="center">Welcome <?php echo $_SESSION['username']; ?>!</h1>

<h1 align="center">ADD NEW RECORDS</h1>
<form  method="post" id="st">
<div class="form-group">
	<input class="form-control" type="text" name="name"  placeholder="Student Name"  id="name"/>
    <span id="name_error"></span>
</div>
<div class="form-group">
    <input class="form-control" type="text" name="father"  placeholder="Father Name" id="fname" />
    <span id="fname_error"></span>
</div>
<div class="form-group">
    <input class="form-control" type="email" name="email"  placeholder="Email" id="email" />
    <span id="email_error"></span>
</div>
<div class="form-group">
    <input class="form-control" type="text" name="rollnumber"  placeholder="Roll Number" id="rollnumber" />
    <span id="rollnumber_error"></span>
</div>
    <button type="submit" class="btn btn-default" name="save">Submit</button>
    <a href="view-records.php" class="btn btn-default">Show All Reords</a>
    
</form>	
</div>
<?php
if (isset($_POST['save']))
	{	   

	
	$name=$_POST['name'];  
	$father= $_POST['father'];
	$email = $_POST['email'];
	$rollnumber = $_POST['rollnumber'];
											
$sql= "INSERT INTO student_data (name,father,email,rollnumber) VALUES ('$name','$father','$email','$rollnumber')";
		$result=mysqli_query($con,$sql);	
				if($result){		
		 echo "<script>alert('Student Data is added')</script>";
		}
		else{
			echo "<div class='form'><h3>Your Time table is not set</h3></div>";
		}	
	        }
?>
</body>
</html>