20,359
社区成员
发帖
与我相关
我的任务
分享
/**
* 导出excel
* @param [type] $data 数据库查询列表,
* @param [type] $fields 要导出的字段,数组格式入array('name','phone')
* @return [type] [description]
*/
public static function exportXls($data,$fields){
ob_clean();
header('Content-type:application/vnd.ms-excel;');
header('Content-Disposition:attachment;filename=' . date('YmdHis') . '.xls');
$title = array_values($fields);
foreach($title as $t){
echo iconv('UTF-8', 'GB2312', $t) . "\t";
}
echo "\n";
foreach ($data as $d){
$item = array();
foreach($fields as $f=>$v){
$item[] = iconv('UTF-8', 'GB2312', $d[$f]);
}
echo implode("\t",$item)."\n";
sleep(0);
}
unset($data,$item,$fields);
exit;
}