PHP CSV file issues(part 2)

Question

continue on PHP duplicate staffID
code
$data[0] = 0001,Ali,N,OK
$data[1] = 0002,Abu,N,OK
$data[2] = 0003,Ahmad,N,OK
$data[3] = 0004,Siti,Y,Not OK. Only one manager allowed!
$data[4] = 0005,Raju,Y, Not OK. Only one manager allowed!

I write it as following:
```
for($i = 0; $i < 5; $i++)
{
    $data[i] = $staffID[$i].','.$staffname[$i].','.$ismanager[$i].','.$remark[$i];
}
```

Next I go to write csv file.

$file_format = "staffreport.csv";
$file = fopen($file_format,"w");
foreach($data as $line)
{
    $replace = str_replace(",","|", $line);
    fputcsv($file, array($replace));
    echo $replace.'<br />';
}
fclose($file);

output (echo $replace)
0001|Ali|N|OK
0002|Abu|N|OK
0003|Ahmad|N|OK
0004|Raju|Y|Only one manager allowed!
0005|Siti|Y|Only one manager allowed!
In CSV file (staffreport.csv)
0001|Ali|N|OK
0002|Abu|N|OK
0003|Ahmad|N|OK
"0004|Siti|Y|Only one manager allowed!"
"0005|Raju|Y|Only one manager allowed!"
Why my csv file have double quote("")? How do I solve it?

Michael Kuan · Accepted Answer · 2014-12-26 07:46:25Z

2

change this bit like so.

for($i = 0; $i < 5; $i++)
{
    $data[i] = array($staffID[$i],$staffname[$i],$ismanager[$i],$remark[$i]);
}

fputcsv wants an array of columns it will then insert the separators and quote marks as needed.

fputcsv usually uses commas for separators, if you want pipes: do this:

 fputcsv($file, $line,'|');

why the quotes? probably because of the spaces.

if you must avoid the quotes,

 fputcsv($file, $line,'|','');

hope that helps.

edited Dec 26, 2014 at 7:46

Michael Kuan

1,1013 gold badges10 silver badges28 bronze badges

answered Dec 26, 2014 at 6:49

Jasen

12.5k2 gold badges37 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP CSV file issues(part 2)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related