php输出数据到csv文件

 function export()
{
	$fileName = date('Y-m-d').uniqid().'.csv';
	set_time_limit(0);
	ini_set('memory_limit', '1024M');
	// 设置header信息
	header('Content-Type: application/octet-stream');
	header('Content-Disposition: attachment; filename=' . $fileName);


	// 设置标题
	$title = ["列名1", "列名1","列名1", "列名1"];

	echo iconv('utf-8', 'gbk//TRANSLIT', '"' . implode('","', $title) . '"' . "\n");

	
	$sql = "select xxx";
	$result = $this->db_w->fetch($sql);


	foreach($result as $k=>$v){
		if($k/500 == 0){
			ob_flush();
			flush();
		}

		$str_arr = array();
		
		$str_arr[] = $v['aaa'];
		$str_arr[] = $v['bbb'];

		$str_arr[] = $v['ccc'] 
		$str_arr[] = $v['ddd'] 


		


		echo iconv('utf-8', 'gbk//TRANSLIT', '"' . implode('","', $str_arr) . '"' . "\n");


	}
	exit;




}

  

posted on 2016-10-28 11:44  pa200318  阅读(436)  评论(0编辑  收藏  举报

导航