PHP | MySQL UPDATE Query (original) (raw)

Last Updated : 01 Aug, 2021

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 :

html `

**Output :**Table After Updation -
The output on Web Browser :
Update Query using Object Oriented Method :

html `

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 :

html `

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(pdo->exec(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.