PHP update database table data using form input fields


php PHP update database table data using form input fields Database Data Update Using Form PHP

How to update the data using forms input fields ?

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 .

How to display the record into text input fields?

First we will fetch the record using incoming ID . <?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>

Sample form with content Display

Unique ID :
First Name:
Last Name:
Password:

Submitting the updated form data using PHP

<?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 ?>
php Database Data Update Using Form PHP Chapter Next »