php make csv file for the array

Question

I have an array. When I am using print_r($output). I am getting the array like this

I want to export this to a csv file. So for that I made my code like this

$fichier = 'file.csv';
 header( "Content-Type: text/csv;charset=utf-8" );
 header( "Content-Disposition: attachment;filename=\"$fichier\"" );
 header("Pragma: no-cache");
 header("Expires: 0");

 $fp= fopen('php://output', 'w');

 foreach ($output as $fields) 
 {
    fputcsv($fp, $fields);
 }
 fclose($fp);
 exit();

But here I am getting the file but when I am opening the file it is showing only array(). So can someone tell me how to get the data in csv? Any help and suggestions will be really appreciable. Thanks

$output variable may be double dimentional array. please print the $output variable. — selvan, Jun 02 '15 at 08:05
I suggest to use xml instead of csv. It's impossible to keep the correct structure of nested arrays in csv. — umka, Jun 02 '15 at 08:06
Not everything can be `csv`ed. What about the nesting levels? — Hanky Panky, Jun 02 '15 at 08:09
is it possible the values of `$output` change between the `print_r` and the `fputcsv()` ? Your modified version looks fine to me, but maybe if you show us the code that generates `$output` it might shed some light on it... — komodosp, Jun 02 '15 at 15:13

score 2 · Answer 1 · answered Jun 02 '15 at 08:12

2

Your array isn't really CSV friendly as it is multi-dimensional.

To put into CSV, you need to convert each element of $output to a one-dimensional array:

foreach ($output as $fields) {

   $csvrec = array(
        'listing_id' => $fields['listing_id'],
        'category_id' => $fields['category_id'], 
   // etc... etc...
   // down to...
        'parking' => $fields['dinning_details']['parking'],
        'byo_info' => $fields['dinning_details']['byo_info'],
        'indoor' => $fields['dinning_details']['capacity']['indoor'],
   // etc.. etc...
   );

   fputcsv($fp, $csvrec);
}

answered Jun 02 '15 at 08:12

komodosp

3,316
2
30
59

How to add header for the column? – NewUser Jun 02 '15 at 10:14
@NewUser - is it possible the values of `$output` change between the `print_r` and the `fputcsv()` ? – komodosp Jun 02 '15 at 10:21
To add headers, simply add 1 line of CSV containing the header names... i.e. `fputcsv($fp, array("Listing ID", "Category ID", etc, etc))` before the loop. – komodosp Jun 02 '15 at 10:22

score 0 · Answer 2 · answered Jun 02 '15 at 08:07

0

When passing a nested array to fputcsv, the inner array will show up as 'Array'. You should first flatten your array or format it in a way that corresponds to your desired CSV format.

answered Jun 02 '15 at 08:07

Martijn

5,491
4
33
41

php make csv file for the array

2 Answers2

Linked