fputcsv - Function gives Error.

Question

I'm trying to export my data into a csv file and let the user to download it. I'm using fputcsv() function, but in the file, the data are written in a single cell instead of adjacent cells. I don't know what is the problem. Please help me. here is my code

session_start();
header('Content-Type: application/csv');
header('Content-Disposition: attachement; filename=report_'.time().'.csv;');
$data = $_SESSION['data'];
$file = fopen('php://output','w');
foreach($data as $i=>$value)
{
    fputcsv($file, $value,";");
}
fclose($file);

and this is how the file looks like..

Try this fputcsv($fp, array_values($list), ';', ' '); – dkakoti Apr 29 '14 at 11:55 — dkakoti, Apr 29 '14 at 11:55

score 1 · Accepted Answer · answered Apr 29 '14 at 11:52

1

try like

 $data = array (
    'aaa,bbb,ccc,dddd',
    '123,456,789',
    '"aaa","bbb"');
$fp = fopen('php://output', 'w+'); 
header('Content-type: application/octet-stream');  
header('Content-disposition: attachment; filename="data.csv"'); 
foreach($data as $line){
    $val = explode(",",$line);
    fputcsv($fp, $val);
}
fclose($fp);

or try may be according your data

foreach($data as $i=>$value)
{
    fputcsv($file, $value);
}

answered Apr 29 '14 at 11:52

Rakesh Sharma

13,680
5
37
44

change according to your data – Rakesh Sharma Apr 29 '14 at 11:55
thank you so much, it works. can you explain what is wrong in my code if you have some time? – Vignesh Apr 29 '14 at 12:00
1

i think delimiter(;) you are using is wrong for more http://php.net/manual/en/function.fputcsv.php please accept every answer if you find correct with that – Rakesh Sharma Apr 29 '14 at 12:03

Manoj Yadav · Answer 2 · 2014-04-29T12:00:15.560

Use , instead of ; for delimiter

Replace fputcsv($file, $value,";"); with fputcsv($file, $value, ","); and try

Example:

header('Content-Type: application/csv');
header('Content-Disposition: attachement; filename=report_'.time().'.csv;');
$data = array(array('one' => 1, 'two' => 2));
$file = fopen('php://output','w');
foreach($data as $i => $value)
{
    //fputcsv($file, $value, ";");
    fputcsv($file, $value, ",");
}
fclose($file);

fputcsv - Function gives Error.

2 Answers2