<?php
header("Content-type: text/html; charset=utf-8");
$list=[
['user'=>'小明','money'=>120,"sex"=>"男"],
['user'=>'小红','money'=>0,"sex"=>"女"],
['user'=>'小张','money'=>60,"sex"=>"男"],
['user'=>'小花','money'=>310,"sex"=>"女"],
];
$str = "用户\t银行卡余额\t性别\t\n";
$sum_money=0;
//导出银行卡余额大于0的用户
foreach ($list as $k => $v) {
if($v['money']!=0)
{
$str.= $v['user']."\t".$v['money']."\t".$v['sex']."\t\n";
$sum_money += $v['money'];
$str .= "共有".$sum_money."元人民币";//统计总共多少钱
}
}
$time = date('Y-m-d',time());
$filename = "$time-详细数据.xls";
exportExcel( $filename,$str);
function exportExcel($filename,$content){
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate,post-check=0,pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");
header("Content-Disposition: attachment; filename=".$filename);
header("Content-Transfer-Encoding:binary");
echo $content;
}
效果: