1) Write the delete statement:
[code language=”php”]
$sql = "DELETE FROM `users` WHERE `id`=:id";
[/code]

2) Prepare the query:
[code language=”php”]
$query = $dbh -> prepare($sql);
[/code]

3) Bind the parameters:
[code language=”php”]
$query -> bindParam(‘:id’, $id, PDO::PARAM_INT);
[/code]

4) Define the bound values:
[code language=”php”]
$id = 1;
[/code]

5) Execute the query:
[code language=”php”]
$query -> execute();
[/code]

6) Check that the query has been performed and that the records have been successfully deleted from the database.
[code language=”php”]
if($query -> rowCount() > 0)
{
$count = $query -> rowCount();
echo $count . " rows were affected.";
}
else
{
echo "No affected rows.";
}
[/code]

All code together now:
[code language=”php”]
$sql = "DELETE FROM `users` WHERE `id`=:id";
$query = $dbh -> prepare($sql);
$query -> bindParam(‘:id’, $id, PDO::PARAM_INT);
$id = 1;
$query -> execute();
if($query -> rowCount() > 0)
{
$count = $query -> rowCount();
echo $count . " rows were affected.";
}
else
{
echo "No affected rows.";
}
[/code]

Rajesh Kumar

I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I am working at Cotocus. I blog tech insights at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at I reviewed , and SEO strategies at Wizbrand.

Do you want to learn Quantum Computing?

Please find my social handles as below;

Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at PINTEREST
Rajesh Kumar at QUORA
Rajesh Kumar at WIZBRAND