{"id":5776,"date":"2019-02-06T06:56:40","date_gmt":"2019-02-06T06:56:40","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=5776"},"modified":"2022-04-13T15:56:37","modified_gmt":"2022-04-13T15:56:37","slug":"how-to-delete-records","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-delete-records\/","title":{"rendered":"How to delete records?"},"content":{"rendered":"

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

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

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

4)<\/strong> Define the bound values:
\n[code language=”php”]
\n$id = 1;
\n[\/code]<\/p>\n

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

6)<\/strong> Check that the query has been performed and that the records have been successfully deleted from the database.
\n[code language=”php”]
\nif($query -> rowCount() > 0)
\n{
\n$count = $query -> rowCount();
\necho $count . " rows were affected.";
\n}
\nelse
\n{
\necho "No affected rows.";
\n}
\n[\/code]<\/p>\n

All code together now:<\/strong>
\n[code language=”php”]
\n$sql = "DELETE FROM `users` WHERE `id`=:id";
\n$query = $dbh -> prepare($sql);
\n$query -> bindParam(‘:id’, $id, PDO::PARAM_INT);
\n$id = 1;
\n$query -> execute();
\nif($query -> rowCount() > 0)
\n{
\n$count = $query -> rowCount();
\necho $count . " rows were affected.";
\n}
\nelse
\n{
\necho "No affected rows.";
\n}
\n[\/code]<\/p>\n","protected":false},"excerpt":{"rendered":"

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… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5150],"tags":[5191,5190],"class_list":["post-5776","post","type-post","status-publish","format-standard","hentry","category-php","tag-how-to-delete-records-using-pdo","tag-how-to-delete-records"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/5776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=5776"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/5776\/revisions"}],"predecessor-version":[{"id":5777,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/5776\/revisions\/5777"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=5776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=5776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=5776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}