Read specific line from csv file on php

Question

How do I get the second line from this CSV file?

 <?php

        $file = file('list.csv');
        while (($line = fgetcsv($file)) !== FALSE) {
            print_r($line);  
        }

 ?>

Rakesh Jakhar · Answer 1 · 2019-05-08T15:41:12.343

2

You can use an iterator to apply condition

 $file = file('list.csv');
 $i = 0;
 while (($line = fgetcsv($file)) !== FALSE) {
    if($i == 1){
      print_r($line);
      break;
    }
    $i++      
 }

edited May 08 '19 at 15:41

answered May 08 '19 at 15:34

Rakesh Jakhar

6,380
2
11
20

I've a too big file, so I don't want to loose time reading all the file and then catch the line that a I want. I want to fetch the exact line to turn the process faster. – vinoli May 08 '19 at 15:40
1

just use break in if – Rakesh Jakhar May 08 '19 at 15:41
1

@vinoli I have updated the answer – Rakesh Jakhar May 08 '19 at 15:41

score 0 · Answer 2 · answered May 08 '19 at 15:50

Firstly file() reads the file into an array, so you don't need that - just open it using fopen() (and don't forget to close it), then if you only want the second line, then just call fgetcsv() twice...

$file = fopen('list.csv', r);
$line = '';
if (fgetcsv($file) !== FALSE) {
    $line=fgetcsv($file);  
}
fclose($file);

Read specific line from csv file on php

2 Answers2