Skip to content

Instantly share code, notes, and snippets.

@sgsheg
Created August 13, 2021 06:55
Show Gist options
  • Save sgsheg/6bf005602fef9a68f78fff5fa567a2e6 to your computer and use it in GitHub Desktop.
Save sgsheg/6bf005602fef9a68f78fff5fa567a2e6 to your computer and use it in GitHub Desktop.
php导出csv
public function put_csv($list,$title){
$file_name="CSV".date("mdHis",time()).".csv";
header ( 'Content-Type: application/vnd.ms-excel' );
header ( 'Content-Disposition: attachment;filename='.$file_name );
header ( 'Cache-Control: max-age=0' );
$file = fopen('php://output',"a");
$limit=1000;
$calc=0;
foreach ($title as $v){
$tit[]=iconv('UTF-8', 'GB2312//IGNORE',$v);
}
fputcsv($file,$tit);
foreach ($list as $v){
$calc++;
//等于1000时刷新缓存
if($limit==$calc){
ob_flush();
flush();
$calc=0;
}
//根据头部内容顺序插入
foreach ($title as $key => $value) {
$tarr[]=iconv('UTF-8', 'GB2312//IGNORE',$v[$key]);
}
fputcsv($file,$tarr);
unset($tarr);
}
unset($list);
fclose($file);
exit();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment