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);
?>
|
Output :
Table After Updation –
The output on Web Browser :
Share your thoughts in the comments
Please Login to comment...