php导出数据

    function daochu(){
          $sql = "SELECT order_id,order_sn,store_name,nickname,mobile,charge,pay_able,balance,pay_type,FROM_UNIXTIME(create_time,'%Y-%m-%d') as create_time,FROM_UNIXTIME(pay_time,'%Y-%m-%d') as pay_time,pay_status,status,free_status  from  `mxkj_v_order`";
            $sql .= "";
        $data = Db::query($sql);
        $header = array('序号','订单号','店铺名称','用户昵称','联系方式','订单金额','支付金额','抵扣余额','支付方式','下单时间','支付时间','付款状态','核销状态','免单状态');
        $filename = '订单列表'; //设置文件名
        $this->export_csv($data,$header,$filename);
    }
    function export_csv($data=array(),$title=array(),$filename='report'){
        header("Content-type:application/octet-stream");
        header("Accept-Ranges:bytes");
        header("Content-type:application/vnd.ms-excel");
        header("Content-Disposition:attachment;filename=".$filename.date("Y-m-d").".xls");
        header("Pragma: no-cache");
        header("Expires: 0");
//导出xls 开始
        if (!empty($title)){
            foreach ($title as $k => $v) {
                $title[$k]= $v;
            }
            $title= implode("\t", $title);
            echo "$title\n";
        }
        if (!empty($data)){
            foreach($data as $key=>$val){
                foreach ($val as $ck => $cv) {
                    $data[$key][$ck]= $cv;
                }
                $data[$key]=implode("\t", $data[$key]);
            }
            echo implode("\n",$data);
        }
    }