MYSQL到EXCEL的轉換程式

<?php// define database parameter$dbHost = "localhost";$dbUsername = "webuser";$dbPassword = "123456";$dbDbName = "pa_bbs";$dbTablename = "pw_actions";// connect database$Connect = @mysql_connect($dbHost, $dbUsername, $dbPassword) or die("Couldn't connect.");$Db = @mysql_select_db($dbDbName, $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=$dbTablename.$file_ending");header("Pragma: no-cache");header("Expires: 0");// export data to exceldate_default_timezone_set('Asia/Shanghai');$now_date = date('Y-m-d H:i:s');$title = "資料庫名dbDbName, 資料表dbTablename, 備份日期now_date";echo("$title\n");$sql = 'set names gbk;';@mysql_query($sql,$Connect);$sql = 'select * from '.$dbTablename.';';$ALT_Db = @mysql_select_db($dbDbName, $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."{1}quot;, "", $schema_insert);    $schema_insert .= "\t";    print(trim($schema_insert));    print "\n";    $i++;}return (true);?>