Skip 3 first lines of CSV in PHP

Question

I have this readCSV function that for now skips the first line, but I need it to skip the three first lines.

What is the preferred way of achieving that?

function readCSV($csvFile){
   $file_handle = fopen($csvFile, 'r');
   while (!feof($file_handle) ) {
     $array = fgetcsv($file_handle, 'r', ';');
     $line_of_text[] = array('dato'=>$array[0],'vs'=>trim($array[1]),'vf'=>trim($array[2]));
   }
   fclose($file_handle);
   return $line_of_text;
 }

$csvFile = 'http://some.file.csv';

You could call `fgets($file_handle)` three times before your loop. — Alex Howansky, May 09 '17 at 20:28
keep a counter to count lines processed inside the loop, act only once the counter is greater than 3. — coderodour, May 09 '17 at 20:28
Can you please explain which part of your code skips the first line? — coderodour, May 09 '17 at 20:34
@AlexHowansky Thanks, this worked fine. Liked the examples offered in the other answers, but I did not get that to work. Your simple 3 x fgets before the loop works fine. — Filip Blaauw, May 09 '17 at 20:58

score 0 · Answer 1 · answered May 09 '17 at 20:34

Use a counter to keep track of home many lines have been processed:

  function readCSV($csvFile){
   $file_handle = fopen($csvFile, 'r');
   $counter = 0;
   while (!feof($file_handle) ) {
    if($counter < 3){
         $array = fgetcsv($file_handle, 'r', ';');
         $line_of_text[] = array('dato'=>$array[0],'vs'=>trim($array[1]),'vf'=>trim($array[2]));
    }
    $counter++
   }
   fclose($file_handle);
   return $line_of_text;
 }

score 0 · Answer 2 · answered May 09 '17 at 20:34

Keep a counter to count lines processed inside the loop, act only once the counter is greater than 3.

Example:

function readCSV($csvFile){

  $counter = 0;

  $file_handle = fopen($csvFile, 'r');

  while (!feof($file_handle) ) {
    if($counter > 3){
      $array = fgetcsv($file_handle, 'r', ';');
      $line_of_text[] = array('dato'=>$array[0],'vs'=>trim($array[1]),'vf'=>trim($array[2]));
    }
    $counter++;
  }

  fclose($file_handle);
  return $line_of_text;
}

$csvFile = 'http://some.file.csv';

Skip 3 first lines of CSV in PHP

2 Answers2