/**
* 导出CSV数据
* $filename 文件名称
* $titleArr 标题,一维数组
* $dataArr 字段值,二维数组
*/
function export_to_csv($filename, $titleArr, $dataArr){
ini_set('memory_limit','1024M');
ini_set('max_execution_time',0);
ob_end_clean();
ob_start();
header("Content-Type: text/csv;charset=utf-8");
header("Content-Disposition:filename=".$filename);
$fp=fopen('php://output','w');
fwrite($fp, chr(0xEF).chr(0xBB).chr(0xBF));
fputcsv($fp,$titleArr);
$index = 0;
foreach ($dataArr as $item) {
if($index==1000){
$index=0;
ob_flush();
flush();
}
$index++;
fputcsv($fp,$item);
}
ob_flush();
flush();
ob_end_clean();
}
$titleArr=array(
'学员姓名',
'手机号'
);
$dataArr=array(
array('student_name'=>'张三','mobile'=>'13677778888'),
array('student_name'=>'李四','mobile'=>'13688889999')
);
export_to_csv('学员信息'.date('Ymd').'.csv',$titleArr,$dataArr);