php将mysql数据以excel形式导出

<?php
  
   $DB_Server = "192.168.1.1";     
   $DB_Username = "root";     
   $DB_Password = "root";     
   $DB_DBName = "testDB";     
   $DB_TBLName = "uchome_mailboxmanage_import_sendlog";         
   $savename = date("Y-m-j H:i:s");  
   $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect.");     
   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-j H:i:s");      
        //$title = "数据库名:$DB_DBName,数据表:$DB_TBLName,备份日期:$now_date"; 
    $title = "数据表:$DB_TBLName,备份日期:$now_date";
        $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());   
            
        echo("$title\n");      
        $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;      
                else if ($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);   
?>