PHP Export EXECL

<?phpfunction export_excel ($items, $fields, $fields _array, $name) {/** Call Method Example * $items = $this->mysql->getarr ("select * from {$this->pre}user $where ORDER BY uid DESC"      );      * $fields =array (' username ', ' money ', ' regtime ');      * $fields _array = array (' username ' = ' username ', ' money ' = ' e-coin ', ' regtime ' = ' registration time '); * Export_excel ($items, $fields, $fields _array,date (' y-m-d '). '      Member Information '); */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;}

PHP Export EXECL