From: Stevenv at operamail dot com
Operating system: FreeBSD 4.7
PHP version: 4.3.0
PHP Bug Type: Filesystem function related
Bug description: fgetcsv does not allow escaped quotes
As the summary says, fgetcsv does not allow escaped quotes. When csv fields
come from user input, it is often the case that addslashes() is run on
them then enclosed in quotes. However, fgetcsv() removes anything after
the escaped quote.
Code:
<?php
/* make a csv file */
$fp = fopen('csv_file', 'w+');
$fields = array();
$fields[0] = '"' . addslashes('This is "Field One"') . '"';
$fields[1] = 'field two';
$fields[2] = 'field three';
fwrite($fp, implode(',', $fields));
/* start all over */
fseek($fp, 0);
var_dump(fgetcsv($fp, 4096));
?>
Outputs:
array(3) {
[0]=>
string(9) "This is \"
[1]=>
string(9) "field two"
[2]=>
string(11) "field three"
}
The behavior I expected would have been for the first field to read:
"This is \"Field One\""
Much like the functionality described on
<http://rath.ca/Misc/Perl_CSV/CSV-2.0.html#csv specification>.
Thanks
--
Edit bug report at http://bugs.php.net/?id=22382&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=22382&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=22382&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=22382&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=22382&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=22382&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=22382&r=support
Expected behavior: http://bugs.php.net/fix.php?id=22382&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=22382&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=22382&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=22382&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=22382&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=22382&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=22382&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=22382&r=gnused
