PHP 大数据量写入 csv文件 的一些代码片段

private function write($bid = 0){    set_time_limit(0);    // 输出Excel文件头     header('Content-Type: application/vnd.ms-excel;charset=gbk');    header('Content-Disposition: attachment;filename="产品导出.csv"');    header('Cache-Control: max-age=0');    // PHP文件句柄，php://output 表示直接输出到浏览器     $fp = fopen('php://output', 'a');    // 输出Excel列头信息     $head = array(        0 => '标题',        1 => '连接'    );        foreach ($head as $i => $v) {        // CSV的Excel支持GBK编码，一定要转换，否则乱码         $head[$i] = iconv('utf-8', 'gbk', $v);    }    // 写入列头     fputcsv($fp, $head);    $row = array();    $row['serial'] = "标题";    $row['wserial'] = '连接';    fputcsv($fp, $row);}

另外一些

<?php    /**     * 导出推送消息详情     * @author Jiaxu<[e-mail]>      * @date   2015-01-19     */ function orderlist_execl2(){    $order = M("order","t_","51yche");        $user = M("user","t_","51yche");        if($_GET['date'] != NULL){            $condition['_string'] = ' a.order_add_timestamp > "'.$_GET['date'].' 00:00:00" AND a.order_add_timestamp<"'.$_GET['date'].' 23:59:59" and d.route_type=1';        }else{$condition['_string'] = ' a.order_add_timestamp > "'.date("Y-m-d",time()).' 00:00:00" AND a.order_add_timestamp<"'.date("Y-m-d",time()).' 23:59:59"';}$count = $order->table('t_order as a')->join('LEFT JOIN t_order_push as e ON a.order_id=e.fk_order_id')->join('LEFT JOIN t_user as b ON e.fk_user_id=b.user_id')->join('LEFT JOIN t_user as c ON a.fk_user_id=c.user_id')->join('LEFT JOIN t_route as d ON e.fk_user_id=d.fk_user_id')->join('LEFT JOIN t_driver as f ON e.fk_user_id=f.fk_user_id')->where($condition)->count();set_time_limit(0); $page_start = 0;$base_num = 10000;$limt = ceil($count/$base_num);if($count<$p_num){$p_num = $count;if($count<$base_num){$limt = 1;}else{$limt = ceil($count/$base_num);}}$title = array('请求ID','发布时间','乘客ID','乘客昵称','出发时间','起点名称','终点名称','起点坐标','终点坐标','车型选择','订单价格','车主ID','车主昵称','车主类型','车型','线路ID','车主线路出发时间','车主起点','车主终点','起点坐标','终点坐标','详情展示时间','抢单时间','订单状态','达成订单id','付款时间','完成时间','取消时间','操作人','取消原因','客服的备注');        foreach ($title as $k => $v) {            $title[$k]=iconv("UTF-8", "gbk",$v);        }        $title= implode("\t", $title);        $str = "$title\n";$file_dir = C('DLOG_DIR');$excel_file = $file_dir."order_push_list-".$_GET['date'].".xls";$fp = fopen($excel_file, 'w');for($i=1;$i<=$limt;$i++){$Push = array();$Push = $order->table('t_order as a')->join('LEFT JOIN t_order_push as e ON a.order_id=e.fk_order_id')                        ->join('LEFT JOIN t_user as b ON e.fk_user_id=b.user_id')                        ->join('LEFT JOIN t_user as c ON a.fk_user_id=c.user_id')->join('LEFT JOIN t_route as d ON e.fk_user_id=d.fk_user_id')->join('LEFT JOIN t_driver as f ON e.fk_user_id=f.fk_user_id')                        ->where($condition)->limit($page_start.','.$base_num)                        ->field('e.fk_user_id as push_driver_id,a.order_id,a.order_add_timestamp,a.order_start_timestamp,a.order_distance,a.order_start,a.order_end,a.order_start_lng,a.order_start_lat,a.order_end_lng,a.order_end_lat,a.order_car_type,a.order_amt,b.user_nick,b.user_rank,c.user_nick as passenger_user_nick,d.route_id,d.route_type,d.route_start_time,d.route_start,d.route_end,d.route_start_lat,d.route_start_lng,d.route_end_lat,d.route_end_lng,f.driver_car_type')->order('e.order_push_time desc')                        ->select();foreach ($Push as $key => $value) {if($Push[$key]['driver_user_id']!=0){$Push[$key]['order_driver_get_time']=$this->getOrderTime($value['order_id']);}else{$Push[$key]['order_driver_get_time']='';}if($this->getPayTime($value['order_id'])){$Push[$key]['order_pay_time']=$this->getPayTime($value['order_id']);}else{$Push[$key]['order_pay_time']='';}if($this->getFinishTime($value['order_id'])){$Push[$key]['order_finish_time']=$this->getFinishTime($value['order_id']);}else{$Push[$key]['order_finish_time']='';}if($this->getCancelTime($value['order_id'],$value['order_status'])){$Push[$key]['order_cancel_time']=$this->getCancelTime($value['order_id'],$value['order_status']);}else{$Push[$key]['order_cancel_time']='';}}$arr = array(); foreach ($Push as $key => $value) {$arr[$key]['order_id'] = $value['order_id'];$arr[$key]['order_add_timestamp'] = $value['order_add_timestamp'];$arr[$key]['fk_user_id'] = $value['fk_user_id'];$arr[$key]['passenger_user_nick']=$value['passenger_user_nick'];$arr[$key]['order_start_timestamp'] = $value['order_start_timestamp'];$arr[$key]['order_start'] = $value['order_start'];$arr[$key]['order_end'] = $value['order_end'];$arr[$key]['order_start_coordinate'] ="({$value['order_start_lng']}".","."{$value['order_start_lat']})";$arr[$key]['order_end_coordinate'] ="({$value['order_end_lng']}".","."{$value['order_end_lat']})";$arr[$key]['order_car_type'] = $this->getCartype($value['order_car_type']); $arr[$key]['order_amt'] = $value['order_amt'];$arr[$key]['push_driver_id'] = $value['push_driver_id'];$arr[$key]['user_nick'] = $value['user_nick'];if($value['user_rank']==1){$arr[$key]['driver_type']='普通车主';}elseif($value['user_rank']==2){$arr[$key]['driver_type']='核心车主';}else{$arr[$key]['driver_type']='租赁车主';}if($value['driver_car_type']==1){$arr[$key]['driver_car_type']='经济型';}elseif($value['driver_car_type']==2){$arr[$key]['driver_car_type']='舒适型';}else{$arr[$key]['driver_car_type']='豪华型';}$arr[$key]['route_id'] = $value['route_id'];$arr[$key]['route_start_time'] = $value['route_start_time'];$arr[$key]['route_start'] = $value['route_start'];$arr[$key]['route_end'] = $value['route_end'];$arr[$key]['route_start_coordinate'] ="({$value['route_start_lng']}".","."{$value['route_start_lat']})";$arr[$key]['route_end_coordinate'] ="({$value['route_end_lng']}".","."{$value['route_end_lat']})";$arr[$key]['order_driver_first_time']='0000-00-00 00:00:00';$arr[$key]['order_driver_get_time']=$value['order_driver_get_time'];$arr[$key]['order_status'] = $this->getStatusDesc($value['order_status']);if($value['driver_user_id']!=0){$arr[$key]['order_get_id']=$value['order_id'];}else{$arr[$key]['order_get_id']='';}$arr[$key]['order_pay_time']=$value['order_pay_time'];$arr[$key]['order_finish_time']=$value['order_finish_time'];$arr[$key]['order_cancel_time']=$value['order_cancel_time'];                 $arr[$key]['fk_mis_nickname']=$value['fk_mis_nickname'];                $arr[$key]['order_cancel_reason']=$value['order_cancel_reason'];                $arr[$key]['order_cancel_content']=$value['order_cancel_content']; }foreach($arr as $key=>$val){foreach ($val as $ck => $cv) {$arr[$key][$ck]=iconv("UTF-8", "gbk", $cv);}$arr[$key]=implode("\t", $arr[$key]);}fwrite($fp,implode("\n",$arr));fwrite($fp,"\n");unset($Push);unset($arr);$page_start = $page_start+$base_num;}fclose($fp);echo "<a href='/log/order_push_list-".$_GET['date'].".xls'>/log/order_push_list-".$_GET['date']."xls</a>";}?>