php - 在数组中显示 csv 文件

Question

我有一个 .csv 文件。有些字段是空的，有些字段有逗号或点。

现在如何在数组中像这样显示它？

Array (

 [0] => Name1,name1@yahoo.com,13,56475,,190000,,,remit,5-Mar-15,26250

 [1] => Name2,name2@yahoo.com,11,11250,,22500,,,the bank,30-Apr-15,6250

 [2] => Name3,name3@yahoo.com,15,,,1500,receipt,,the market,7-Mar-15,1750

 [3] =>Name4,name4@yahoo.com,21,25500,,46750,receipt,,bank ,7-Mar-15,21350 ..... )

目前我只能这样显示:

Array (

 [0] => Name1
 [1] => name1@yahoo.com
 [2] => 13
 [3] => 56475
 [4] => 
 [5] => 19000
 [6] => 
 [7] => 
 [8] => remit
 [9] => 5-Mar-15
 [10] => 26250 ) 


Array (
 [0] => Name2
 [1] => name2@yahoo.com
 [2] => 11
 [3] => 11250
 [4] => 
 [5] => 22500
 [6] => 
 [7] => 
 [8] => the bank
 [9] => 30-Apr-15
 [10] => 6250 ) ....

我正在使用这段代码:

$file = fopen("pay.csv","r");
while(! feof($file))
{
 echo '<pre>',print_r(fgetcsv($file)),'</pre>';
}
fclose($file);

我更喜欢使用原生 csv 函数。

Answer 1

如果这是您在顶部的预期输出，您可以简单地使用 file() 方法将文件解析为数组。

$lines = file('file.csv');

foreach ($lines as $line_num => $line) {
 echo $line . '<br />';
}