Bug #75978 [NEW]: Improper parsing

From: fwilliams22 at gmail dot com Operating system: Windows/Linux PHP version: Irrelevant Package: Strings related Bug Type: Bug Bug description:Improper parsing Description: ------------ "CVS" string processing fails to properly parse " (quote) delimited fields. delimited fields containing an ' (apostrophe) fail to parse correctly. Appears that parser recognizes an embedded apostrophe as a field delimiter. My workaround is: while (($data = fgets($handle, 500))) { $data = str_replace("'","\\'",$data); $data = str_getcsv($data, ",",'"'); $query = "INSERT INTO address (fname,lname,address,city,state," . "postcode,aux)". " VALUES '$data[0]','$data[1]','$data[2]','$data[3]'," . "'$data[4]','$data[5]','$data[6]');"; $result = $db->exec($query); Not all test cases seem to fail. I have had to use the above workaround to update a MySQL table. The below example test script seems to have worked leaving "\\'" in the test field? Anyhow that's my story and I'm sticking to it. Could be the issue is in the PDO MySQL driver? One of 'em needs more testing. Test script: --------------- $data = "\"Got'ta apostrophe you can spare?\""; $data = str_replace("'","\\'",$data); $data = str_getcsv($data, ",",'"'); -- Edit bug report at https://bugs.php.net/bug.php?id=75978&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=75978&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=75978&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=75978&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=75978&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=75978&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=75978&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=75978&r=needscript Try newer version: https://bugs.php.net/fix.php?id=75978&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=75978&r=support Expected behavior: https://bugs.php.net/fix.php?id=75978&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=75978&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=75978&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=75978&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=75978&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=75978&r=dst IIS Stability: https://bugs.php.net/fix.php?id=75978&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=75978&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=75978&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=75978&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=75978&r=mysqlcfg