The DELETE query is used to delete records from a database table.
It is generally used along with the “Select” statement to delete only those records that satisfy a specific condition.
Syntax :
The basic syntax of the Delete Query is –
Let us consider the following table “Data” with four columns ‘ ID ‘, ‘ FirstName ‘, ‘ LastName ‘ and ‘ Age ‘.
To delete the record of the person whose ID is 201 from the ‘ Data ‘ table, the following code can be used.
Delete Query using Procedural Method :
<?php$link = mysqli_connect("localhost", "root", "", "Mydb"); if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } $sql = "DELETE FROM Data WHERE ID=201"; if(mysqli_query($link, $sql)){ echo "Record was deleted 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 :
Delete Query using Object Oriented Method :
<?php$mysqli = new mysqli("localhost", "root", "", "Mydb"); if($mysqli === false){ die("ERROR: Could not connect. " . $mysqli->connect_error); } $sql = "DELETE FROM Data WHERE ID=201"; if($mysqli->query($sql) === true){ echo "Record was deleted successfully."; } else{ echo "ERROR: Could not able to execute $sql. " . $mysqli->error; } $mysqli->close(); ?> |
Output :
Table After Updation –
The output on Web Browser :
Delete 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 = "DELETE FROM Data WHERE ID=201"; $pdo->exec($sql); echo "Record was deleted 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 :
