用php将mysql数据表转换为excel文件格式

<?php
// define database parameter

$DB_Server="localhost";
$DB_Username="root";
$DB_Password="123";
$DB_DBName="windlike";
$DB_TBLName="bank";

// connect database

$Connect=@mysql_connect($DB_Server,$DB_Username,$DB_Password)ordie("Couldn't connect.");
$Db=@mysql_select_db($DB_DBName,$Connect)ordie("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)ordie("Couldn't select database");
$result=@mysql_query($sql,$Connect)ordie(mysql_error());

$sep="\t";
for($i=0;$i<mysql_num_fields($result);$i++){
    echomysql_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);
?>