PHP fgetcsv escape '\'

Question

A csv file contains a '\' character in one of its record for which i am not able to get the exact number of key value pair in the array.

I am using PHP fgetcsv function as follows-

 while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
   ....
 }

I have also tried escaping the characters as follows.

 while (($data = fgetcsv($handle, 1000, ",",'"',"\\")) !== FALSE) {
    ....
 }

But it did not work.What might be the possible solution?

Answer 1

I had the same problem, and solve it too easy. If your string enclosure charater is '"' ( double quotes ), and you just don't want to consider the backslash as a escape character, just inform the double quote twice, as the string enclusure and as a escape character.

    $data = fgetcsv($handle, 8192, ';' , '"' , '"'  );