To update the data using forms , first we need to display the respective data into the form input field.
• First we will pass the unique identifier 'ID' as the GET request parameter through the URL to the update page.
E.g<a href='update.php?id=4'>Update</a>
• Then use this GET request parameter to fetch and display the relative record into the input fields.
Now we are going to display the following table record .
<?php
$conn = mysqli_connect('localhost', 'root', '', 'myfirstdatabase');
$id = $_GET['id']; //Geting the id value from URL parameter id
$sql_query = mysqli_query($conn,"SELECT ! FROM users WHERE id='".$id."' ");
$fetch_result = mysqli_fetch_assoc($sql_query);
?>
<form action="submitupdate.php" method="post">
ID:<input type="text" value="<?php echo $fetch_result['id']; ?>" name="id"><br>
First Name:<input type="text" value="<?php echo $fetch_result['first_name']; ?>" name="first_name"><br>
Last name:<input type="text" value="<?php echo $fetch_result['last_name']; ?>" name="last_name"><br>
Password:<input type="password" value="<?php echo $fetch_result['password']; ?>" name="password"><br>
<input type="submit" name="submit" value="Update">
</form>
<?php
$conn = mysqli_connect('localhost', 'root', '', 'myfirstdatabase');
$id = $_POST['id']; //Getting the id value from POST parameter id
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$password = $_POST['password'];
$sql_query = mysqli_query($conn,"UPDATE users SET first_name='".$first_name."',last_name='".$last_name."',
password='".$password."' WHERE id='".$id."' ");
header("location: show.php"); // redirect to the main page after submitting update
?>