PHP read CSV file line by lines

Question

I have a CSV file loaded from an URL, and I want to loop over the lines with PHP.

Here is a typical line of this CSV:

1004000018;active;"TEST1";"TEST2";"TEST3";"TEST4"

I would like to get this result, for each row:

1004000018
active
TEST1
TEST2
TEST3
TEST4

So look at using the fgetcsv() function with a ; separator — Mark Baker
– Mark Baker, Commented May 21, 2016 at 10:44

MichalVales · Accepted Answer · 2018-10-28 07:19:37Z

76

You can achieve this using the php function fgetcsv, this should work :

PHP

$file = fopen('file.csv', 'r');
while (($line = fgetcsv($file)) !== FALSE) {
   //$line[0] = '1004000018' in first iteration
   print_r($line);
}
fclose($file);

edited Oct 28, 2018 at 7:19

MichalVales

4554 silver badges11 bronze badges

answered May 21, 2016 at 10:41

Sofiene Djebali

4,5481 gold badge24 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Mark Baker Over a year ago

Why don't you use fgetcsv() instead of explode().... one less operation, a function designed specifically to handle the other subtle nuances of CSV (such as quoted strings, and the separator appearing inside an actual value)

Sofiene Djebali Over a year ago

@chouaib23 i edited the post using fgetcsv, now you can access the variable $line as an array, for instance : $line[0] in the first iteration will be equal to $line[0] = '1004000018';

chouaib23 Over a year ago

Thanks Problem Solved

Goran Jakovljevic Over a year ago

In order to get an array, you need delimiter of ";" passed to the fgetcsv, in the example above.

Pankaj Over a year ago

Does this line $file = fopen('file.csv', 'r'); load the entire file into memory?

|

Surendra Suthar · Accepted Answer · 2016-05-21 11:20:58Z

2

This will help you for read csv:

   if (($handle = fopen("$source_file", "r")) !== FALSE) {
        $columns = fgetcsv($handle, $max_line_length, $delemietr);
        if (!$columns) {
            $error['message'] = 'Empty';
             return ($error);
        }

        while (($rows = fgetcsv($handle, 10000, "\t")) !== false) {
            if ($rows[1] && array(null) !== $rows) { // ignore blank lines
                        $data1 = $rows[1];
              }
            }
    }

edited May 21, 2016 at 11:20

answered May 21, 2016 at 11:00

Surendra Suthar

3702 silver badges12 bronze badges

2 Comments

chouaib23 Over a year ago

Hello there is porblem my csv has multi line and i want get only last line in fille

Surendra Suthar Over a year ago

Then you need to add nested loop to get total lines & get last row data

Collectives™ on Stack Overflow

PHP read CSV file line by lines

2 Answers 2

6 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related