导出为Excel 文件

[php]
// define database parameter
$db_server = "localhost";
$db_username = "root";
$db_password = "****";
$db_dbname = "db";
$db_tblname = "table";

// connect database
$connect = @mysql_connect($db_server, $db_username, $db_password) or die("couldn't connect.");
$db = @mysql_select_db($db_dbname, $connect) or die("couldn't select database.");

// set header infomation
$file_type = "vnd.ms-excel";
$file_ending = "xls";
header("content-type: application/$file_type");
header("content-disposition: attachment; filename=$db_tblname . $file_ending");
header("pragma: no-cache");
header("expires: 0");

//export data to excel
$now_date = date('y-m-d h:i');
$title = "数据库名 : $db_dbname, 数据表:$db_tblname, 备份日期: $now_date";
echo("$title\n");

$sql = "SELECT * FROM $db_tblname";
$alt_db = @mysql_select_db($db_dbname, $connect) or die("couldn't select database");
$result = @mysql_query($sql,$connect) or die(mysql_error());

$sep = "\t";
for ($i = 0; $i < mysql_num_fields($result); $i++) {
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
$i = 0;
while($row = mysql_fetch_row($result)) {
$schema_insert = "";
for($j = 0; $j < mysql_num_fields($result); $j++) {
if(!isset($row[$j]))
$schema_insert .= "null".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]" . $sep;
else
$schema_insert .= "" .$sep;
}
$schema_insert = str_replace($sep . "$", "", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
$i++;
}
return (true);
[/php]