{"id":2189,"date":"2013-11-05T14:29:11","date_gmt":"2013-11-05T06:29:11","guid":{"rendered":"http:\/\/kuki.idv.tw\/?p=2189"},"modified":"2013-11-05T14:29:11","modified_gmt":"2013-11-05T06:29:11","slug":"%e9%9d%9e%e5%8e%9f%e5%89%b5mysql%e7%9a%84php%e5%82%99%e4%bb%bd%e8%aa%9e%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.kuki.idv.tw\/?p=2189","title":{"rendered":"[\u975e\u539f\u5275]MySQL\u7684php\u5099\u4efd\u8a9e\u6cd5"},"content":{"rendered":"<p>\u4f86\u6e90: \u00a0<a href=\"http:\/\/davidwalsh.name\/backup-mysql-database-php\">http:\/\/davidwalsh.name\/backup-mysql-database-php<\/a><\/p>\n<p>&nbsp;<\/p>\n<pre><code>backup_tables('localhost','username','password','blog');\r\n\r\n\/* backup the db OR just a table *\/\r\nfunction backup_tables($host,$user,$pass,$name,$tables = '*')\r\n{\r\n\r\n\t$link = mysql_connect($host,$user,$pass);\r\n\tmysql_select_db($name,$link);\r\n\r\n\t\/\/get all of the tables\r\n\tif($tables == '*')\r\n\t{\r\n\t\t$tables = array();\r\n\t\t$result = mysql_query('SHOW TABLES');\r\n\t\twhile($row = mysql_fetch_row($result))\r\n\t\t{\r\n\t\t\t$tables[] = $row[0];\r\n\t\t}\r\n\t}\r\n\telse\r\n\t{\r\n\t\t$tables = is_array($tables) ? $tables : explode(',',$tables);\r\n\t}\r\n\r\n\t\/\/cycle through\r\n\tforeach($tables as $table)\r\n\t{\r\n\t\t$result = mysql_query('SELECT * FROM '.$table);\r\n\t\t$num_fields = mysql_num_fields($result);\r\n\r\n\t\t$return.= 'DROP TABLE '.$table.';';\r\n\t\t$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));\r\n\t\t$return.= \"\\n\\n\".$row2[1].\";\\n\\n\";\r\n\r\n\t\tfor ($i = 0; $i &lt; $num_fields; $i++) \r\n\t\t{\r\n\t\t\twhile($row = mysql_fetch_row($result))\r\n\t\t\t{\r\n\t\t\t\t$return.= 'INSERT INTO '.$table.' VALUES(';\r\n\t\t\t\tfor($j=0; $j&lt;$num_fields; $j++) \r\n\t\t\t\t{\r\n\t\t\t\t\t$row[$j] = addslashes($row[$j]);\r\n\t\t\t\t\t$row[$j] = ereg_replace(\"\\n\",\"\\\\n\",$row[$j]);\r\n\t\t\t\t\tif (isset($row[$j])) { $return.= '\"'.$row[$j].'\"' ; } else { $return.= '\"\"'; }\r\n\t\t\t\t\tif ($j&lt;($num_fields-1)) { $return.= ','; }\r\n\t\t\t\t}\r\n\t\t\t\t$return.= \");\\n\";\r\n\t\t\t}\r\n\t\t}\r\n\t\t$return.=\"\\n\\n\\n\";\r\n\t}\r\n\r\n\t\/\/save file\r\n\t$handle = fopen('db-backup-'.time().'-'.(md5(implode(',',$tables))).'.sql','w+');\r\n\tfwrite($handle,$return);\r\n\tfclose($handle);\r\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4f86\u6e90: \u00a0http:\/\/davidwalsh.name\/backup-mysql-database-php &#038; &hellip; <a href=\"https:\/\/www.kuki.idv.tw\/?p=2189\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008[\u975e\u539f\u5275]MySQL\u7684php\u5099\u4efd\u8a9e\u6cd5\u3009<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2189"}],"collection":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2189"}],"version-history":[{"count":1,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2189\/revisions"}],"predecessor-version":[{"id":2190,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2189\/revisions\/2190"}],"wp:attachment":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}