php 导出.csv文件示例

<?php
set_time_limit(0);
ini_set('memory_limit', '256M');
$fileName = "nameList.csv";//文件名称
header('Content-Description: File Transfer');
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="' . $fileName . '"');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
//打开php数据输入缓冲区
$fp = fopen('php://output', 'a');
$list=[
  ['name'=>'张三','sex'=>'F','age'=>18] ,
  ['name'=>'张小小','sex'=>'F','age'=>20],
  ['name'=>'一一','sex'=>'M','age'=>20],
  ['name'=>'一生','sex'=>'M','age'=>99],
  ['name'=>'一诺','sex'=>'U','age'=>99],
];
$heade = ['name', 'sex','age'];
//将数据编码转换成GBK格式
// mb_convert_variables('GBK', 'UTF-8', $heade);
//将数据格式化为CSV格式并写入到output流中
fputcsv($fp, $heade);
foreach ($list as $key => $fnav) {
    $row =[
        "{$fnav['name']}",
        "{$fnav['sex']}",
        "{$fnav['age']}"
    ];
    //将数据编码转换成GBK格式
    // mb_convert_variables('GBK', 'UTF-8', $row);
    fputcsv($fp, $row);
    //将已经存储到csv中的变量数据销毁，释放内存
    unset($row);
}
fclose($fp);
die;