<?php
include "config.php";
if(isset($_POST['update']))
{
$name=$_POST['name'];
echo $name;
$address=$_POST['address'];
$age=$_POST['age'];
$id=$_POST['id'];
$queryupd=" UPDATE `teacherdetails` SET `name`='$name', `address`='$address',`age` ='$age' WHERE `id`='$id'";
$resul = $conn -> query($queryupd);
if($resul==true)
{
echo "Record updated successfully in the table";
}
else {
echo "Error while updating the table"."<br>".$queryupd."<br>".$conn->error;
}
$conn -> commit();
$conn -> close();
}
if(isset($_GET['id']))
{
$id=$_GET['id'];
$query="SELECT * FROM teacherdetails WHERE ID='$id'";
$resul=$conn->query($query);
if($resul->num_rows>0)
{
while($row=$resul->fetch_assoc())
{
$name=$row['name'];
$address=$row['address'];
$age=$row['age'];
$id=$row['id'];
}
?>
<h2>update Teacher detail</h2>
<form action="" method="POST">
<fieldset>
<legend>teacher detail</legend>
Name: <input type="text" name="name" value="<?php echo $name; ?>">
<input type="hidden" name="id" value="<?php echo $id; ?>">
<br>
Address: <input type="text" name="address" value="<?php echo $address; ?>">
<br>
Age: <input type="number" name="age" value="<?php echo $age; ?>">
<br>
<br><input type="submit" value="UpdaTe" name="update">
</fieldset>
</form>
</body>
</html>
<?php
}
else
{
header('Location:view.php');
}
}?>
