{"id":1353,"date":"2021-04-23T00:45:55","date_gmt":"2021-04-23T00:45:55","guid":{"rendered":"https:\/\/phptutorial.net\/?page_id=1353"},"modified":"2021-07-08T04:22:02","modified_gmt":"2021-07-08T04:22:02","slug":"php-pdo-delete","status":"publish","type":"page","link":"https:\/\/www.phptutorial.net\/php-pdo\/php-pdo-delete\/","title":{"rendered":"PHP PDO Delete"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to delete one or more rows in a table from PHP using PDO.<\/p>\n\n\n\n<p>To delete one or more rows from a table, you can use a <a href=\"https:\/\/phptutorial.net\/php-pdo\/php-prepared-statement\/\">prepared statement<\/a>. Here are the steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>First, <a href=\"https:\/\/phptutorial.net\/php-pdo\/pdo-connecting-to-mysql\/\">make a connection to the database<\/a> by creating a new instance of the PDO class.<\/li><li>Next, construct a <code>DELETE<\/code> statement.<\/li><li>Then, create a prepared statement by calling the <code>prepare()<\/code> method of the PDO instance.<\/li><li>After that, bind the parameters, if any, using the <code>bindParam()<\/code> method.<\/li><li>Finally, execute the <code>DELETE<\/code> statement by calling the <code>execute()<\/code> method of the prepared statement.  <\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id='delete-one-row-from-a-table'>Delete one row from a table <a href=\"#delete-one-row-from-a-table\" class=\"anchor\" id=\"delete-one-row-from-a-table\" title=\"Anchor for Delete one row from a table\">#<\/a><\/h2>\n\n\n\n<p>The following example illustrates how to use a prepared statement to delete the publisher with id 1 from the <code>publishers<\/code> table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"HTML, XML\" data-shcb-language-slug=\"xml\"><span><code class=\"hljs language-xml\"><span class=\"php\"><span class=\"hljs-meta\">&lt;?php<\/span>\r\n\r\n$publisher_id = <span class=\"hljs-number\">1<\/span>;\r\n\r\n<span class=\"hljs-comment\">\/\/ connect to the database and select the publisher<\/span>\r\n$pdo = <span class=\"hljs-keyword\">require<\/span> <span class=\"hljs-string\">'connect.php'<\/span>;\r\n\r\n<span class=\"hljs-comment\">\/\/ construct the delete statement<\/span>\r\n$sql = <span class=\"hljs-string\">'DELETE FROM publishers\r\n        WHERE publisher_id = :publisher_id'<\/span>;\r\n\r\n<span class=\"hljs-comment\">\/\/ prepare the statement for execution<\/span>\r\n$statement = $pdo-&gt;prepare($sql);\r\n$statement-&gt;bindParam(<span class=\"hljs-string\">':publisher_id'<\/span>, $publisher_id, PDO::PARAM_INT);\r\n\r\n<span class=\"hljs-comment\">\/\/ execute the statement<\/span>\r\n<span class=\"hljs-keyword\">if<\/span> ($statement-&gt;execute()) {\r\n\t<span class=\"hljs-keyword\">echo<\/span> <span class=\"hljs-string\">'publisher id '<\/span> . $publisher_id . <span class=\"hljs-string\">' was deleted successfully.'<\/span>;\r\n}\r<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">HTML, XML<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">xml<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>How it works.<\/p>\n\n\n\n<p>First, create a connection to the <code>bookdb<\/code> database by using the <code>connect.php<\/code> script.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">$pdo = <span class=\"hljs-keyword\">require<\/span> <span class=\"hljs-string\">'connect.php'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Next, construct a <code>DELETE<\/code> statement with a named placeholder <code>:publisher_id<\/code>:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">$sql = <span class=\"hljs-string\">'DELETE FROM publishers\n        WHERE publisher_id = :publisher_id'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Then, create a prepared statement by calling the <code>prepare()<\/code> method of the PDO instance:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">$statement = $pdo-&gt;prepare($sql);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>After that, bind the <code>publisher_id<\/code> parameter to the statement:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">$statement-&gt;bindParam(<span class=\"hljs-string\">':publisher_id'<\/span>, $publisher_id, PDO::PARAM_INT);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Finally, execute the <code>DELETE<\/code> statement:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-keyword\">if<\/span> ($statement-&gt;execute()) {\n\t<span class=\"hljs-keyword\">echo<\/span> <span class=\"hljs-string\">'publisher id '<\/span> . $publisher_id . <span class=\"hljs-string\">' was deleted successfully.'<\/span>;\n}<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\" id='delete-multiple-rows-from-a-table'>Delete multiple rows from a table <a href=\"#delete-multiple-rows-from-a-table\" class=\"anchor\" id=\"delete-multiple-rows-from-a-table\" title=\"Anchor for Delete multiple rows from a table\">#<\/a><\/h2>\n\n\n\n<p>Deleting multiple rows from the table is the same as the steps for deleting one row from a table. <\/p>\n\n\n\n<p>To find the number of rows deleted, you use the <code>rowCount()<\/code> method of the <code>PDOStatement<\/code> object.<\/p>\n\n\n\n<p>The following example shows how to delete publishers with an id greater than 3:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"HTML, XML\" data-shcb-language-slug=\"xml\"><span><code class=\"hljs language-xml\"><span class=\"php\"><span class=\"hljs-meta\">&lt;?php<\/span>\r\n\r\n$publisher_id = <span class=\"hljs-number\">3<\/span>;\r\n\r\n<span class=\"hljs-comment\">\/\/ connect to the database and select the publisher<\/span>\r\n$pdo = <span class=\"hljs-keyword\">require<\/span> <span class=\"hljs-string\">'connect.php'<\/span>;\r\n\r\n$sql = <span class=\"hljs-string\">'DELETE FROM publishers\r\n        WHERE publisher_id &gt; :publisher_id'<\/span>;\r\n\r\n$statement = $pdo-&gt;prepare($sql);\r\n$statement-&gt;bindParam(<span class=\"hljs-string\">':publisher_id'<\/span>, $publisher_id, PDO::PARAM_INT);\r\n\r\n<span class=\"hljs-keyword\">if<\/span> ($statement-&gt;execute()) {\r\n\t<span class=\"hljs-keyword\">echo<\/span> $statement-&gt;rowCount() . <span class=\"hljs-string\">' row(s) was deleted successfully.'<\/span>;\r\n}\r<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">HTML, XML<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">xml<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">2 row(s) was deleted successfully.<\/code><\/span><\/pre>\n\n\n<h2 class=\"wp-block-heading\" id='summary'>Summary <a href=\"#summary\" class=\"anchor\" id=\"summary\" title=\"Anchor for Summary\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Use a prepared statement to delete a row from a table using PHP PDO.<\/li><\/ul>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Did you find this tutorial useful?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"1353\"\n\t\t\t\tdata-post-url=\"https:\/\/www.phptutorial.net\/php-pdo\/php-pdo-delete\/\"\n\t\t\t\tdata-post-title=\"PHP PDO Delete\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"1353\"\n\t\t\t\tdata-post-url=\"https:\/\/www.phptutorial.net\/php-pdo\/php-pdo-delete\/\"\n\t\t\t\tdata-post-title=\"PHP PDO Delete\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, you will learn how to delete one or more rows in a table from PHP using PDO.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":21,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1353","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/pages\/1353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/comments?post=1353"}],"version-history":[{"count":5,"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/pages\/1353\/revisions"}],"predecessor-version":[{"id":2168,"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/pages\/1353\/revisions\/2168"}],"up":[{"embeddable":true,"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/pages\/21"}],"wp:attachment":[{"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/media?parent=1353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}