{"id":13222,"date":"2022-10-03T10:07:55","date_gmt":"2022-10-03T04:37:55","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/"},"modified":"2022-10-03T10:07:55","modified_gmt":"2022-10-03T04:37:55","slug":"solved-can-i-improve-my-pdo-method-just-started","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/","title":{"rendered":"[Solved] Can I improve my PDO method (just started)"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n
catch(PDOException $e) {\n    echo '<p class=\"error\">Database query error!<\/p>';\n}\n<\/code><\/pre>\n
I would use the opportunity to log which<\/em> database query error occurred.<\/p>\n
See example here: http:\/\/php.net\/manual\/en\/pdostatement.errorinfo.php<\/a><\/p>\n
Also if you catch an error, you should probably return<\/code> from the function or the script.<\/p>\n
if ($STH) {  \/\/ does this really need an if clause for it self?\n<\/code><\/pre>\n
If $STH<\/code> isn’t valid, then it should have generated an exception and been caught previously. And if you had returned from the function in that catch block, then you wouldn’t get to this point in the code, so there’s no need to test $STH<\/code> for being non-null again. Just start fetching from it.<\/p>\n
    $row = $STH->fetch();\n\n    if (!empty($row)) {  \/\/ was there found a row with content?\n<\/code><\/pre>\n
I would write it this way:<\/p>\n
$found_one = false;\nwhile ($row = $STH->fetch()) {\n    $found_one = true;\n    . . . do other stuff with data . . .\n}\nif (!$found_one) { \n    echo \"Sorry! Nothing found. Here's some default info:\";\n    . . . output default info here . . .\n}\n<\/code><\/pre>\n
No need to test if it’s empty, because if it were, the loop would exit.<\/p>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            7<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved Can I improve my PDO method (just started) <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] catch(PDOException $e) { echo ‘<p class=”error”>Database query error!<\/p>’; } I would use the opportunity to log which database query error occurred. See example here: http:\/\/php.net\/manual\/en\/pdostatement.errorinfo.php Also if you catch an error, you should probably return from the function or the script. if ($STH) { \/\/ does this really need an if clause for it … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[855,339,2429],"class_list":["post-13222","post","type-post","status-publish","format-standard","hentry","category-solved","tag-pdo","tag-php","tag-prepared-statement"],"yoast_head":"\n[Solved] Can I improve my PDO method (just started) - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Can I improve my PDO method (just started) - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] catch(PDOException $e) { echo '<p class="error">Database query error!<\/p>'; } I would use the opportunity to log which database query error occurred. See example here: http:\/\/php.net\/manual\/en\/pdostatement.errorinfo.php Also if you catch an error, you should probably return from the function or the script. if ($STH) { \/\/ does this really need an if clause for it ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-03T04:37:55+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Can I improve my PDO method (just started)\",\"datePublished\":\"2022-10-03T04:37:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/\"},\"wordCount\":134,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"pdo\",\"php\",\"prepared-statement\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/\",\"name\":\"[Solved] Can I improve my PDO method (just started) - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-03T04:37:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Can I improve my PDO method (just started)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Can I improve my PDO method (just started) - JassWeb","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:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Can I improve my PDO method (just started) - JassWeb","og_description":"[ad_1] catch(PDOException $e) { echo '<p class=\"error\">Database query error!<\/p>'; } I would use the opportunity to log which database query error occurred. See example here: http:\/\/php.net\/manual\/en\/pdostatement.errorinfo.php Also if you catch an error, you should probably return from the function or the script. if ($STH) { \/\/ does this really need an if clause for it ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/","og_site_name":"JassWeb","article_published_time":"2022-10-03T04:37:55+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Can I improve my PDO method (just started)","datePublished":"2022-10-03T04:37:55+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/"},"wordCount":134,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["pdo","php","prepared-statement"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/","url":"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/","name":"[Solved] Can I improve my PDO method (just started) - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-03T04:37:55+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-can-i-improve-my-pdo-method-just-started\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Can I improve my PDO method (just started)"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/13222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=13222"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/13222\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=13222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=13222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=13222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}