使用php逐行解析csv文件

发布于 2024-12-19 02:47:59 字数 1913 浏览 0 评论 0原文

我有一个包含数据的 csv 文件第 1 行是这样的标题

 id fname lname email date code pid

，每行然后在每个字段名称下方都有数据

3232456454  mike    strong  [email protected]   11/8/11 0:00    AU  2540

，当我使用文本编辑器看到此 csv 时，我看到它如下。

3232456454,mike,strong,[email protected],11/8/11 0:00,AU,2540
87876548788,bob,cool,[email protected],11/8/11 0:00,RY,2148
23498765,nike,tick,[email protected],11/8/11 0:00,TE,5240

现在我想使用 php 读取文件，并且希望数据的格式与文本文件完全相同。我将按原样将这些数据用于其他目的。我不想用逗号分隔，所以我不能使用 fgetcsv。我尝试使用 php file() 打开它，但是当我循环它时，我没有看到正确的数据。有人可以提出一些建议吗？

如果我这样做，它会在数组中打印，每个元素取一个值，我不想要这个。

    $csv = array();
    $lines = file('sample.csv', FILE_IGNORE_NEW_LINES);

    foreach ($lines as $key => $value)
    {
        $csv[$key] = str_getcsv($value);
    } 
print_r($csv)

我尝试使用谷歌代码中的 parsecsv 库，但这并不是真正必要的，因为我想要逐行数据。

我需要忽略输出中的第一行（标题）。

如果我能得到这样的输出，这将解决我的

Array
(
    [id,fname,lname,email,,data,code,pid] => 3232456454,mike,strong,[email protected],11/8/11 0:00,AU,2540
)

Array
(
    [id,fname,lname,email,,data,code,pid] => 87876548788,bob,cool,[email protected],11/8/11 0:00,RY,2148
)

问题

原文

I have a csv file with data
row 1 is header like this

 id fname lname email date code pid

each row then has data below each field name

3232456454  mike    strong  [email protected]   11/8/11 0:00    AU  2540

and when i see this csv using text editor, i see it as below.

3232456454,mike,strong,[email protected],11/8/11 0:00,AU,2540
87876548788,bob,cool,[email protected],11/8/11 0:00,RY,2148
23498765,nike,tick,[email protected],11/8/11 0:00,TE,5240

Now i want to read the file using php and i want the data to be exactly same format as text file. I will use this data for other purpose as it is. I don't want to split at commas so i cannot use fgetcsv. I tried by just opening it using php file() but when i loop it, i don't see the proper data. Can some one please throw some suggestions?

if I do this way, it prints in the array with each element taking one value and I don't want this..

    $csv = array();
    $lines = file('sample.csv', FILE_IGNORE_NEW_LINES);

    foreach ($lines as $key => $value)
    {
        $csv[$key] = str_getcsv($value);
    } 
print_r($csv)

I tried using parsecsv library from google code but this is not really necessary as i want the data line by line.

I need to ignore the first line(header) in the output.

If i can get the output like this, this will solve my issues

Array
(
    [id,fname,lname,email,,data,code,pid] => 3232456454,mike,strong,[email protected],11/8/11 0:00,AU,2540
)

Array
(
    [id,fname,lname,email,,data,code,pid] => 87876548788,bob,cool,[email protected],11/8/11 0:00,RY,2148
)

regards

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

找回味觉 2024-12-26 02:47:59

$csv = file_get_contents($file);

这将按原样获取文件，无需任何转换或拆分或任何其他操作，只需一个长字符串。

如果您想将其拆分为每行的数组，只需执行

$csv = file($file, FILE_IGNORE_NEW_LINES);

此操作即可。没有循环，没有 getcsv，只有 file()。

但即使您说您对解析 CSV 不感兴趣，您实际上正在处理 CSV，因此我会尽快解析它并再次输出，甚至在必要时返回 CSV。

$fh = fopen($file, 'r');
$header = fgetcsv($fh);

$data = array();
while ($line = fgetcsv($fh)) {
    $data[] = array_combine($header, $line);
}

fclose($fh);

print_r($data);


// outputting:

$out = fopen('php://output', 'w');
fputcsv($out, array_keys($data[0])); // skip this if you don't want headers
foreach ($data as $line) {
    fputcsv($out, $line);
}
fclose($out);

如果无法正确识别行结尾，请在脚本顶部尝试 ini_set('auto_detect_line_endings', true); 。

请参阅此处的演示：http://codepad.viper-7.com/t31IEv

$csv = file_get_contents($file);

This will get the file as is without any conversions or splitting or anything, just one long string.

If you want to split it into an array for each line, simply do

$csv = file($file, FILE_IGNORE_NEW_LINES);

and nothing else. No looping, no getcsv, just file().

But even if you say you're not interested in parsing the CSV, you are dealing with a CSV so I'd parse it as soon as possible and output it again, even back to CSV if necessary.

$fh = fopen($file, 'r');
$header = fgetcsv($fh);

$data = array();
while ($line = fgetcsv($fh)) {
    $data[] = array_combine($header, $line);
}

fclose($fh);

print_r($data);


// outputting:

$out = fopen('php://output', 'w');
fputcsv($out, array_keys($data[0])); // skip this if you don't want headers
foreach ($data as $line) {
    fputcsv($out, $line);
}
fclose($out);

If line endings aren't properly recognized, try ini_set('auto_detect_line_endings', true); on top of your script.

See here for a demo: http://codepad.viper-7.com/t31IEv

回复收藏 0 原文

余生再见 2024-12-26 02:47:59

使用 fopen 和 fgets 代替，并使用您所在行的计数器，这样您就可以忽略第一行：

$c=0;
$data=fopen($file,'r');
while($row=fgets($data)){
    //$row is your line as a string
    if($c!=0){
    //do something with it
    echo $row."\n";
   }
   $c++;
}

Use fopen and fgets instead, and use a counter of which line you're at so you can ignore the first:

$c=0;
$data=fopen($file,'r');
while($row=fgets($data)){
    //$row is your line as a string
    if($c!=0){
    //do something with it
    echo $row."\n";
   }
   $c++;
}

回复收藏 0 原文