usky-website/web/dc.php

<?php
//header('Content-type: text/html; charset=UTF-8');
//header("Content-type:application/vnd.ms-excel;charset=UTF-8");
//header("Content-Disposition:filename=example.xls"); //输出的表格名称
//echo "id\t";echo "type\t";echo "name\t";echo "content\t";echo "url\t";echo "ord\t\n";
////这是表格头字段 加\T就是换格,加\T\N就是结束这一行,换行的意思
//$conn = mysql_connect("localhost","a0313085524","1f84d01e") or die("不能连接数据库");
//mysql_select_db("a0313085524", $conn);
//mysql_query("set names 'UTF-8'");
//$sql="select * from example";
//$result=mysql_query($sql);
//while($row=mysql_fetch_array($result)){
//    echo $row[0]."\t";echo $row[1]."\t";echo $row[2]."\t";echo "'".$row[3]."'\t";echo $row[4]."\t";echo $row[5]."\t\n";
//}

//header("Content-type:application/vnd.ms-excel");
//header("Content-Disposition:filename=xls_region.xls");
//
//$cfg_dbhost = 'localhost';
//$cfg_dbname = 'a0313085524';
//$cfg_dbuser = 'a0313085524';
//$cfg_dbpwd = '1f84d01e';
//$cfg_db_language = 'utf8';
//// END 配置
////链接数据库
//$link = mysql_connect($cfg_dbhost, $cfg_dbuser, $cfg_dbpwd);
//mysql_select_db($cfg_dbname);
////选择编码
//mysql_query("set names " . $cfg_db_language);
////users表
//$sql = "desc example";
//
//$res = mysql_query($sql);
//echo "<table><tr>";
////导出表头（也就是表中拥有的字段）
//while ($row = mysql_fetch_array($res)) {
//    $t_field[] = $row['Field'];//Field中的F要大写，否则没有结果
//    echo "<th>" . $row['Field'] . "</th>";
//}
//echo "</tr>";
////导出100条数据
//$sql = "select * from example";
//$res = mysql_query($sql);
//while ($row = mysql_fetch_array($res)) {
//    echo "<tr>";
//    foreach ($t_field as $f_key) {
//        echo "<td>'" . $row[$f_key] . "'</td>";
//    }
//    echo "</tr>";
//}
//echo "</table>";


header("Content-type:text/html;charset=utf-8");

//配置信息
$cfg_dbhost = 'localhost';
$cfg_dbname = 'a0313085524';
$cfg_dbuser = 'a0313085524';
$cfg_dbpwd = '1f84d01e';
$cfg_db_language = 'utf8';
$to_file_name = "example.sql";
// END 配置
//链接数据库
$link = mysql_connect($cfg_dbhost, $cfg_dbuser, $cfg_dbpwd);
mysql_select_db($cfg_dbname);
//选择编码
mysql_query("set names " . $cfg_db_language);
//数据库中有哪些表
$tables = mysql_list_tables($cfg_dbname);
//将这些表记录到一个数组
$tabList = array();
while($row = mysql_fetch_row($tables)){
$tabList[] = $row[0];
}

echo "运行中，请耐心等待...<br/>";
$info = "-- ----------------------------\r\n";
$info .= "-- 日期：" . date("Y-m-d H:i:s", time()) . "\r\n";
$info .= "-- 仅用于测试和学习,本程序不适合处理超大量数据\r\n";
$info .= "-- ----------------------------\r\n\r\n";
file_put_contents($to_file_name, $info, FILE_APPEND);
//将每个表的表结构导出到文件
foreach($tabList as $val){
    $sql = "show create table " . $val;
$res = mysql_query($sql, $link);
$row = mysql_fetch_array($res);
$info = "-- ----------------------------\r\n";
$info .= "-- Table structure for `" . $val . "`\r\n";
$info .= "-- ----------------------------\r\n";
$info .= "DROP TABLE IF EXISTS `" . $val . "`;\r\n";
$sqlStr = $info . $row[1] . ";\r\n\r\n";
//追加到文件
file_put_contents($to_file_name, $sqlStr, FILE_APPEND);
//释放资源
mysql_free_result($res);
}
//将每个表的数据导出到文件
foreach($tabList as $val){
    $sql = "select * from " . $val;
$res = mysql_query($sql, $link);
//如果表中没有数据，则继续下一张表
if(mysql_num_rows($res) < 1) continue;
//
$info = "-- ----------------------------\r\n";
$info .= "-- Records for `" . $val . "`\r\n";
$info .= "-- ----------------------------\r\n";
file_put_contents($to_file_name, $info, FILE_APPEND);
//读取数据
while($row = mysql_fetch_row($res)){
$sqlStr = "INSERT INTO `" . $val . "` VALUES (";
foreach($row as $zd){
        $sqlStr .= "'" . $zd . "', ";
}
//去掉最后一个逗号和空格
$sqlStr = substr($sqlStr, 0, strlen($sqlStr) - 2);
$sqlStr .= ");\r\n";
file_put_contents($to_file_name, $sqlStr, FILE_APPEND);
}
//释放资源
mysql_free_result($res);
file_put_contents($to_file_name, "\r\n", FILE_APPEND);
}

echo "OK!";




?>