读取csv格式文件
function read_csv($file)
{
setlocale(LC_ALL,'zh_CN');
$data = null;
if(!is_file($file)&&!file_exists($file))
{
die('文件错误');
}
$cvs_file = fopen($file,'r');
$i = 0;
while ($file_data = fgetcsv($cvs_file))
{
$i++;
if($i==1)
{
continue;
}
if($file_data[0]!='')
{
$data[$i] = $file_data;
}
}
fclose($cvs_file);
return $data;
}
写入csv格式文件
function createcsv($csv_body)
{
$csv_header = array('sku','我们自己的成本价','京东自己的销售价','对比结果');
$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);
}