{"id":450,"date":"2012-09-27T15:34:24","date_gmt":"2012-09-27T06:34:24","guid":{"rendered":"https:\/\/deskplate.net\/blog\/2012\/09\/27\/zend_db-%e3%81%a7pdo%e6%8e%a5%e7%b6%9a\/"},"modified":"2012-09-27T15:34:24","modified_gmt":"2012-09-27T06:34:24","slug":"zend_db-%e3%81%a7pdo%e6%8e%a5%e7%b6%9a","status":"publish","type":"post","link":"https:\/\/deskplate.net\/blog\/archives\/450","title":{"rendered":"Zend_DB \u3067PDO\u63a5\u7d9a"},"content":{"rendered":"<p>\/* Configures PDO to execute the &#8216;SET NAMES UTF8;&#8217; SQL query just before<br \/>\nany other query. If no query is executed on your page, this will not be<br \/>\nexecuted. *\/<br \/>\n$pdoParams = array(PDO::MYSQL_ATTR_INIT_COMMAND => &#8216;SET NAMES UTF8;&#8217;);<br \/>\n$params = array(<br \/>\n&#8216;host&#8217; => &#8216;localhost&#8217;,<br \/>\n&#8216;username&#8217; => &#8216;username&#8217;,<br \/>\n&#8216;password&#8217; => &#8216;password&#8217;,<br \/>\n&#8216;dbname&#8217; => &#8216;dbname&#8217;,<br \/>\n&#8216;driver_options&#8217; => $pdoParams<br \/>\n);<br \/>\ntry {<br \/>\n$db = Zend_Db::factory(&#8216;PDO_MYSQL&#8217;, $params);<br \/>\nZend_Db_Table_Abstract::setDefaultAdapter($db);<br \/>\n} catch (Exception $e) {<br \/>\nexit($e->getMessage());<br \/>\n}<br \/>\nZend_Registry::set(&#8216;dbAdapter&#8217;, $db);<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\/* Configures PDO to<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-450","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts\/450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/comments?post=450"}],"version-history":[{"count":0,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts\/450\/revisions"}],"wp:attachment":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/media?parent=450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/categories?post=450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/tags?post=450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}