{"id":107,"date":"2015-07-29T02:17:00","date_gmt":"2015-07-29T02:17:00","guid":{"rendered":"http:\/\/waynenguyen.org\/dev\/2015\/07\/29\/how-to-debug-php-pdo-statements\/"},"modified":"2016-05-21T03:15:55","modified_gmt":"2016-05-21T03:15:55","slug":"how-to-debug-php-pdo-statements","status":"publish","type":"post","link":"https:\/\/bruceng.com\/dev\/?p=107","title":{"rendered":"How to debug PHP PDO statements"},"content":{"rendered":"<div dir=\"ltr\" style=\"text-align: left;\" trbidi=\"on\">\nTips for debugging PHP PDO statements:<\/p>\n<p>get the return value of $statement-&gt;execute(). It returns true on success and false on failure.<\/p>\n<p>use $statement-&gt;errorInfo(), to find out exactly the error in the query.<\/p>\n<p>Make use of xdebug and netbeans&#8217; debugging capability.<\/p>\n<p>Configure PDO to throw exception when errors occur<\/p>\n<pre class=\"default prettyprint prettyprinted\" style=\"background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;\">$db-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); <\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Tips for debugging PHP PDO statements: get the return value of $statement-&gt;execute(). It returns true on success and false on failure. use $statement-&gt;errorInfo(), to find out exactly the error in the query. Make use of xdebug and netbeans&#8217; debugging capability. Configure PDO to throw exception when errors occur $db-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-107","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=107"}],"version-history":[{"count":1,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/107\/revisions"}],"predecessor-version":[{"id":227,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/107\/revisions\/227"}],"wp:attachment":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}