PHP—SQL下载为EXCEL文件

<?php
/*
 * Created on 2011-7-13
 * long.tang
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
?>
<?php require_once('conn.php');
	   require_once('checklogin.php');
		require_once('function.php');


//用php将mysql中的数据导出到.csv文件

function saveFileInCsvFormat($fileName, $data){
    // 判断文件是否存在，不存在就创建文件，存在就返回false

    if (!file_exists($fileName)){

        $file = fopen($fileName,'x');

    }else {

        return false;

    }
    // 将数据写入 csv 文件内容

    foreach ($data as $val){

        fputcsv($file, $val);

    }
    // 保存文件

    @fclose($file);

    return true;

}
function downFile($sFilePath)
{
   if(file_exists($sFilePath)){
	   echo "<script language=javascript>window.location='$sFilePath';</script>";
   }
   else
   {
       echo("文件不存在!");
   }
}


if(isset(GET["tactic_id"])){
	$tactic_i_maillist = "tactic_".GET["code"]."_click";
	$sql_data = "select t.mclick_time,l.tactic_link_id,l.mlink_address from mail_click t,mail_link l where t.mlink_id=l.tactic_link_id and t.tactic_id=l.tactic_id and t.data_id=".GET["code"]." and t.tactic_id=".GET["tactic_id"];
	$fileName = 'down/'.$tactic_i_maillist."_".date('YmdHis').'.csv';
}


//echo "$sql_data";
$result_data = @db_query($sql_data, $conn_com, $data_type_com, $error_com);

$fields = @db_num_fields($result_data, $data_type_com);
$j = 0;
$k = 0;
for ($i=0; $i < $fields; $i++) {

	$field_name = @db_field_name($result_data,$i,$data_type_com);
	$data[$j][$i] = $field_name;
}
while ($row_data = @db_fetch_assoc($result_data, $data_type_com)){
		$j++;
		$data[$j] = $row_data;
}

saveFileInCsvFormat($fileName,$data);
//echo $fileName;




//文件下载函数
if(isset($fileName)){
   downFile($fileName);
}
else
{
   echo("请输入文件路径!");
}

?>