php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #38929 fputcsv() fgetcsv() inconsistency even number backslashes then enclosure char
Submitted: 2006-09-22 20:05 UTC Modified: 2006-09-25 12:24 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:0 (0.0%)
From: mike at opendns dot com Assigned:
Status: Not a bug Package: *Directory/Filesystem functions
PHP Version: 5.1.6 OS: Linux, debian sarge
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
26 + 21 = ?
Subscribe to this entry?

 
 [2006-09-22 20:05 UTC] mike at opendns dot com
Description:
------------
If you write a string to file with fputcsv that contains an even number of backslashes follwed by the enclosure character, you don't get your enclosure character back when you read it back in with fgetcsv().  Then you'll get an extra trailing enclosure character at the end of your string.

Reproduce code:
---------------
$tmp_file = '/tmp/csv_f_up.tmp';

$data_to_write = array('string contains even number of backslashes \\\\" followed by enclosure char');

echo "data_to_write:\n";
var_dump($data_to_write);

$h_w = fopen($tmp_file, 'w');
fputcsv($h_w, $data_to_write);
fclose($h_w);

$h_r = fopen($tmp_file, 'r');
$data_read_in = fgetcsv($h_r);
fclose($h_r);

echo "data_read_in:\n";
var_dump($data_read_in);

Expected result:
----------------
data_to_write:
array(1) {
  [0]=>
  string(73) "string contains even number of backslashes \\" followed by enclosure char"
}
data_read_in:
array(1) {
  [0]=>
  string(73) "string contains even number of backslashes \\" followed by enclosure char"
}

Actual result:
--------------
data_to_write:
array(1) {
  [0]=>
  string(73) "string contains even number of backslashes \\" followed by enclosure char"
}
data_read_in:
array(1) {
  [0]=>
  string(73) "string contains even number of backslashes \\ followed by enclosure char""
}

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-09-25 12:24 UTC] tony2001@php.net
The same problem as #38918.
 [2010-08-03 10:21 UTC] surfchen at gmail dot com
I confirm this with php 5.2.9 on windows:
$arr=array('\\','"');
$h=fopen('test.csv',"w");
fputcsv($h,$arr);
fclose($h);

$h=fopen('test.csv',"r");
$line=fgetcsv($h);
var_dump($line);

result:
array(1) {
  [0]=>
  string(6) "\",""
"
}
 
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Tue Dec 06 09:05:54 2022 UTC