對這文章發表回應

<?php //先來做資料連線的設定：
// define database parameter
$dbHost = "192.168.OOO.XXX";  //資料庫IP
$dbUsername = "OOXX";         //資料庫連線帳號
$dbPassword = "OOXXOOXXOOXX"; //資料庫連線密碼
$dbDbName = "OOXX";           //資料庫名稱
$dbTablename = "OOOXXX";      //資料表名稱

// connection to the database
$Connect = mssql_connect($dbHost, $dbUsername, $dbPassword)
    or die("Couldn't connect to SQL Server on $dbHost");

// select a database to work with
$selected = mssql_select_db($dbDbName, $Connect)
    or die("Couldn't open database $dbDbName");
?>
<?php  //然後是輸出 Excel 最重要得 Header 部份：
// set header infomation
$file_type = "vnd.ms-excel";
$file_ending = "xls";
header("Pragma: public");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=$dbTablename.$file_ending");
header("Content-Transfer-Encoding: binary ");
header("Pragma: no-cache");
header("Expires: 0");
?>
<?php  //然後去把資料庫撈出來：
// export data to excel
$sql = 'SELECT * FROM ' . $dbTablename . ' WHERE `OOColnum` LIKE '%SearchKeyWord%' ;';  //這裡就是搜尋字串和搜尋欄位的sql語法，也就是說，你原本的搜尋資料怎麼作，這裡就是帶入一樣的sql語法就好啦！
//$ALT_Db = @mysql_select_db($dbDbName, $Connect) or die("Couldn't select database");
//$result = @mysql_query($sql,$Connect) or die(mysql_error());
$result = @mssql_query($sql,$Connect) or die(mysql_error());
?>
<?php  //設定第一行的表頭：
$sep = "\t";
$title2Write = array('產品編號' , '產品序號' , '產品類別' , '產品名稱' , '產品單位' , '產品單價' , '最低訂量' );  //因為你搜尋的資料表定義冷日完全無法預想，請自己依據你搜尋的資料表欄位填入Excel表頭
for ( $i = 0 ; $i < 7 ; $i++ ) {
	echo iconv( "UTF-8" , "big5" , $title2Write[$i] ) . "\t";
}
print("\n");
?>
<?php  //把資料開始塞到Excel 的所有欄位：
$i = 0;
while($row = mssql_fetch_row($result)) {
    $schema_insert = "";
    for( $j = 0 ; $j < mssql_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++;
}?>