php匯出csv檔案函數(增強版)

/** * 輸出CSV的頭資訊 * 註：使用此函數前後都不應有任何資料輸出 * @param $data Array 下載的資料 * @param $file_name String 下載的檔案名稱 * @edit: bbs.it-home.org */ function outputCsvHeader($data,$file_name = 'export') { header('Content-Type: text/csv'); $str = mb_convert_encoding($file_name, 'gbk', 'utf-8'); header('Content-Disposition: attachment;filename="' .$str . '.csv"'); header('Cache-Control:must-revalidate,post-check=0,pre-check=0'); header('Expires:0'); header('Pragma:public'); $csv_data = ''; foreach ($data as $line) { foreach ($line as $key => &$item) { $item = str_replace (',','，',str_replace(PHP_EOL,'',$item)); //過濾產生csv檔案中的(,)逗號和換行 $item = mb_convert_encoding($item, 'gbk', 'utf-8'); } $csv_data .= implode(',', $line) . PHP_EOL; } echo $csv_data; } //php匯出csv檔案樣本 outputCsvHeader($data,"myfile.csv"); 複製代碼

