Home >Backend Development >PHP Tutorial >PHP reads CSV file data and generates CSV files
The content of this article is to share with you PHP to read CSV file data and generate CSV files. Friends in need can refer to it
Read first
function read_csv($file) { setlocale(LC_ALL,'zh_CN');//linux系统下生效 $data = null;//返回的文件数据行 if(!is_file($file)&&!file_exists($file)) { die('文件错误'); } $cvs_file = fopen($file,'r'); //开始读取csv文件数据 $i = 0;//记录cvs的行 while ($file_data = fgetcsv($cvs_file)) { $i++; if($i==1) { continue;//过滤表头 } if($file_data[0]!='') { $data[$i] = $file_data; } } fclose($cvs_file); return $data; }
Read now Write
function createcsv($csv_body) { // 头部标题 $csv_header = array('sku','我们自己的成本价','京东自己的销售价','对比结果'); /** * 开始生成 * 1. 首先将数组拆分成以逗号(注意需要英文)分割的字符串 * 2. 然后加上每行的换行符号,这里建议直接使用PHP的预定义 * 常量PHP_EOL * 3. 最后写入文件 */ // 打开文件资源,不存在则创建 $des_file = 'd:/res.csv'; $fp = fopen( $des_file,'a'); // 处理头部标题 $header = implode(',', $csv_header) . PHP_EOL; // 处理内容 $content = ''; foreach ($csv_body as $k => $v) { $content .= implode(',', $v) . PHP_EOL; } // 拼接 $csv = $header.$content; // 写入并关闭资源 fwrite($fp, $csv); fclose($fp); }
I have dealt with it in another article about reading garbled Chinese characters. Please pay attention.
Related recommendations:
How to use php to determine file extension
The above is the detailed content of PHP reads CSV file data and generates CSV files. For more information, please follow other related articles on the PHP Chinese website!