PHP Update Data In MySQL

Submitted by alpha_luna on Friday, May 13, 2016 - 11:20.

Good Day!!!

Yesterday, we create a tutorials for Inserting Data, Select Data, and Deleting Data from MySQL. For this follow-up tutorial, we are going to create another that related to them. We are going to create PHP Update Data In MySQL. For this tutorial, we are going to use the UPDATE Statement to update the current data in our table. This is the data in our table. In the underline, that we are going to update the first name. Data

Updating Data Using MySQLi and PDO

Using MySQLi (Object-Oriented)

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "edit_query_pdo";
 
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
 
$sql = "UPDATE tbl_registration SET first_name='Sarah' WHERE tbl_registration_id=2";
 
if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}
 
$conn->close();
?>

Using MySQLi (Procedural)

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "edit_query_pdo";
 
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
 
$sql = "UPDATE tbl_registration SET first_name='Sarah' WHERE tbl_registration_id=2";
 
if (mysqli_query($conn, $sql)) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . mysqli_error($conn);
}
 
mysqli_close($conn);
?>

Using PDO (PHP Data Objects)

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "edit_query_pdo";
 
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 
    $sql = "UPDATE tbl_registration SET first_name='Sarah' WHERE tbl_registration_id=2";
 
    // Prepare statement
    $stmt = $conn->prepare($sql);
 
    // execute the query
    $stmt->execute();
 
    // echo a message to say the UPDATE succeeded
    echo $stmt->rowCount() . " records UPDATED successfully";
    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage();
    }
 
$conn = null;
?>

And, this is another source code to update the record in the database table. In this source code, you can edit one or more column in our table.

<?php
include 'connection.php';
 
$get_id=$_REQUEST['tbl_registration_id'];
 
$first_name= $_POST['first_name'];
$middle_name= $_POST['middle_name'];
$last_name= $_POST['last_name'];
$email= $_POST['email'];
$contact_number= $_POST['contact_number'];
 
$sql = "UPDATE tbl_registration SET first_name ='$first_name', middle_name ='$middle_name', 
last_name ='$last_name', email ='$email', contact_number ='$contact_number' WHERE tbl_registration_id = '$get_id' ";
 
$conn->exec($sql);
echo "<script>alert('Successfully Edit The Account!'); window.location='index.php'</script>";
?>

Output:

This is the Edit Form.

After the data updated, this is our new table. Result1

Share us your thoughts and comments below. Thank you so much for dropping by and reading this tutorial post. For more updates, don’t hesitate and feel free to visit this website more often and please share this with your friends or email me at [email protected]. Practice Coding. Thank you very much.

Comments

car hire web based systems

The web based car hire sonko car company when i insert data, message error comes saying registration failed try again. any one understand the source of that error? please help me or someone who developed the system.

Add new comment

Add new comment
2079 views