<?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;
}