php 导出excel分段导出_PHP 导出excel 数据量大时

public functionceshiexcel1(){set_time_limit(0);$filename = '病毒日志';header('Content-Type: application/vnd.ms-excel');header('Content-Disposition: attachment;filename="'.$filename.'.csv"');header('Cache-Control: max-age=0');//原生链接mysql

//数据库配置

$mysql_conf = array('host' => '127.0.0.1:52971','db' => 'center', 'db_user' => 'root', 'db_pwd' => '');$mysql_conn = @mysql_connect($mysql_conf['host'], $mysql_conf['db_user'], $mysql_conf['db_pwd']);if (!$mysql_conn) {die("could not connect to the database:\n" . mysql_error());//诊断连接错误

}$select_db = mysql_select_db($mysql_conf['db']);if (!$select_db) {die("could not connect to the db:\n" . mysql_error());

}$sql = M('logvirus')->alias('a')->fetchsql()->field('a.id,a.strVirusName,c.address,c.rmaker,a.nVirusType,a.nunknowvirustype,a.strVirusPath,a.VirusTime,a.nunknownflag,a.terminal,d.name as rname,(case when a.iHigh_DiskType=0 then a.iLow_DiskType else a.iHigh_DiskType end) as idisktypes')//f.iDiskTypes,j.name as iname

->join('LEFT JOIN sysinfo c ON c.terminal = a.terminal')->join('LEFT JOIN pm_dealresult d ON d.mask = a.nDealResult')//->where($where)

->order("a.VirusTime desc")->limit('1,10')->select();$head = array('id'=>'编号',

'strvirusname'=>'病毒名称',

'address'=>'终端IP',

'rmaker'=>'别名',

'nname'=>'病毒类型',

'iname'=>'威胁来源',

'strviruspath'=>'病毒路径',

'rname'=>'处理结果',

'virustime'=>'时间');$stmt = mysql_query($sql);/*echo "

";

while ($row = mysql_fetch_array($stmt,MYSQL_ASSOC)) {

foreach ($row as $i => $v) {

$row[$i] = iconv('utf-8', 'gb2312', $v);

var_dump($row);

}

}

exit;*/

//打开PHP文件句柄，php://output 表示直接输出到浏览器

$fp = fopen('php://output', 'a');//输出Excel列名信息

//$head = array('id', 'casenum', 'terminal', 'strVirusMd5','nVirusType','nVirusCode','nOldVirusCode');

foreach ($head as $i => $v) {//CSV的Excel支持GBK编码，一定要转换，否则乱码

$head[$i] = iconv('utf-8', 'gb2312', $v);

}//将数据通过fputcsv写到文件句柄

fputcsv($fp, $head);//计数器

$cnt = 0;//每隔$limit行，刷新一下输出buffer，不要太大，也不要太小

$limit = 100000;//逐行取出数据，不浪费内存

$data = array();while ($row = mysql_fetch_array($stmt,MYSQL_ASSOC)) {$cnt ++;if ($limit == $cnt) { //刷新一下输出buffer，防止由于数据过多造成问题

ob_flush(); //释放

flush();$cnt = 0;

}foreach ($row as $i => $v) {//$row[$i] = iconv('utf-8', 'gb2312', $v);

$data['id'] = $cnt;$data['strvirusname'] = iconv('utf-8', 'gb2312', $row['strVirusName']);$data['address'] = iconv('utf-8', 'gb2312', $row['address']);$data['rmaker'] =iconv('utf-8', 'gb2312', $row['VirusTime']);$data['nname'] =iconv('utf-8', 'gb2312', $row['VirusTime']);$data['iname'] =iconv('utf-8', 'gb2312', $row['VirusTime']);$data['strviruspath'] =iconv('utf-8', 'gb2312', $row['VirusTime']);$data['rname'] = $row['rname'] ;$data['virustime'] =iconv('utf-8', 'gb2312', $row['VirusTime']);

}

fputcsv($fp, $data);

}//关闭数据库

mysql_close($mysql_conn);

}