PHP下载生成的csv文件及问题总结

最近做了一个项目需要把订单的信息显示出来，并且能够把相关信息放到一个.csv 文件中，下载到浏览器。虽然说csv是一种比较简单的excel表格形式，生成只要按指定格式然后生成.csv文件就可以，但是在使用中也会遇到很多问题，下面给大家分享下PHP下载csv文件及问题总结

首先大家先看个例子，生成csv文件并下载

//要生成csv文件的数组$csvArr=array();$csvArr[]=array('用户编号1','上班日期1','签到时间1','签退时间1');$csvArr[]=array('用户编号2','上班日期2','签到时间2','签退时间2')download_send_headers("data_export_" . date("Y-m-d") . ".csv");$head=array('用户编号','上班日期','签到时间','签退时间');echo array2csv($csvArr,$head);unset($csvArr);die();function array2csv(array &$array,$head){  if (count($array) == 0) {   return null;  }  ob_start();  $df = fopen("php://output", 'w');  if(!$head){    $head=array_keys(reset($array));  }  fputcsv($df,$head);  foreach ($array as $row) {   fputcsv($df, $row);  }  fclose($df);  return ob_get_clean();}function download_send_headers($filename) {  // disable caching  $now = gmdate("D, d M Y H:i:s");  header("Expires: Tue, 03 Jul 2001 06:00:00 GMT");  header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate");  header("Last-Modified: {$now} GMT");  // force download   header("Content-Type: application/force-download");  header("Content-Type: application/octet-stream");  header("Content-Type: application/download");  // disposition / encoding on response body  header("Content-Disposition: attachment;filename={$filename}");  header("Content-Transfer-Encoding: binary");}

php array生成csv文件

<?php$data = array(    array( 'row_1_col_1', 'row_1_col_2', 'row_1_col_3' ),    array( 'row_2_col_1', 'row_2_col_2', 'row_2_col_3' ),    array( 'row_3_col_1', 'row_3_col_2', 'row_3_col_3' ),  );$filename = "example";  header("Content-type: text/csv");  header("Content-Disposition: attachment; filename={$filename}.csv");  header("Pragma: no-cache");  header("Expires: 0");outputCSV($data);function outputCSV($data) {    $outputBuffer = fopen("php://output", 'w');    foreach($data as $val) {    foreach ($val as $key => $val2) {     $val[$key] = iconv('utf-8', 'gbk', $val2);// CSV的Excel支持GBK编码，一定要转换，否则乱码     }      fputcsv($outputBuffer, $val);    }    fclose($outputBuffer);  }?>

解决 fgetcsv函数在php5.2.8 中的bug

环境linux

问题解析出来的数据不完整，有为空的字段

网上查了下说是在php5.2.8 中存在bug

解决办法是使用自定义函数

function __fgetcsv(& $handle, $length = null, $d = ',', $e = '"') {   $d = preg_quote($d);   $e = preg_quote($e);   $_line = "";   $eof=false;   while ($eof != true) {     $_line .= (empty ($length) ? fgets($handle) : fgets($handle, $length));     $itemcnt = preg_match_all('/' . $e . '/', $_line, $dummy);     if ($itemcnt % 2 == 0)       $eof = true;   }   $_csv_line = preg_replace('/(?: |[ ])?$/', $d, trim($_line));   $_csv_pattern = '/(' . $e . '[^' . $e . ']*(?:' . $e . $e . '[^' . $e . ']*)*' . $e . '|[^' . $d . ']*)' . $d . '/';   preg_match_all($_csv_pattern, $_csv_line, $_csv_matches);   $_csv_data = $_csv_matches[1];   for ($_csv_i = 0; $_csv_i < count($_csv_data); $_csv_i++) {     $_csv_data[$_csv_i] = preg_replace('/^' . $e . '(.*)' . $e . '$/s', '$1' , $_csv_data[$_csv_i]);     $_csv_data[$_csv_i] = str_replace($e . $e, $e, $_csv_data[$_csv_i]);   }   return empty ($_line) ? false : $_csv_data;}