function getexcel($list){
$html = "\xEF\xBB\xBF";
$title = array('企业名称','用户名','手机号','注册时间','最后登录时间'); // execl 表格第一栏标题
foreach($title as $k=>$v){
$html .= $v."\t,";
}
$html .= "\n";
foreach($list as $k=>$v){
$html .= $v['firmName']."\t,";
$html .= $v['username']."\t,";
$html .= $v['mp']."\t,";
$html .= date('Y-m-d H:i:s',$v['createtime'])."\t,";
$html .= date('Y-m-d H:i:s',$v['lasttime'])."\t,";
$html .= "\n";
}
header("Content-type:application/vnd.ms-excel;charset=UTF-8");
header("Content-Disposition:attachment; filename=" . urlencode("用户数据.csv"));
echo $html;
}
php导出excel
最新推荐文章于 2021-05-17 12:40:18 发布