首页 > Web开发 > 详细

PHP 生成.csv 文件并下载到浏览器

时间:2014-07-18 11:28:54      阅读:392      评论:0      收藏:0      [点我收藏+]

最近做了一个项目需要把订单的信息显示出来,并且能够把相关信息放到一个.csv 文件中,下载到浏览器。首先我要说明的是.csv 文件,PHP 有专门的函数去解析该类型的文件,相关函数大家可以去官网查看。注意.csv 文件内容的编码格式是gbk格式的,所以有必要对字符格式进行转码。文件的样式如下。

                                                                       bubuko.com,布布扣

                一、首先要定义header 头

               // 输出Excel文件头,可把user.csv换成你要的文件名
		header ( 'Content-Type: application/vnd.ms-excel' );
		header ( 'Content-Disposition: attachment;filename="订单数据.csv"' );
		header ( 'Cache-Control: max-age=0' );
		// 打开PHP文件句柄,php://output 表示直接输出到浏览器
		$fp = fopen ( 'php://output', 'a' );
		// 输出Excel列名信息
     

              二 、下面是文件的头部

               

               $head = array ('订单号','','订单名称','','业务ID','','渠道ID','','渠道类型','','产品线名称','','原始订单号','','订单金额',
				'','From值','','订单时间','','收款合同号','','渠道名称','','付款合同号','','供应商名称','','运营平台','','产品类型',
				'','记账时间','','渠道成本比例','','渠道成本','','应收账款','','结算比例','','应付结算','','是否已回款','','是否已提批次',
				'','备注');
		foreach ( $head as $i => $v ) {
			// CSV的Excel支持GBK编码,一定要转换,否则乱码
			$head [$i] = iconv ( 'utf-8', 'gbk', $v );
		}
		// 将数据通过fputcsv写到文件句柄
		fputcsv ( $fp, $head );

  

    三、下面是文件的内容,以我的例子是从数据库读出来的,看不懂没关系,原理是把结果查出来放到数组中,循环数组,把每个结果放到一个新的数组并且进行编码。忘了告诉你我用的是CI(codeignite)框架

    

                     if ($this->input->get () != false) {
			// 从数据库中获取数据,为了节省内存,不要把数据一次性读到内存,从句柄中一行一行读即可
			$sql = "select Charge_final.charge_id,
						   Charge_final.product_name,
					       Charge_final.business_id,
						   Charge_final.channel_id,
					       Charge_final.channel_type,	
						   bass_productline.product_line_name,
						   Charge_final.business_linkid,
						   Charge_final.fee,
						   Charge_final.msgfrom, 
					       Charge_final.charge_time,
					       Charge_final.income_contract,
					       Charge_final.income_channel_name,
					       Charge_final.payment_contract,
					       Charge_final.merchant_name,
					       Charge_final.platform,
					       Charge_final.product_type,
					       Charge_final.bill_time,
					       Charge_final.channel_rate,
					       Charge_final.channel_fee,
					       (Charge_final.fee-Charge_final.channel_fee) as account,
					       Charge_final.payment_rate,
					       Charge_final.payment_fee,
					       Charge_final.income_id,
					       Charge_final.payment_id,
					       Charge_final.note
						   from {$this->Charge_final} as Charge_final left join
						   {$this->bass_productline} as bass_productline
						   on Charge_final.channel_id=bass_productline.channel_id and 
			               Charge_final.channel_type=bass_productline.channel_type
			                where 1=1 $conditions order by Charge_final.charge_time desc";
		   $query = $this->db->query ( $sql );			
			// 计数器
			$cnt = 0;
			// 每隔$limit行,刷新一下输出buffer,不要太大,也不要太小
			$limit = 8000;
			foreach ( $query->result_array () as $row ) {
				$cnt ++;
				if ($limit == $cnt) { // 刷新一下输出buffer,防止由于数据过多造成问题
					ob_flush ();
					flush ();
					$cnt = 0;
				}
				$income_id=$row['income_id']==0?'未回款':'回款';
				$payment_id=$row['payment_id']==0?'未提':'已提';
				// 读取表数据
				$content = array ();
				$content [] = iconv ( 'utf-8', 'gbk', $row ['charge_id'] . "\t" );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['product_name'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['business_id'] . "\t" );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['channel_id'] . "\t" );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['channel_type'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['product_line_name'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['business_linkid'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['fee'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['msgfrom'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['charge_time'] . "\t" );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['income_contract'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['income_channel_name'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['payment_contract'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['merchant_name'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['platform'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['product_type'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row['bill_time'].'\t');
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['channel_rate'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['channel_fee'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['account'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['payment_rate'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['payment_fee'] );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $income_id );
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $payment_id);
				$content [] = '';
				$content [] = iconv ( 'utf-8', 'gbk', $row ['note'] );
				fputcsv ( $fp, $content );
			}
            三、文件的尾部

                      $sql="select sum(Charge_final.fee) as amountorder,
			sum(Charge_final.channel_fee) as sumchannel_fee,
			sum(Charge_final.fee-Charge_final.channel_fee) as sumaccout,
			sum(Charge_final.payment_fee) as sumpayfee
			from {$this->Charge_final} as Charge_final 
			left join {$this->bass_productline} as bass_productline on 
			Charge_final.channel_id=bass_productline.channel_id and 
			Charge_final.channel_type=bass_productline.channel_type
			where 1=1 $conditions";
			$querys = $this->db->query ( $sql );
			$ro = $querys->result_array ();
			$this->data ['ro'] = $ro;
			$amountorder=$ro['0']['amountorder'];
			$sumchannel_fee=$ro['0']['sumchannel_fee'];
			$sumaccout=$ro['0']['sumaccout'];
			$sumpayfee=$ro['0']['sumpayfee'];
			 $foot = array ('统计','','','','','','','','','','','','','',"$amountorder",
				'','','','','','','','','','','','','','','','',
				'','','','','',"$sumchannel_fee",'',"$sumaccout",'','','',"$sumpayfee",'','','','',
				'','');
			  foreach ($foot as $i => $v ) {
			  	// CSV的Excel支持GBK编码,一定要转换,否则乱码
			  	$foot[$i] = iconv ( 'utf-8', 'gbk', $v );
			  }
			  // 将数据通过fputcsv写到文件句柄
			  fputcsv ( $fp, $foot);
		}
	}
}



PHP 生成.csv 文件并下载到浏览器,布布扣,bubuko.com

PHP 生成.csv 文件并下载到浏览器

原文:http://blog.csdn.net/xingjigongsi/article/details/37921859

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!