Split CSV row

[johnnnn]

I'm experimenting with flat files.

I have this file, it looks like this:

1,John Doe,"Hello world!"
2,Jane Doe,"Hello, John!"

My question is how could I "split" each row into 3 seperate fields

Here's what I have so far:

$db = file('db.txt');
foreach($db as $row) {
list($id, $name, $msg) = explode(",", $row);
}

However, the explode() is not working, any ideas?

[kbluhm]

http://www.php.net/fgetcsv

[GoodBanners.com]

Originally Posted by johnnnn

I'm experimenting with flat files.

I have this file, it looks like this:

1,John Doe,"Hello world!"
2,Jane Doe,"Hello, John!"

My question is how could I "split" each row into 3 seperate fields

Here's what I have so far:

$db = file('db.txt');
foreach($db as $row) {
list($id, $name, $msg) = explode(",", $row);
}

However, the explode() is not working, any ideas?

using explode or splut with delimited "," wont work if your texts contains ","