php导出execl文件

来源:互联网 发布:网络直播的现状 编辑:程序博客网 时间:2024/06/06 18:14

if($list){

$content= iconv("utf-8","gbk","时间,支持人数,筹款总额,成功筹款,失败筹款,已发放筹款,已获得佣金,已退筹款");
$content .="\n";
foreach ($list as $v){
$tmp_array=array();
$tmp_array['time']= iconv('utf-8','gbk',$v['time']);
$tmp_array['support_num']= iconv('utf-8','gbk',$v['support_num']);
$tmp_array['amount']=iconv('utf-8','gbk','"' . number_format($v['amount'],2) . '"');
$tmp_array['success_amount']=iconv('utf-8','gbk','"' . number_format($v['success_amount'],2) . '"');
$tmp_array['failed_amount']=iconv('utf-8','gbk','"' . number_format($v['failed_amount'],2) . '"');
$tmp_array['paid_money']=iconv('utf-8','gbk','"' . number_format($v['paid_money'],2) . '"');
$tmp_array['commission']=iconv('utf-8','gbk','"' . number_format($v['commission'],2) . '"');
$tmp_array['has_return_money']=iconv('utf-8','gbk','"' . number_format($v['has_return_money'],2) . '"');
$content .=implode(',', $tmp_array);
$content .="\n";
}
header("Content-Disposition: attachment; filename=project_money_total.csv");
echo $content;
}


主要语句是header("Content-Disposition: attachment; filename=project_money_total.csv");

0 0
原创粉丝点击