write into csv file in php

Question

I have to create and write into a csv file. Now I tried with the following code:

header('Content-type: application/octet-stream');  
header('Content-disposition: attachment; filename="data.csv"');    
$data = array (
    'aaa,bbb,ccc,dddd',
    '123,456,789',
    '"aaa","bbb"');

$fp = fopen('php://output', 'w+');  
foreach($data as $line){
    $val = explode(",",$line);
    fputcsv($fp, $val);
}
fclose($fp);

It gives me my source file code also in the csv file? How can I solve this?

Where does your `$header` variable come from? – Industrial Sep 28 '11 at 06:47 — Industrial, Sep 28 '11 at 06:47
sorry it is not required. i edited the code – Sep 28 '11 at 06:58 — , Sep 28 '11 at 06:58
have you tried exit(); after fclose()? – Catalin Sep 28 '11 at 07:01 — Catalin, Sep 28 '11 at 07:01

score 1 · Answer 1 · answered Nov 03 '12 at 21:32

header() needs to come after the array and fopen

try this:

$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);

score 1 · Answer 2 · answered Sep 28 '11 at 06:44

1

Wrap it in <?php and ?> tags.

answered Sep 28 '11 at 06:44

dkamins

21,450
7
55
59

score 1 · Answer 3 · answered Sep 28 '11 at 09:42

1

Change the first header to header('Content-type: text/csv');

answered Sep 28 '11 at 09:42

Yeroon

3,223
2
22
29

score 0 · Answer 4 · answered Aug 23 '13 at 08:46

Try this:

header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=data.csv');

$data = array (
    'aaa,bbb,ccc,dddd',
    '123,456,789',
    '"aaa","bbb"');


$fp = fopen('php://output','w');
foreach ($data as $line) {
    fputcsv($fp, array_map('utf8_decode',array_values($line)), ',', '"');
}
fclose($fp);

write into csv file in php

4 Answers4

Linked