php 导出execl

trdn\weixin\app\admin\lib\model\ExportData.class.php
/*导出excel数据表数据*/
public function exportExcel( $drawRecordData, $activityName ) {
$ExcelObj = new ExportData();
$array[] = array("序号","抽奖活动方案名","抽奖用户名","手机号码","是否中奖","中奖时间","中奖奖项","场外","是否兑换","openid","类型");
foreach( $drawRecordData as $key => $value ) {
$array[] = array(
$key+1,
"$activityName",
$value['user_name'],
$value['phone'],
$value['is_luck']?"是":"否",
date("Y-m-d H:i:s", $value['luck_time']),
$value['prize_name'],
$value['state']?"是":"否",
$value['is_exchange']?"已兑换":"未兑换",
$value['openid'],
$value['type']
);
}
$ExcelObj->arrayToExcel( $array, $activityName );
}
<?php
/**
* Created by PhpStorm.
* User: nick.xu
* Date: 15-3-3
* Time: 下午3:44
*/
class ExportData {
/**
* @param $array 数组数据
* @param string $fileName 文件名称
*/
public function arrayToExcel( $array, $fileName = 'to8toLoveEveryOne') {
$string = '';
if( is_array( $array ) && !empty( $array )) {
foreach( $array as $key => $value ) {
$count = count( $value );
foreach( $value as $k => $val ) {
$val = mb_convert_encoding($val, "GBK", "UTF-8");
$string .= $val.',';
if( $k == ( $count-1 ) ) {
$string = mb_substr( $string, 0 , -1)."\n";
}
}
}
}
$fileName = $fileName.".csv";
$this->export_csv( $fileName, $string );
}
function export_csv($filename,$data) {
header("Content-type:text/csv");
header("Content-Disposition:attachment;filename=".$filename);
header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
header('Expires:0');
header('Pragma:public');
echo $data;
exit;
}
}
?>