MySQLi Delete

MySQL DELETE keyword is used to delete table rows. Once the data is deleted, you can not recover them. So always be careful while deleting the existing table.

Syntax

DELETE FROM Tablename [WHERE Clause]; 

These are the following ways to delete data from Employee table -

Object Oriented PHP MySQLi Delete Data

<?php
$conn = new mysqli('hostname', 'username', 'password', 'databasename');
//Check for connection error
if($conn->connect_error){
  die("Error in DB connection: ".$conn->connect_errno." : ".$conn->connect_error);    
}
$delete = "DELETE FROM employee WHERE emp_id = '1' ";
if($conn->query($delete)){
 echo 'Data deleted successfully';
}
?>

The above example delete the employee row of emp_id = 1.

Procedural PHP MySQLi Delete Data

<?php
$conn = mysqli_connect('hostname', 'username', 'password', 'databasename');
//Check for connection error
if(mysqli_connect_error()){
  die("Error in DB connection: ".mysqli_connect_errno()." - ".mysqli_connect_error());
}
$delete = "DELETE FROM employee WHERE emp_id = '3' ";
if(mysqli_query($conn, $delete)){
  echo 'Data deleted successfully';
}
?>  
    

The above example delete the employee row of emp_id = 3.