PHP | MySQL UPDATE Query
The MySQL UPDATE query is used to update existing records in a table in a MySQL database.
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 :
<?phptry{ $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.
Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course by GeeksforGeeks.



