{"id":1326,"date":"2021-04-22T04:38:33","date_gmt":"2021-04-22T04:38:33","guid":{"rendered":"https:\/\/phptutorial.net\/?page_id=1326"},"modified":"2021-07-08T04:16:22","modified_gmt":"2021-07-08T04:16:22","slug":"php-pdo-update","status":"publish","type":"page","link":"https:\/\/www.phptutorial.net\/php-pdo\/php-pdo-update\/","title":{"rendered":"PHP PDO Update"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to update data in a table using PHP PDO.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='updating-data-from-php-using-pdo'>Updating data from PHP using PDO <a href=\"#updating-data-from-php-using-pdo\" class=\"anchor\" id=\"updating-data-from-php-using-pdo\" title=\"Anchor for Updating data from PHP using PDO\">#<\/a><\/h2>\n\n\n\n<p>To update data in a table from PHP using PDO, you follow these steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>First, <a href=\"https:\/\/phptutorial.net\/php-pdo\/php-pdo-mysql\/\">connect to the database<\/a> by creating a new instance of the <code>PDO<\/code> class.<\/li><li>Next, construct an SQL <code>UPDATE<\/code> statement to update data in a table.<\/li><li>Then, call the <code>prepare()<\/code> method of the PDO object. The <code>prepare()<\/code> method returns a new instance of the <code>PDOStatement<\/code> class.<\/li><li>After that, bind the values to the <code>UPDATE<\/code> statement by calling the <code>bindParam()<\/code> method of the <code>PDOStatement<\/code> object.<\/li><li>Finally, execute the statement by calling the <code>execute()<\/code> method of the <code>PDOStatement<\/code>.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id='php-pdo-update-example'>PHP PDO update example <a href=\"#php-pdo-update-example\" class=\"anchor\" id=\"php-pdo-update-example\" title=\"Anchor for PHP PDO update example\">#<\/a><\/h2>\n\n\n\n<p>The following example shows how to update the publisher with id 1 in 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<span class=\"hljs-comment\">\/\/ connect to the bookdb database<\/span>\r\n$pdo = <span class=\"hljs-keyword\">require_once<\/span> <span class=\"hljs-string\">'connect.php'<\/span>;\r\n\r\n$publisher = &#91;\r\n\t<span class=\"hljs-string\">'publisher_id'<\/span> =&gt; <span class=\"hljs-number\">1<\/span>,\r\n\t<span class=\"hljs-string\">'name'<\/span> =&gt; <span class=\"hljs-string\">'McGraw-Hill Education'<\/span>\r\n];\r\n\r\n$sql = <span class=\"hljs-string\">'UPDATE publishers\r\n        SET name = :name\r\n        WHERE publisher_id = :publisher_id'<\/span>;\r\n\r\n<span class=\"hljs-comment\">\/\/ prepare statement<\/span>\r\n$statement = $pdo-&gt;prepare($sql);\r\n\r\n<span class=\"hljs-comment\">\/\/ bind params<\/span>\r\n$statement-&gt;bindParam(<span class=\"hljs-string\">':publisher_id'<\/span>, $publisher&#91;<span class=\"hljs-string\">'publisher_id'<\/span>], PDO::PARAM_INT);\r\n$statement-&gt;bindParam(<span class=\"hljs-string\">':name'<\/span>, $publisher&#91;<span class=\"hljs-string\">'name'<\/span>]);\r\n\r\n<span class=\"hljs-comment\">\/\/ execute the UPDATE statment<\/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\">'The publisher has been updated 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, connect to the <code>bookdb<\/code> database and get an instance of the PDO object. <a href=\"https:\/\/phptutorial.net\/php-pdo\/php-pdo-mysql\/\">Check the <code>connect.php<\/code> script for the detail<\/a>.<\/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_once<\/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>Second, define data for updating and construct an <code>UPDATE<\/code> statement:<\/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\">$publisher = &#91;\n\t<span class=\"hljs-string\">'publisher_id'<\/span> =&gt; <span class=\"hljs-number\">1<\/span>,\n\t<span class=\"hljs-string\">'name'<\/span> =&gt; <span class=\"hljs-string\">'McGraw-Hill Education'<\/span>\n];\n\n$sql = <span class=\"hljs-string\">'UPDATE publishers\n        SET name = :name\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>The <code>UPDATE<\/code> statement uses the named placeholders <code>:publisher_id<\/code>.<\/p>\n\n\n\n<p>Third, prepare the <code>UPDATE<\/code> statement for execution by calling the <code>prepare()<\/code> method:<\/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>Fourth, bind the values to the <code>UPDATE<\/code> 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\"><span class=\"hljs-comment\">\/\/ bind values<\/span>\n$statement-&gt;bindParam(<span class=\"hljs-string\">':publisher_id'<\/span>, $publisher&#91;<span class=\"hljs-string\">'publisher_id'<\/span>], PDO::PARAM_INT);\n$statement-&gt;bindParam(<span class=\"hljs-string\">':name'<\/span>, $publisher&#91;<span class=\"hljs-string\">'name'<\/span>]);<\/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>UPDATE<\/code> statement by calling the execute() method of the <code>PDOStatement<\/code> object:<\/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\">'The publisher has been updated 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<p>To get the number of updated rows, you call the <code>rowCount()<\/code> method of the <code>PDOStatement<\/code> object.<\/p>\n\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 update data in a table from PHP using 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=\"1326\"\n\t\t\t\tdata-post-url=\"https:\/\/www.phptutorial.net\/php-pdo\/php-pdo-update\/\"\n\t\t\t\tdata-post-title=\"PHP PDO Update\"\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=\"1326\"\n\t\t\t\tdata-post-url=\"https:\/\/www.phptutorial.net\/php-pdo\/php-pdo-update\/\"\n\t\t\t\tdata-post-title=\"PHP PDO Update\"\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 update a data in a table from PHP using PDO.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":21,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1326","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/pages\/1326","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=1326"}],"version-history":[{"count":5,"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/pages\/1326\/revisions"}],"predecessor-version":[{"id":2166,"href":"https:\/\/www.phptutorial.net\/wp-json\/wp\/v2\/pages\/1326\/revisions\/2166"}],"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=1326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}