php update sql database from form
<?php
include "config.php"; // Using database connection file here
$id = $_GET['id']; // get id through query string
$qry = mysqli_query($db,"select * from emp where id='$id'"); // select query
$data = mysqli_fetch_array($qry); // fetch data
if(isset($_POST['update'])) // when click on Update button
{
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$edit = mysqli_query($db,"update emp set fname='$fname', lname='$lname' where id='$id'");
if($edit)
{
mysqli_close($db); // Close connection
header("location:all_records.php"); // redirects to all records page
exit;
}
else
{
echo mysqli_error();
}
}
?>
<h3>Update Data</h3>
<form method="POST">
<input type="text" name="fname" value="<?php echo $data['fname'] ?>" placeholder="Enter Full Name" Required>
<input type="text" name="lname" value="<?php echo $data['lname'] ?>" placeholder="Enter Last Name" Required>
<input type="submit" name="update" value="Update">
</form>