<?php
require_once '../../smartyConfig/smartyConfig.class.php';
require_once '../../game/include/function.php';
require_once '../../game/include/config.php';
require_once '../../game/server/server.class.php';
require_once '../../game/include/db.class.php';
$smarty->setTemplate_dir(GAME_ROOT);
$smarty->setCompile_dir(GAME_ROOT_C);
$serverName=$_GET['serverName'];
$tableName=$_GET['tableName'];
$dbLink=mysql_connect($serverInfos[$serverName][1],DEFAULT_USER,DEFAULT_PASSWORD,DEFAULT_DB_NAME);
mysql_query("set names 'gb2312'");
mysql_select_db(DEFAULT_DB_NAME);
$query=mysql_query("select * from ".$tableName,$dbLink);
if(!empty($tableName)) //通过一种方法,创键excel文件
{
$fileName=$tableName.".xls";
header("Content-Type: application/vnd.ms-execl;charset=gb2312");
header("Content-Disposition: attachment; filename=".$fileName);
header("Pragma: no-cache");
header("Expires: 0");
$now_date = date('Y-m-d H:i:s');
$title = "数据库名:".DEFAULT_DB_NAME." 表名:".$tableName." 备份日期:".$now_date;
echo iconv("utf-8","gb2312",$title."/n");
$resultSum=mysql_num_fields($query);
$fieldArray=mysql_list_fields(DEFAULT_DB_NAME,$tableName,$dbLink);
for($i=0;$i<$resultSum;$i++)
{
echo mysql_field_name($fieldArray,$i)."/t";
}
echo "/n";
while($resultArray=mysql_fetch_array($query))
{
for($i=0;$i<$resultSum;$i++)
{
echo $resultArray[$i]."/t";
}
echo "/n";
}
}
else
{
$now_date = date('Y-m-d H-i-s');
$folder=DEFAULT_DB_NAME.$now_date;
mkdir($folder,0777);
$dbLink=mysql_connect($serverInfos[$serverName][1],DEFAULT_USER,DEFAULT_PASSWORD,DEFAULT_DB_NAME);
mysql_query("set names 'gb2312'");
$tablesArray=mysql_list_tables(DEFAULT_DB_NAME,$dbLink);
while ($resultArray=mysql_fetch_array($tablesArray))
{
$tableName=$resultArray[0];
$file=fopen($folder."/".$tableName.".xls","a+");
$now_date = date('Y-m-d H:i:s');
$title = "数据库名:".DEFAULT_DB_NAME." 表名:".$tableName." 备份日期:".$now_date;
$title=iconv("utf-8","gb2312",$title."/n");
fwrite($file,$title);
$query=mysql_query("select * from ".$tableName,$dbLink);
$resultSum=mysql_num_fields($query);
$fieldArray=mysql_list_fields(DEFAULT_DB_NAME,$tableName,$dbLink);
for($i=0;$i<$resultSum;$i++)
{
fwrite($file,mysql_field_name($fieldArray,$i)."/t");
}
fwrite($file,"/n");
while ($resultArray=mysql_fetch_array($query))
{
for($i=0;$i<$resultSum;$i++)
{
//$resultArray[$i]=iconv("utf-8","gb2312",$resultArray[$i]);
fwrite($file,$resultArray[$i]."/t");
}
fwrite($file,"/n");
}
}
echo "导出成功";
}
?>