Trouble parsing CSV data when string contains a comma

Question

I am parsing a CSV data feed sent to me via php. I am turning each line into an array of values.

Here is my code:

$fp = fopen('data.txt','r');

while (!feof($fp))
{
    $line = mysql_real_escape_string(fgets($fp));

    $value_array = explode(',', $line);
}

But if one of the lines looks like this:

"some company, inc.",XC34ET,500

I am getting 4 values:

1. "some company

2. inc."

3. XC34ET

4. 500

When I really want these 3 values:

1. some company, inc.

2. XC34ET

3. 500

How can I update my script to account for this?

Answer 1

There is a built-in function for parsing csv files: fgetcsv(). Just replace the fgets() call with it. Using '"' as value for the $enclosure parameter should solve your problem .

Answer 2

You can use str_getcsv to read in the line and parse it, returning an array

http://uk2.php.net/manual/en/function.str-getcsv.php