<?php function export_excel($items,$fields,$fields_array,$name) { /* * 调用方法示例 * $items = $this->mysql->getarr("select * from {$this->pre}user $where order by uid desc"); * $fields=array('username','money','regtime'); * $fields_array = array('username'=>'用户名','money'=>'电子币','regtime'=>'注册时间'); * export_excel($items,$fields,$fields_array,date('Y-m-d').'会员资料'); */ header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:filename=".$name.".xls"); $str = "<table border=1><tr>"; foreach ($fields as $value) { $str .= "<th>".iconv("UTF-8","GB2312",$fields_array[$value])."</th>"; } $str .= "</tr>"; foreach ($items as $item) { $str .= "<tr>"; foreach ($fields as $value) { // $val= if(strstr($value,'time')){ if(is_int($item[$value]+0)){ $item[$value]=date('Y-m-d H:i:s',$item[$value]); } } $str .= "<td>".iconv("UTF-8","GB2312",$item[$value])."</td>"; } $str .= "</tr>"; } $str .= "</table>"; $str .="<script>window.close();</script>"; echo $str; }
【推荐】还在用 ECharts 开发大屏?试试这款永久免费的开源 BI 工具!
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步