{"id":1345,"date":"2011-11-25T09:32:37","date_gmt":"2011-11-25T01:32:37","guid":{"rendered":"\/wp\/?p=1345"},"modified":"2015-07-11T07:50:51","modified_gmt":"2015-07-10T23:50:51","slug":"php%e5%a4%87%e4%bb%bdmysql%e6%95%b0%e6%8d%ae%e5%ba%93%e6%ba%90%e7%a0%81","status":"publish","type":"post","link":"https:\/\/lordong.xyz\/wp\/post\/1345.html","title":{"rendered":"PHP\u5907\u4efdMySQL\u6570\u636e\u5e93\u6e90\u7801"},"content":{"rendered":"<p>\u53c2\u8003\u6765\u6e90\uff1a<a href=\"http:\/\/down.chinazhan.net\/article\/14\/28\/ChinaZhan_15846.html\" target=\"_blank\">\u4e2d\u56fd\u7ad9\u957f\u7f51<\/a><\/p>\n<p>\u5bf9\u6e90\u4ee3\u7801\u505a\u4e86\u5c40\u90e8\u4fee\u6b63\uff1a<br \/>\n1. \u589e\u52a0PHP\u5934\uff0c\u58f0\u660e\u4ee5utf-8\u8f93\u51fa\u3002<br \/>\n2. \u8003\u8651\u5230\u901a\u8fc7crontab\u6765\u6bcf12\u4e2a\u5c0f\u65f6\u5907\u4efd\u4e00\u4e0b\uff0c\u56e0\u6b64\u6587\u4ef6\u540d\u589e\u52a0\u4e86\u5230\u65f6\u95f4date('YmdH')\u3002<br \/>\n3. \u65b0\u5efadb\u5b50\u76ee\u5f55\u7528\u4e8e\u5b58\u653esql\u6570\u636e\u5e93\uff0c\u8fd9\u6837\u5c31\u4e0d\u5f71\u54cd\u5230php\u6e90\u7801\u7684\u6574\u6d01\u3002<br \/>\n4. \u628a\u90a3\u4e9b\u8ba9\u4eba\u4e0d\u77e5\u6240\u4ee5\u7136\u7684\u201crn\u201d\u66ff\u6362\u6210\u6b63\u786e\u7684\u4ee3\u7801\u3002<br \/>\n<!--more--><br \/>\n\u66f4\u65b0\u540e\u7684\u6e90\u7801\u5982\u4e0b\uff1a<br \/>\n[php]<?php\nheader('Content-Type:text\/html;charset=utf-8');\nheader(\"Expires: 0\");\nheader('Cache-Control: no-cache, must-revalidate');\nheader('Pragma: no-cache');\n\n$host=\"localhost\";\n$user=\"\u6570\u636e\u5e93\u7528\u6237\u540d\";\n$password=\"\u6570\u636e\u5e93\u7528\u6237\u5bc6\u7801\";\n$dbname=\"\u6570\u636e\u5e93\u540d\";\n\n$destination_folder = 'db\/';\nif (!file_exists($destination_folder))\n{\n\tmkdir($destination_folder);\n}\n\nmysql_connect($host,$user,$password);\nmysql_select_db($dbname);\n$mysql= \"set charset utf8;\\r\\n\";\n$q1=mysql_query(\"show tables\");\nwhile($t=mysql_fetch_array($q1)){\n    $table=$t[0];\n    $q2=mysql_query(\"show create table `$table`\");\n    $sql=mysql_fetch_array($q2);\n    $mysql.=$sql['Create Table'].\";\\r\\n\\r\\n\";\n\n    $q3=mysql_query(\"select * from `$table`\");\n    while($data=mysql_fetch_assoc($q3)){\n        $keys=array_keys($data);\n        $keys=array_map('addslashes',$keys);\n        $keys=join('`,`',$keys);\n        $keys=\"`\".$keys.\"`\";\n        $vals=array_values($data);\n        $vals=array_map('addslashes',$vals);\n        $vals=join(\"','\",$vals);\n        $vals=\"'\".$vals.\"'\";\n        $mysql.=\"insert into `$table`($keys) values($vals);\\r\\n\";\n    }\n    $mysql.=\"\\r\\n\";\n}\n$filename=$destination_folder . date('YmdH') . \".sql\";\n$fp = fopen($filename, 'w');\nfputs($fp, $mysql);\nfclose($fp);\necho \"\u6570\u636e\u5907\u4efd\u6210\u529f,\u751f\u6210\u5907\u4efd\u6587\u4ef6\" . $filename . \"\";\n?>[\/php]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53c2\u8003\u6765\u6e90\uff1a\u4e2d\u56fd\u7ad9\u957f\u7f51 \u5bf9\u6e90\u4ee3\u7801\u505a\u4e86\u5c40\u90e8\u4fee\u6b63\uff1a 1. \u589e\u52a0PHP\u5934\uff0c\u58f0\u660e\u4ee5utf-8\u8f93\u51fa\u3002 2. \u8003\u8651\u5230\u901a\u8fc7cr [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[92],"tags":[120,111],"class_list":["post-1345","post","type-post","status-publish","format-standard","hentry","category-92","tag-mysql","tag-php"],"_links":{"self":[{"href":"https:\/\/lordong.xyz\/wp\/wp-json\/wp\/v2\/posts\/1345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lordong.xyz\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lordong.xyz\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lordong.xyz\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lordong.xyz\/wp\/wp-json\/wp\/v2\/comments?post=1345"}],"version-history":[{"count":0,"href":"https:\/\/lordong.xyz\/wp\/wp-json\/wp\/v2\/posts\/1345\/revisions"}],"wp:attachment":[{"href":"https:\/\/lordong.xyz\/wp\/wp-json\/wp\/v2\/media?parent=1345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lordong.xyz\/wp\/wp-json\/wp\/v2\/categories?post=1345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lordong.xyz\/wp\/wp-json\/wp\/v2\/tags?post=1345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}