{"id":386,"date":"2007-08-08T22:41:42","date_gmt":"2007-08-08T14:41:42","guid":{"rendered":"http:\/\/192.168.50.160\/wordpress\/?p=386"},"modified":"2012-11-14T09:49:09","modified_gmt":"2012-11-14T01:49:09","slug":"phpmysql-%e4%ba%82%e7%a2%bc%e5%97%8e","status":"publish","type":"post","link":"https:\/\/history.dowdot.idv.tw\/?p=386","title":{"rendered":"PHP+MySQL \u4e82\u78bc\u55ce??!!"},"content":{"rendered":"<p><a title=\"phpmyadmin\u7684\u7de8\u78bc\" href=\"http:\/\/192.168.50.160\/wordpress\/albums\/album127\/Snap3.png\" rel=\"lightbox\"><img src=\"http:\/\/192.168.50.160\/wordpress\/albums\/album127\/Snap3.thumb.png\" alt=\"phpmyadmin\u7684\u7de8\u78bc\" width=\"400\" \/><\/a><\/p>\n<p>\u6709\u4f7f\u7528MySQL\u7248\u672c 4.1.x \u4e4b\u5f8c\u7684\u4eba\u61c9\u8a72\u90fd\u6703\u9047\u5230\u4e82\u78bc\u7684\u554f\u984c,\u6700\u8fd1\u8c46\u5b50\u7528PHP\u5beb\u4e86\u4e00\u652f\u7a0b\u5f0f\u4e26\u6293\u53d6MySQL\u88e1\u7684DATA,\u4f46\u662f\u4ee5\u5f80\u5728phpMyAdmin\u6216\u662f\u7528PHP\u6293\u53d6\u6216\u7de8\u8f2f\u4e2d\u6587DATA\u6642\u90fd\u662f\u6b63\u5e38\u7684\u3002\u4f46\u662f\u9019\u6b21\u9996\u5148\u5728phpMyAdmin\u5beb\u5165\u8cc7\u6599\u6642\u9047\u5230\u4e82\u78bc\u3002\u8c46\u5b50\u89e3\u6c7a\u7684\u65b9\u5f0f\u5c31\u662f\u5c07table\u7684\u7de8\u78bc\u6539\u6210 \"utf8_general_ci\",\u4e4b\u5f8c\u5728phpMyAdmin \u700f\u89bd\u4e2d\u6587\u5c31\u6b63\u5e38\u4e86\u3002<\/p>\n<p><!--more--><\/p>\n<p>\u89e3\u6c7a\u4e86\u4e0a\u8ff0\u7684\u554f\u984c\u5f8c,\u767c\u73fe\u9023php\u6240\u8b80\u51fa\u4f86\u7684DATA\u4f9d\u820a\u662f\u4e82\u78bc,\u7528google\u67e5\u4e86\u4e00\u4e0b,\u767c\u73fe\u5728\u9032\u884cmysql query\u4e4b\u524d\u52a0\u4e0a\u4ee5\u4e0b\u7684\u7a0b\u5f0f\u78bc,\u4e82\u78bc\u7684\u60c5\u5f62\u4e5f\u5c31\u89e3\u6c7a\u4e86\u3002\u96d6\u7136\u4e0d\u77e5\u9053\u9019\u662f\u5426\u662f\u6b63\u7d71\u7684\u89e3\u6c7a\u65b9\u6cd5,anyway,\u6211\u7684\u554f\u984c\u89e3\u6c7a\u4e86~~<\/p>\n<blockquote><p>$result =mysql_query(\"SET NAMES big5\");<\/p><\/blockquote>\n<p><a title=\"\u4e82\u78bc\" href=\"http:\/\/192.168.50.160\/wordpress\/albums\/album127\/Snap1.png\" rel=\"lightbox\"><img src=\"http:\/\/192.168.50.160\/wordpress\/albums\/album127\/Snap1.thumb.png\" alt=\"\u4e82\u78bc\" width=\"258\" \/><\/a><\/p>\n<p><a title=\"\u7de8\u78bc\u6b63\u5e38\" href=\"http:\/\/192.168.50.160\/wordpress\/albums\/album127\/Snap2.png\" rel=\"lightbox\"><img src=\"http:\/\/192.168.50.160\/wordpress\/albums\/album127\/Snap2.thumb.png\" alt=\"\u7de8\u78bc\u6b63\u5e38\" width=\"258\" \/><\/a><\/p>\n<p>[20121114 - \u66f4\u65b0]<\/p>\n<p>\u82e5\u8cc7\u6599\u5eab\u7684\u7de8\u78bc\u8207\u7db2\u9801\u7684\u7de8\u78bc\u90fd\u5df2\u7d93\u4f7f\u7528UTF8\uff0c\u90a3\u9ebc\u7a0b\u5f0f\u7576\u7136\u8981\u4fee\u6b63\u70bautf8:<\/p>\n<pre class=\"brush: php; gutter: true; first-line: 1; highlight: []; html-script: false\">\r\n$result =mysql_query(&quot;SET NAMES utf8&quot;);\r\n<\/pre>\n<p>\u5982\u679c\u6aa2\u67e5\u904e\u4e00\u5207\u6a94\u6848\u53ca\u9023\u7dda<br \/>\n\u9084\u662f\u4e0d\u884c\u7684\u8a71\u53ef\u4ee5\u518d\u589e\u52a0\u4e8c\u884c\u9023\u7dda\u8cc7\u8a0a<\/p>\n<pre class=\"brush: php; gutter: true; first-line: 1; highlight: []; html-script: false\">\r\nmysql_query(&#039;SET CHARACTER_SET_CLIENT=utf8&#039;);\r\nmysql_query(&#039;SET CHARACTER_SET_RESULTS=utf8&#039;);\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6709\u4f7f\u7528MySQL\u7248\u672c 4.1.x \u4e4b\u5f8c\u7684\u4eba\u61c9\u8a72\u90fd\u6703\u9047\u5230\u4e82\u78bc\u7684\u554f\u984c,\u6700\u8fd1\u8c46\u5b50\u7528PHP\u5beb\u4e86\u4e00\u652f\u7a0b\u5f0f\u4e26\u6293\u53d6MySQL\u88e1\u7684DATA,\u4f46\u662f\u4ee5\u5f80\u5728phpMyAdmin\u6216\u662f\u7528PHP\u6293\u53d6\u6216\u7de8\u8f2f\u4e2d\u6587DATA\u6642\u90fd\u662f\u6b63\u5e38\u7684\u3002\u4f46\u662f\u9019\u6b21\u9996\u5148\u5728phpMyAdmin\u5beb\u5165\u8cc7\u6599\u6642\u9047\u5230\u4e82\u78bc\u3002\u8c46\u5b50\u89e3\u6c7a\u7684\u65b9\u5f0f\u5c31\u662f\u5c07table\u7684\u7de8\u78bc\u6539\u6210 &#8220;&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":""},"categories":[8],"tags":[],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5NCTI-6e","_links":{"self":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/386"}],"collection":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=386"}],"version-history":[{"count":2,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/386\/revisions"}],"predecessor-version":[{"id":1270,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/386\/revisions\/1270"}],"wp:attachment":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}