{"id":3714,"date":"2018-09-21T09:43:34","date_gmt":"2018-09-21T09:43:34","guid":{"rendered":"http:\/\/ebhor.com\/?p=3714"},"modified":"2021-02-19T07:05:41","modified_gmt":"2021-02-19T07:05:41","slug":"pdo-in-php","status":"publish","type":"post","link":"https:\/\/www.ebhor.com\/pdo-in-php\/","title":{"rendered":"PDO in PHP"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">What is PDO?<\/h2>\n\n\n\n<p>Other than procedural methods like MySQLi, PHP also provides an object oriented approach to deal with databases. This framework is widely known as PDO: PHP Data Objects.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Advantages of PDO<\/h2>\n\n\n\n<ul><li>PDO is applicable on 12 different databases whereas MySQLi is not, which makes PDO more flexible than typical procedural approach.<\/li><li>PDO also provides an exception class for handling problems during database query execution. The exception-prone code must be written in the try block. When an exception is thrown within the try{ } block, execution stops at that line and jumps directly to the first catch(){ } block.<\/li><li>PDO provides a set of methods on the PDO object for performing queries, which introduces reusability of code.<\/li><\/ul>\n\n\n\n<ul><li> It&#8217;s useful for developing software that may deploy in environments containing different databases available without having explicit support to each database, also for using a database connection with little or no knowledge of the database.<\/li><li> mysqli doesn&#8217;t allow you to handle exception. The function die(); will just stop executing the script suddenly and then show the error to the screen to the user which is NOT&nbsp;desirable &amp; allowing hackers to discover your schema.<\/li><\/ul>\n\n\n\n<p><strong>PDO provides three error handling modes:<\/strong><\/p>\n\n\n\n<ol><li><strong>PDO:<g class=\"gr_ gr_11 gr-alert gr_gramm gr_inline_cards gr_run_anim Style replaceWithoutSep\" id=\"11\" data-gr-id=\"11\">:ERRMODE_SILENT<\/g>&nbsp;<\/strong>acts like <g class=\"gr_ gr_9 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling\" id=\"9\" data-gr-id=\"9\">mysqli<\/g> where you have to check each result and then look at&nbsp;$db-&gt;getMessage();&nbsp;to get the error details.<\/li><li><strong>PDO:<\/strong><g class=\"gr_ gr_10 gr-alert gr_gramm gr_inline_cards gr_run_anim Style replaceWithoutSep\" id=\"10\" data-gr-id=\"10\">:ERRMODE_WARNING<\/g>&nbsp;throws PHP Warnings on the output screen.<\/li><li><strong>PDO:<\/strong><g class=\"gr_ gr_18 gr-alert gr_gramm gr_inline_cards gr_run_anim Style replaceWithoutSep\" id=\"18\" data-gr-id=\"18\">:ERRMODE_EXCEPTION<\/g>&nbsp;throws PDOException. This is the best <g class=\"gr_ gr_14 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep\" id=\"14\" data-gr-id=\"14\">mode<\/g> use. It acts much like&nbsp;or <g class=\"gr_ gr_15 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace\" id=\"15\" data-gr-id=\"15\">die<\/g>(mysql_error());&nbsp;when it isn&#8217;t caught, but unlike <g class=\"gr_ gr_16 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace\" id=\"16\" data-gr-id=\"16\">die<\/g>()&nbsp;the PDOException can be caught and handled if you want to do so.<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Limitation of PDO<\/h2>\n\n\n\n<p>The <g class=\"gr_ gr_100 gr-alert sel gr_gramm gr_replaced gr_inline_cards gr_disable_anim_appear Style multiReplace\" id=\"100\" data-gr-id=\"100\">Limitation is<\/g> that you lose direct control of your queries, which can make complex queries difficult to write or move a lot of operations <g class=\"gr_ gr_6 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace\" id=\"6\" data-gr-id=\"6\">off<\/g> the database and into PHP, requiring larger results thereby reducing code and database performance.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">PDO Set Up<\/h2>\n\n\n\n<p>For installation procedure, visit: <a href=\"http:\/\/php.net\/manual\/en\/pdo.installation.php\">http:\/\/php.net\/manual\/en\/pdo.installation.php<\/a><\/p>\n\n\n\n<p><strong>Examples<\/strong><\/p>\n\n\n\n<p>Database Connection Establishment using PDO<\/p>\n\n\n\n<p>Here is an example using PDO:<\/p>\n\n\n\n<pre class=\"theme:eclipse font:verdana toolbar:2\n show-plain:3 lang:default decode:true\"> \n<?php\n$servername = \"localhost \";\n$username = \"username\";\n$password = \"password\";\ntry\n\t{\n\t$con = newPDO(\"mysql:host=$servername;databasename=DB_database\", $username, $password);\n\n\t\/\/ provide an existing database to avoid exception\n\n\t$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n\techo \"Connection Created successfully!\";\n\tcatch(PDOException $e)\n\t\t{\n\t\techo \"Connection failed: \" . $e->getMessage();\n\t\t}\n\n?>\n\n\n\n<\/pre>\n\n\n\n<p><strong>Run Query Without variables<\/strong><\/p>\n\n\n\n<p>For simple queries without PHP variable parameters, use the following PDO code:<\/p>\n\n\n\n<pre class=\"theme:eclipse font:verdana toolbar:2\n show-plain:3 lang:default decode:true\"> \n<?php\n$affected_rows = $db->exec(\"UPDATE table_name SET field_name='value'\");\necho $affected_rows . ' are affected';\n?>\n\n<\/pre>\n\n\n\n<p>Just change query for the simple DELETE, and INSERT statements within the above written code.<\/p>\n\n\n\n<p><strong>Run Query With PHP Variables<\/strong><\/p>\n\n\n\n<p>For statements that take PHP variable parameters, <g class=\"gr_ gr_4 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace\" id=\"4\" data-gr-id=\"4\">MySQLi<\/g> uses a long tiring process to perform the task whereas PDO offers you an easier process using method <g class=\"gr_ gr_5 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace\" id=\"5\" data-gr-id=\"5\">calling<\/g>. The example for SELECT statement is as follows:<\/p>\n\n\n\n<pre class=\"theme:eclipse font:verdana toolbar:2\n show-plain:3 lang:default decode:true\"> \n<?php\n$qry = $db->prepare(\"SELECT * FROM table_name_Ebhor WHERE fld_id=? AND fld_name=?\");\n$qry->execute(array(\n\t$variable_id,\n\t$variable_name\n));\n$rows = $qry->fetchAll(PDO::FETCH_ASSOC);\n?>\n\n<\/pre>\n\n\n\n<p>Here we have performed three steps as follows:<\/p>\n\n\n\n<ul><li> Prepare: A valid query template is created and sent to the database where some values are unspecified (labelled as &#8220;?&#8221;). <\/li><li> Then the database parses, compiles, performs query optimization on the query template, and also stores the query result without executing it.<\/li><li> Execute: Later on, the application binds the values to the parameters, and the database executes the statement in lesser time using execute. The application may execute the prepared query as many times as the user wants with different values as per the requirements. It is a safer solution than concatenating strings together using MySQLi approach.<\/li><\/ul>\n\n\n\n<p>N.B.: While binding parameters, never put quotes around the &#8216;?&#8217; placeholders. It will cause SQL syntax errors because quotes aren&#8217;t needed to be known while preparing the query.<\/p>\n\n\n\n<p>Read More<\/p>\n\n\n\n<ol id=\"block-c86ec2ee-90c2-423b-b83a-aa83c3211e3a\"><li><a href=\"http:\/\/ebhor.com\/php-and-mysql\/\">PHP MySQL CRUD Tutorial with MySqli and PHPMyAdmin<\/a><\/li><li><a href=\"http:\/\/ebhor.com\/fetch-image-from-database-in-php\/\">How to fetch image from database in PHP and display in table<\/a><\/li><li><a href=\"http:\/\/ebhor.com\/how-to-export-and-import-mysql-database-using-phpmyadmin\/\">How to Export and Import MySql Database using phpMyAdmin<\/a><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>What is PDO? Other than procedural methods like MySQLi, PHP also provides an object oriented approach to deal with databases. This framework is widely known as PDO: PHP Data Objects. Advantages of PDO PDO is applicable on 12 different databases whereas MySQLi is not, which makes PDO more flexible than typical procedural approach. PDO also &#8230; <a title=\"PDO in PHP\" class=\"read-more\" href=\"https:\/\/www.ebhor.com\/pdo-in-php\/\" aria-label=\"More on PDO in PHP\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[197,7],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PDO in PHP - Ebhor.com<\/title>\n<meta name=\"description\" content=\"pdo in php definition uses advantages limitation pdo connection example php mysql php pdo select update database query pdo FETCH_ASSOC php pdo prepared statement\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.ebhor.com\/pdo-in-php\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PDO in PHP - Ebhor.com\" \/>\n<meta property=\"og:description\" content=\"pdo in php definition uses advantages limitation pdo connection example php mysql php pdo select update database query pdo FETCH_ASSOC php pdo prepared statement\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.ebhor.com\/pdo-in-php\/\" \/>\n<meta property=\"og:site_name\" content=\"Ebhor.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ebhorcom\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-21T09:43:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-19T07:05:41+00:00\" \/>\n<meta name=\"author\" content=\"manish\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"manish\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.ebhor.com\/pdo-in-php\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.ebhor.com\/pdo-in-php\/\"},\"author\":{\"name\":\"manish\",\"@id\":\"https:\/\/www.ebhor.com\/#\/schema\/person\/6a63908fdbbb27289970569ebd2e709b\"},\"headline\":\"PDO in PHP\",\"datePublished\":\"2018-09-21T09:43:34+00:00\",\"dateModified\":\"2021-02-19T07:05:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.ebhor.com\/pdo-in-php\/\"},\"wordCount\":586,\"publisher\":{\"@id\":\"https:\/\/www.ebhor.com\/#organization\"},\"keywords\":[\"pdo\",\"php\"],\"articleSection\":[\"php\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.ebhor.com\/pdo-in-php\/\",\"url\":\"https:\/\/www.ebhor.com\/pdo-in-php\/\",\"name\":\"PDO in PHP - Ebhor.com\",\"isPartOf\":{\"@id\":\"https:\/\/www.ebhor.com\/#website\"},\"datePublished\":\"2018-09-21T09:43:34+00:00\",\"dateModified\":\"2021-02-19T07:05:41+00:00\",\"description\":\"pdo in php definition uses advantages limitation pdo connection example php mysql php pdo select update database query pdo FETCH_ASSOC php pdo prepared statement\",\"breadcrumb\":{\"@id\":\"https:\/\/www.ebhor.com\/pdo-in-php\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.ebhor.com\/pdo-in-php\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.ebhor.com\/pdo-in-php\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.ebhor.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PDO in PHP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.ebhor.com\/#website\",\"url\":\"https:\/\/www.ebhor.com\/\",\"name\":\"Ebhor.com\",\"description\":\"Read The Latest Post Java, Css, Html, Php learning articles\",\"publisher\":{\"@id\":\"https:\/\/www.ebhor.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.ebhor.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.ebhor.com\/#organization\",\"name\":\"Ebhor.com\",\"url\":\"https:\/\/www.ebhor.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.ebhor.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.ebhor.com\/wp-content\/uploads\/2021\/05\/cropped-cropped-cropped-ebhor_logo_100x.jpg\",\"contentUrl\":\"https:\/\/www.ebhor.com\/wp-content\/uploads\/2021\/05\/cropped-cropped-cropped-ebhor_logo_100x.jpg\",\"width\":100,\"height\":100,\"caption\":\"Ebhor.com\"},\"image\":{\"@id\":\"https:\/\/www.ebhor.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ebhorcom\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.ebhor.com\/#\/schema\/person\/6a63908fdbbb27289970569ebd2e709b\",\"name\":\"manish\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.ebhor.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/def43b1d916cff76638fa6c47604a2bb?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/def43b1d916cff76638fa6c47604a2bb?s=96&r=g\",\"caption\":\"manish\"},\"description\":\"A Learner and Teacher\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PDO in PHP - Ebhor.com","description":"pdo in php definition uses advantages limitation pdo connection example php mysql php pdo select update database query pdo FETCH_ASSOC php pdo prepared statement","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.ebhor.com\/pdo-in-php\/","og_locale":"en_US","og_type":"article","og_title":"PDO in PHP - Ebhor.com","og_description":"pdo in php definition uses advantages limitation pdo connection example php mysql php pdo select update database query pdo FETCH_ASSOC php pdo prepared statement","og_url":"https:\/\/www.ebhor.com\/pdo-in-php\/","og_site_name":"Ebhor.com","article_publisher":"https:\/\/www.facebook.com\/ebhorcom\/","article_published_time":"2018-09-21T09:43:34+00:00","article_modified_time":"2021-02-19T07:05:41+00:00","author":"manish","twitter_card":"summary_large_image","twitter_misc":{"Written by":"manish","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.ebhor.com\/pdo-in-php\/#article","isPartOf":{"@id":"https:\/\/www.ebhor.com\/pdo-in-php\/"},"author":{"name":"manish","@id":"https:\/\/www.ebhor.com\/#\/schema\/person\/6a63908fdbbb27289970569ebd2e709b"},"headline":"PDO in PHP","datePublished":"2018-09-21T09:43:34+00:00","dateModified":"2021-02-19T07:05:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.ebhor.com\/pdo-in-php\/"},"wordCount":586,"publisher":{"@id":"https:\/\/www.ebhor.com\/#organization"},"keywords":["pdo","php"],"articleSection":["php"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.ebhor.com\/pdo-in-php\/","url":"https:\/\/www.ebhor.com\/pdo-in-php\/","name":"PDO in PHP - Ebhor.com","isPartOf":{"@id":"https:\/\/www.ebhor.com\/#website"},"datePublished":"2018-09-21T09:43:34+00:00","dateModified":"2021-02-19T07:05:41+00:00","description":"pdo in php definition uses advantages limitation pdo connection example php mysql php pdo select update database query pdo FETCH_ASSOC php pdo prepared statement","breadcrumb":{"@id":"https:\/\/www.ebhor.com\/pdo-in-php\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ebhor.com\/pdo-in-php\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.ebhor.com\/pdo-in-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.ebhor.com\/"},{"@type":"ListItem","position":2,"name":"PDO in PHP"}]},{"@type":"WebSite","@id":"https:\/\/www.ebhor.com\/#website","url":"https:\/\/www.ebhor.com\/","name":"Ebhor.com","description":"Read The Latest Post Java, Css, Html, Php learning articles","publisher":{"@id":"https:\/\/www.ebhor.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ebhor.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.ebhor.com\/#organization","name":"Ebhor.com","url":"https:\/\/www.ebhor.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.ebhor.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.ebhor.com\/wp-content\/uploads\/2021\/05\/cropped-cropped-cropped-ebhor_logo_100x.jpg","contentUrl":"https:\/\/www.ebhor.com\/wp-content\/uploads\/2021\/05\/cropped-cropped-cropped-ebhor_logo_100x.jpg","width":100,"height":100,"caption":"Ebhor.com"},"image":{"@id":"https:\/\/www.ebhor.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ebhorcom\/"]},{"@type":"Person","@id":"https:\/\/www.ebhor.com\/#\/schema\/person\/6a63908fdbbb27289970569ebd2e709b","name":"manish","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.ebhor.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/def43b1d916cff76638fa6c47604a2bb?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/def43b1d916cff76638fa6c47604a2bb?s=96&r=g","caption":"manish"},"description":"A Learner and Teacher"}]}},"_links":{"self":[{"href":"https:\/\/www.ebhor.com\/wp-json\/wp\/v2\/posts\/3714"}],"collection":[{"href":"https:\/\/www.ebhor.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ebhor.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ebhor.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ebhor.com\/wp-json\/wp\/v2\/comments?post=3714"}],"version-history":[{"count":0,"href":"https:\/\/www.ebhor.com\/wp-json\/wp\/v2\/posts\/3714\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ebhor.com\/wp-json\/wp\/v2\/media?parent=3714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ebhor.com\/wp-json\/wp\/v2\/categories?post=3714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ebhor.com\/wp-json\/wp\/v2\/tags?post=3714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}