{"id":37,"date":"2015-06-01T14:34:58","date_gmt":"2015-06-01T06:34:58","guid":{"rendered":"https:\/\/www.webteach.tw\/?p=37"},"modified":"2015-06-01T14:34:58","modified_gmt":"2015-06-01T06:34:58","slug":"pdo","status":"publish","type":"post","link":"https:\/\/www.webteach.tw\/?p=37","title":{"rendered":"[ PHP ] \u2013 #\u6559\u5b78 &#8211; \u8cc7\u6599\u5eab &#8211; PDO \u9023\u7dda\u7bc4\u4f8b"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>&lt;?php\n\/\/\u8cc7\u6599\u5eab\u8b8a\u6578\n$db_type = 'mysql';\/\/\u4f7f\u7528\u90a3\u4e00\u7a2e\u8cc7\u6599\u5eab\n$db_host = 'localhost';\/\/\u4e3b\u6a5f\u4f4d\u7f6e\n$db_name = 'student';\/\/\u8cc7\u6599\u5eab\u540d\u7a31\n$db_user = 'root';\/\/\u4f7f\u7528\u8005\n$db_password= '12345';\/\/\u5bc6\u78bc\n\/\/ \u8cc7\u6599\u5eab\u9023\u7dda\ntry {\n$db = new PDO($db_type . ':host=' . $db_host . ';dbname=' . $db_name, $db_user, $db_password);\n$db-&amp;gt;query('SET NAMES UTF8'); \/\/ \u8cc7\u6599\u5eab\u4f7f\u7528 UTF8 \u7de8\u78bc\n} catch (PDOException $e) {\necho 'Error!: ' . $e-&amp;gt;getMessage() . '&amp;lt;br \/&amp;gt;';\n}\ndate_default_timezone_set(\"Asia\/Taipei\");\/\/\u8a2d\u5b9a\u6642\u5340\n?><\/code><\/pre>\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.webteach.tw\/?p=1434\" target=\"_blank\" rel=\"noreferrer noopener\">\u56dePHP\u6559\u5b78\u76ee\u9304<\/a><\/p>\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.youtube.com\/watch?v=CfmYngJX1KA&amp;list=PLsoGqZoi3gwu542-wJplt6U-_KYKTVvlw\" target=\"_blank\" rel=\"noreferrer noopener\">\u4ee5\u7269\u4ef6\u7684\u65b9\u5f0f\u4f7f\u7528PDO\u7bc4\u4f8b<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u56dePHP\u6559\u5b78\u76ee\u9304 \u4ee5\u7269\u4ef6\u7684\u65b9\u5f0f\u4f7f\u7528PDO\u7bc4\u4f8b<\/p>\n","protected":false},"author":1,"featured_media":2201,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[444,448,1198],"class_list":["post-37","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-pdo","tag-php","tag-1198","hvn-theme-has-thumbnail"],"_links":{"self":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/37","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=37"}],"version-history":[{"count":0,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/37\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/media\/2201"}],"wp:attachment":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=37"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=37"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}