$arr_data=$data->toArray();
if (empty($arr_data)){
return back();
}
foreach($arr_data as $k=>$v){
$new_arr[$k]=$v;
}
// print_r($new_arr);die;
// 输出Excel文件头,可把user.csv换成你要的文件名
$filename='用户微信提现流水'.date('Y-m-d H时i分s秒',time());
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="'.$filename.'.csv"');
header('Cache-Control: max-age=0');
// 打开PHP文件句柄,php://output 表示直接输出到浏览器
$fp = fopen('php://output', 'a');
// 输出Excel列名信息
$head = array('会员名','注册手机','金额','提现时间','状态');
foreach ($head as $i => $v) {
// CSV的Excel支持GBK编码,一定要转换,否则乱码
$head[$i] = iconv('utf-8', 'gbk',$v);
}
// 将数据通过fputcsv写到文件句柄
fputcsv($fp, $head);
$total_amount=0;
foreach ($new_arr as $key => $val) {
$total_amount+=$val['amount'];
foreach($val as $k=>$v){
if($k=='amount'){
$new[$k] = iconv('utf-8', 'gbk//IGNORE',$v);
}else{
$new[$k] = iconv('utf-8', 'gbk//IGNORE', strval($v)."\t");
}
}
fputcsv($fp, $new);
}
$null=array('','','','','','','','');
//统计信息
fputcsv($fp,$null);
fputcsv($fp,$null);
fputcsv($fp, array(iconv('utf-8', 'gbk', '总金额: '.$total_amount)));
简单的
$csv_header = array('班级','学号','姓名'); $csv_content =chr(0xEF).chr(0xBB).chr(0xBF);//注意要加这三个字符 $csv_content .= join(',',$csv_header) ."\n"; $csv_content .= "一班," . '="001"' . ",张三\n";//注意数字字符串保留首位0的处理 $csv_content .= "一班," . '="002"' . ",李四\n"; header("Content-type:text/csv;charset=gb2312"); //设置header file_put_contents('班级表.csv', $csv_content);