how to prevent php fgetcsv skipping first row

Question

I have this function that reads csv file line by line and looks for specific label in the first column of each row and then if label was found it reads all the columns next to this found label into array until column value is empty. It used to work fine, but recently I have noticed it started skipping the very first row in the file.

If i add an empty line at the top of the file it reads the row just fine, but how do i make it read from the very first line again?

I use PHP Version 5.5.18 and php version was upgraded not so long ago, if it is PHP version bug downgrading the version is not the solution for me...

Is there any alternative functions or maybe a way to force it to read from the first line or maybe suggestion on how to make this happen?

function getDataByLabel($label){

   if(($filePointer = fopen($this->path, "r"))!==FALSE){

       //reading each line
        while (($data = fgetcsv($filePointer, 0, ",",'"')) !== FALSE) {

            if(trim(strtolower($data[0]))==trim(strtolower($label))){ 

               $i=0;
               $c=1;

        // if column is not empty we add this value to an array
               while(!empty($data[$c])){
                    $label = trim(ucfirst(strtolower($label)));
                    $this->param[$label][$i] = $data[$c];
                    $i++;
                    $c++;
                }

            }

        }
    }
}

yes i am sure, it used to work just fine before the php upgrade — anonymous007, Jun 02 '15 at 10:52
Use fgets. This will read a line into a string. You can then use explode to split the string into an array (not associative). — crafter, Jun 02 '15 at 11:25

score -1 · Answer 1 · answered Dec 04 '19 at 15:12

-1

When you save csv file as UTF8-with Signature, it will skip the first row. using Emeditor, save as UTF8-Without Signature, will not skip 1st row.

answered Dec 04 '19 at 15:12

Metoo

1

how to prevent php fgetcsv skipping first row

1 Answers1