PHP | MySQL UPDATE Query

The MySQL UPDATE query is used to update existing records in a table in a MySQL database.

It can be used to update one or more field at the same time.

It can be used to specify any condition using the WHERE clause.

Syntax :
The basic syntax of the Update Query is –

Implementation of Where Update Query :

Let us consider the following table “Data” with four columns ‘ID’, ‘FirstName’, ‘LastName’ and ‘Age’.

To update the “Age” of a person whose “ID” is 201 in the “Data” table, we can use the following code :

Update Query using Procedural Method :

<?php
$link = mysqli_connect("localhost", "root", "", "Mydb");

if($link === false){
    die("ERROR: Could not connect. "
                . mysqli_connect_error());
}

$sql = "UPDATE data SET Age='28' WHERE id=201";
if(mysqli_query($link, $sql)){
    echo "Record was updated successfully.";
} else {
    echo "ERROR: Could not able to execute $sql. "
                            . mysqli_error($link);
}
mysqli_close($link);
?>

Output :
Table After Updation –

The output on Web Browser :

Update Query using Object Oriented Method :

<?php
$mysqli = new mysqli("localhost", "root", "", "Mydb");

if($mysqli === false){
    die("ERROR: Could not connect. "
            . $mysqli->connect_error);
}

$sql = "UPDATE data SET Age='28' WHERE id=201";
if($mysqli->query($sql) === true){
    echo "Records was updated successfully.";
} else{
    echo "ERROR: Could not able to execute $sql. "
                                        . $mysqli->error;
}
$mysqli->close();
?>

Output :
Table After Updation –

The output on Web Browser :

Update Query using PDO Method :

<?php
try{
    $pdo = new PDO("mysql:host=localhost;
                    dbname=Mydb", "root", "");
    $pdo->setAttribute(PDO::ATTR_ERRMODE,
                        PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e){
    die("ERROR: Could not connect. "
                    . $e->getMessage());
}

try{
    $sql = "UPDATE data SET Age='28' WHERE id=201";
    $pdo->exec($sql);
    echo "Records was updated successfully.";
} catch(PDOException $e){
    die("ERROR: Could not able to execute $sql. "
                                . $e->getMessage());
}
unset($pdo);
?>

Output :
Table After Updation –

The output on Web Browser :

PHP is a server-side scripting language designed specifically for web development. You can learn PHP from the ground up by following this PHP Tutorial and PHP Examples.