{"id":3005,"date":"2016-04-26T11:20:50","date_gmt":"2016-04-26T03:20:50","guid":{"rendered":"http:\/\/blog.hoyo.idv.tw\/?p=3005"},"modified":"2023-12-11T09:41:51","modified_gmt":"2023-12-11T01:41:51","slug":"pdo-%e9%95%b7%e9%80%a3%e6%8e%a5-pdoattr_persistent-%e6%b8%ac%e8%a9%a6%e5%8f%8a%e4%ba%86%e8%a7%a3","status":"publish","type":"post","link":"https:\/\/blog.hoyo.idv.tw\/?p=3005","title":{"rendered":"PDO \u9577\u9023\u63a5 PDO::ATTR_PERSISTENT \u6e2c\u8a66\u53ca\u4e86\u89e3"},"content":{"rendered":"

PHP PDO MySQL \u9577\u9023\u7d50\u8a2d\u5b9a\u53ca\u5f71\u97ff<\/h2>\n

\u8a2d\u5b9a\u77ed\u9023\u63a5\uff0c\u4e00\u6b21\u8cc7\u6599\u5eab\u67e5\u8a62\u7a0b\u5f0f<\/p>\n

$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(\r\n    PDO::ATTR_PERSISTENT => false\r\n) );\r\n$PDO->exec(\"set names utf8\");\r\n\r\n$sql = \" SELECT * FROM UserLog  \";\r\n$pre = $PDO->prepare($sql);\r\n$pre->execute();<\/pre>\n
\u77ed\u9023\u63a5\uff0c\u4e00\u6b21\u8cc7\u6599\u5eab\u67e5\u8a62\u7d50\u679c<\/p>\n
\"2016-04-26 09:34:55\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",86,0,\"Connect\",\"MJAPP_SoundU@localhost on MJAPP_SoundU2\"\r\n\"2016-04-26 09:34:55\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",86,0,\"Query\",\"set names utf8\"\r\n\"2016-04-26 09:34:55\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",86,0,\"Query\",\"SET GLOBAL time_zone='+8:00'\"\r\n\"2016-04-26 09:34:55\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",86,0,\"Query\",\"SELECT * FROM UserLog\"\r\n\"2016-04-26 09:34:56\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",86,0,\"Quit\",\"\"<\/pre>\n
\u8a2d\u5b9a\u70ba\u9577\u9023\u63a5\u00a0PDO::ATTR_PERSISTENT => true<\/p>\n
$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(\r\n    PDO::ATTR_PERSISTENT => true\r\n) );\r\n$PDO->exec(\"set names utf8\");\r\n\r\n$sql = \" SELECT * FROM UserLog  \";\r\n$pre = $PDO->prepare($sql);\r\n$pre->execute();<\/pre>\n
\u9577\u9023\u63a5\uff0c\u4e00\u6b21\u8cc7\u6599\u5eab\u67e5\u8a62\u7d50\u679c<\/p>\n
\"2016-04-26 09:38:38\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",87,0,\"Connect\",\"MJAPP_SoundU@localhost on MJAPP_SoundU2\"\r\n\"2016-04-26 09:38:38\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",87,0,\"Query\",\"set names utf8\"\r\n\"2016-04-26 09:38:38\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",87,0,\"Query\",\"SELECT * FROM UserLog\"\r\n<\/pre>\n
\u77ed\u9023\u63a5\uff0c\u9023\u7e8c\u591a\u67e5\u8a62\u7a0b\u5f0f<\/p>\n
$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(\r\n    PDO::ATTR_PERSISTENT => false\r\n) );\r\n$PDO->exec(\"set names utf8\");\r\n\r\n$sql = \" SELECT * FROM UserLog LIMIT 1 \";\r\n$pre = $PDO->prepare($sql);\r\n$pre->execute();\r\n$sql = \" SELECT * FROM UserLog LIMIT 1 \";\r\n$pre = $PDO->prepare($sql);\r\n$pre->execute();\r\n$sql = \" SELECT * FROM UserLog LIMIT 1 \";\r\n$pre = $PDO->prepare($sql);\r\n$pre->execute();<\/pre>\n
\u77ed\u9023\u63a5\uff0c\u9023\u7e8c\u591a\u67e5\u8a62\u7d50\u679c<\/p>\n
\"2016-04-26 10:57:16\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",123,0,\"Connect\",\"MJAPP_SoundU@localhost on MJAPP_SoundU2\"\r\n\"2016-04-26 10:57:16\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",123,0,\"Query\",\"set names utf8\"\r\n\"2016-04-26 10:57:16\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",123,0,\"Query\",\"SELECT * FROM UserLog LIMIT 1\"\r\n\"2016-04-26 10:57:16\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",123,0,\"Query\",\"SELECT * FROM UserLog LIMIT 1\"\r\n\"2016-04-26 10:57:16\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",123,0,\"Query\",\"SELECT * FROM UserLog LIMIT 1\"\r\n\"2016-04-26 10:57:16\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",123,0,\"Quit\",\"\"\r\n<\/pre>\n
\u9577\u9023\u63a5\uff0c\u9023\u7e8c\u591a\u67e5\u8a62\u7a0b\u5f0f<\/p>\n
$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(\r\n    PDO::ATTR_PERSISTENT => true\r\n) );\r\n$PDO->exec(\"set names utf8\");\r\n\r\n$sql = \" SELECT * FROM UserLog LIMIT 1 \";\r\n$pre = $PDO->prepare($sql);\r\n$pre->execute();\r\n$sql = \" SELECT * FROM UserLog LIMIT 1 \";\r\n$pre = $PDO->prepare($sql);\r\n$pre->execute();\r\n$sql = \" SELECT * FROM UserLog LIMIT 1 \";\r\n$pre = $PDO->prepare($sql);\r\n$pre->execute();\r\n<\/pre>\n
\u9577\u9023\u63a5\uff0c\u9023\u7e8c\u591a\u67e5\u8a62\u7d50\u679c<\/p>\n
\"2016-04-26 10:58:28\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",66,0,\"Query\",\"set names utf8\"\r\n\"2016-04-26 10:58:28\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",66,0,\"Query\",\"SELECT * FROM UserLog LIMIT 1\"\r\n\"2016-04-26 10:58:28\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",66,0,\"Query\",\"SELECT * FROM UserLog LIMIT 1\"\r\n\"2016-04-26 10:58:28\",\"MJAPP_SoundU[MJAPP_SoundU] @ localhost []\",66,0,\"Query\",\"SELECT * FROM UserLog LIMIT 1\"\r\n<\/pre>\n
--<\/p>\n
<\/div>\n
<\/path><\/svg><\/i>  7,806 total views,  2 views today<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
PHP PDO MySQL \u9577...<\/p>\n
<\/div>\n
<\/path><\/svg><\/i>  7,806 total views,  2 views today<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[258,260],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/3005"}],"collection":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3005"}],"version-history":[{"count":2,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/3005\/revisions"}],"predecessor-version":[{"id":8279,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/3005\/revisions\/8279"}],"wp:attachment":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}