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]
- DevOps Certified Professionals (DCP)
- Site Reliability Engineering Certified Professionals (SRECP)
- Master in DevOps Engineering (MDE)
- DevSecOps Certified Professionals (DSOCP)
URL - https://www.devopsschool.com/certification/
My Linkedin - https://www.linkedin.com/in/rajeshkumarin
- Apache Lucene Query Example - April 8, 2024
- Google Cloud: Step by Step Tutorials for setting up Multi-cluster Ingress (MCI) - April 7, 2024
- What is Multi-cluster Ingress (MCI) - April 7, 2024
