导出

最新推荐文章于 2025-09-09 18:53:59 发布

weixin_33853794

最新推荐文章于 2025-09-09 18:53:59 发布

阅读量78

点赞数

CC 4.0 BY-SA版权

文章标签： php

原文链接：http://www.cnblogs.com/sbfnxk201/p/6628454.html

<?php
/**
 */
defined('IN_IA') or exit('Access Denied');
global $_W, $_GPC;
include_once MODULE_ROOT.'/PHPExcel/Classes/excel_func.php';
$data = array();
$page = 1;
$limit = 500;
$condition = " weid=".$this->weid;
 while (true) {
    $offset = ($page - 1) * $limit;
    //查出数据
    $sql = "SELECT * FROM " . tablename('taishan_rencai_zhuo_person') . " WHERE $condition order by id desc limit ".$offset.','.$limit;
    $tempdata = pdo_fetchall($sql);
    
    if (empty($tempdata)) {
        break;
    }
    $data = array_merge($data,$tempdata);
    
    $page++;
}

//要输出的数组
$sc = array();
foreach ($data as $item) {
    $c = count($sc);
    $sc[$c]['id'] = $item['id'];
    // 企业名称
    $sql = "SELECT * FROM ".tablename('taishan_rencai_company')." WHERE id=:id";
    $com = pdo_fetch($sql,array(':id'=>$item['company_id']));
    $sc[$c]['company_name'] = $com['name'];
    $sc[$c]['zhuo_id'] = $item['zhuo_id'];
    $sc[$c]['name'] = $item['name'];
    $sc[$c]['tel'] = $item['tel'];
    $sc[$c]['zhiwei'] = $item['zhiwei'];

}
toexcel($sc,'参会导出',array('id','公司名称','桌号','姓名','电话','职位'));

转载于:https://www.cnblogs.com/sbfnxk201/p/6628454.html