用php将数据库中数据导出成excel表格

 <?php   
$DB_Server ="localhost";     
$DB_Username ="root";     
$DB_Password ="";     
$DB_DBName ="test";     
$DB_TBLName ="oi_mall_payment";     
    
$savename = date("YmjHis");  
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)or die("Couldn'tconnect.");     
mysql_query("Set Names 'gbk'");  
$file_type ="vnd.ms-excel";     
$file_ending = "xls";  
header("Content-Type:application/$file_type;charset=big5");  
header("Content-Disposition: attachment;filename=".$savename.".$file_ending");     
//header("Pragma:no-cache");        
    
$now_date = date("Y-m-jH:i:s");      
$title ="数据库名:$DB_DBName,数据表:$DB_TBLName,备份日期:$now_date";      
    
$sql = "Select * from$DB_TBLName";      
$ALT_Db = @mysql_select_db($DB_DBName, $Connect) or die("Couldn'tselectdatabase");     
$result = @mysql_query($sql,$Connect) ordie(mysql_error());   
    
echo("$title\n");      
$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);   
?>