How to use str_getcsv () and ignore commas between quotes?

Question

Here is my current code.

<?php$da_data = $_POST['dadata'];
$da_data = htmlspecialchars($da_data, ENT_QUOTES);
$da_data = str_replace('&lt;', '', $da_data);
$da_data = str_replace("&gt;", '', $da_data);
$da_data = str_getcsv($da_data,  ",", "'");
print_r($da_data);
?>

Sample data:

"Bill, Rose Mary" <[e-mail]>,"asasd, test" <[e-mail]>,

he spits out

Array (
[0] => \"Bill
[1] => Rose Mary\" [e-mail]
[2] => \"asasd
[3] => test\" [e-mail]
[4] =>
)

I would like the name and email address to be combined against each other. What am I missing?

Answer 1

$da_data = str_getcsv($da_data,  ",", "'");
//                                     ^

will read this as you want:

'Bill, Rose Mary' <[e-mail]>,'asasd, test' <[e-mail]>,
^               ^                      ^           ^

But you do not use single quotes in the CSV file, as indicated in your call str_getcsv. This is ":

$da_data = str_getcsv($da_data,  ',', '"');
//                                     ^

var_dump($da_data);

Output:

array(3) {
  [0]=>
  string(36) "Bill, Rose Mary <[e-mail]>"
  [1]=>
  string(32) "asasd, test <[e-mail]>"
  [2]=>
  string(0) ""
}

Demo

Please note that it deletes yours ", as it is actually assumed that it contains the entire string.

In a completely different note, to make sure you get the data you need, you must convert your CSV file to the following:

"Bill, Rose Mary <[e-mail]>","asasd, test <[e-mail]>",
^                                    ^ ^                                ^