PHP | MySQL Delete Query

Last Updated : 03 Mar, 2018

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 :

<?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 = "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);
?>