function test() {
$fileName = 'demo';
// 幾個(gè)header函數(shù)需要放fopen之前捞高。不然會(huì)直接在瀏覽器頁面打印輸出绿淋。而不是文件下載
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="'.$fileName.'.csv"');
header('Cache-Control: max-age=0');
//直接輸出到瀏覽器
$fp = fopen('php://output', 'a');
//在寫入的第一個(gè)字符串開頭加 bom预侯。
$bom = chr(0xEF).chr(0xBB).chr(0xBF);
$column = [
$bom.'姓名','性別', '年齡'
];
$data = [
'張三','男士', '21'
];
fputcsv($fp, $column);
fputcsv($fp, $data);
fclose($fp);
}
參考鏈接:https://blog.csdn.net/xiojing825/article/details/78794289
(僅收錄,未親測(cè))