<?php
require("db.php");
include("auth.php");
?>
<!doctype html>
<html>
	<head>  
    	<title>Edit Records</title>
        <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <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.2.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  <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>
<?php

$id =$_REQUEST['id'];
$result = mysqli_query($con, "SELECT * FROM student_data WHERE id  = '$id'");
$test = mysqli_fetch_array($result);

				$name=$test['name'];				
				$father=$test['father'];	
				$email = $test['email'];
				$rollnumber = $test['rollnumber'];
					
if(isset($_POST['save']))
{	
	$name_save = $_POST['name'];
	$father_save = $_POST['father'];
	$email_save = $_POST['email'];
	$rollnumber_save = $_POST['rollnumber'];
	$ali = mysqli_query($con, "UPDATE student_data SET name ='$name_save', father ='$father_save' ,email ='$email_save' , rollnumber = '$rollnumber_save'WHERE id = '$id'")
				or die(mysqli_error()); 
	if($ali)
	{
		echo "<script>alert('Data is Save')</script>";
	}
}
?>

<h1 style="margin-left:50px;">Edit Records</h1>
<form class="form-horizontal" method="post">

	<input type="text" name="name" class="form-control" value="<?php echo $name ?>"/>
	<input type="text" name="father" class="form-control" value="<?php echo $father ?>"/>
    <input type="email" name="email" class="form-control" value="<?php echo $email ?>"/>
	<input type="text" name="rollnumber" class="form-control" value="<?php echo $rollnumber ?>"/>
    
   	<button class="btn btn-success" type="submit" name="save">Save</button> 
    <a href="view-records.php" class="btn btn-danger" >Back</a>
</form>

</body>
</html>