$filename="票务管理模拟数据.xls";//先定义一个excel文件
header("Content-Type: application/vnd.ms-execl");
header("Content-Type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=$filename");
header("Pragma: no-cache");
header("Expires: 0");

$db = Db('analog_data')->where('id',$data)->find();
$excel = Db('analog_data')->where(['card_type'=>$db['card_type'],'device_type'=>$db['device_type']])->select();
//我们先在excel输出表头，当然这不是必须的

echo iconv("utf-8", "gb2312", "ID")."\t";
echo iconv("utf-8", "gb2312", "设备编号")."\t";
echo iconv("utf-8", "gb2312", "流水号")."\t";
echo iconv("utf-8", "gb2312", "购买时间")."\t";
echo iconv("utf-8", "gb2312", "操作人")."\n";//注意这个要换行

foreach ($excel as $row){
    echo iconv("utf-8", "gb2312", $row['id'])."\t";
    echo iconv("utf-8", "gb2312", $row['alias'])."\t";
    echo iconv("utf-8", "gb2312", $row['serial_number'])."\t";
    echo iconv("utf-8", "gb2312", $row['time'])."\t";
    echo iconv("utf-8", "gb2312", $row['opuser'])."\n";

}

评论