php create csv from associative array

Question

I have to generate the csv from below array

Array
(
    [sku1] => Array
        (
            [bin1] => 10
            [bin2] => 5
            [bin3] => 10
        )

    [sku2] => Array
        (
            [bin2] => 10
            [bin10] => 9
        )

    [sku3] => Array
        (
            [bin3] => 7
        )

)

and csv format should be as below,

sku1,bin1,10

sku1,bin2,10

sku2,bin2,10

sku2,bin10,9

sku3,bin3,7

How to archive this?

So, you want us to write your code? Show us what you tried so far? — Cipryst, Apr 24 '18 at 08:16
Have a look at https://stackoverflow.com/questions/43954815/php-csv-to-associative-array-with-row-headings — Ibrahim Hafiji, Apr 24 '18 at 08:16

score 1 · Accepted Answer · answered Apr 24 '18 at 08:27

Try :

                    $array= [
                        'sku1' => [
                            'bin1' => 10,
                            'bin2' => 5,
                            'bin3' => 10
                        ]
                        ,
                        'sku2' => [
                            'bin2' => 10,
                            'bin10' => 9,
                        ],
                        'sku3' => [
                            'bin3' => 7
                        ]
                    ];

                    $fileContent=[];

                    foreach ($array as  $key =>$value1){
                         foreach ($value1 as $key2 => $value2){
                             $fileContent[]=[$key, $key2, $value2];
                         }
                    }


                    $fp = fopen('file.csv', 'w');

                    foreach ($fileContent as $fields) {
                        fputcsv($fp, $fields);
                    }

                    fclose($fp);

ishant saxena · Answer 2 · 2018-04-24T09:50:12.153

try : // set header to auto download file in csv foramt

header("Content-Disposition: attachment; filename=\"demo.xls\"");
header("Content-Type: application/vnd.ms-excel;");
header("Pragma: no-cache");
header("Expires: 0");
$out = fopen("php://output", 'w');
//this is your data array to be converted in csv 

$result= 
array('sku1'=>array('bin1'=>10,'bin2'=>5,'bin3'=>10),'
sku2'=>array('bin2'=>10,'bin10'=>3),'sku3'=>array('bin3'=>7));

$final=array();
// now se are converting first array key in to node
foreach($result as $key=>$val){
// now se are converting second array key and value in to node
foreach ($val as $k=>$v){
// merging first array key and second array key values in to single array to 
//make a csv
$final[]=array($key,$k,$v);
}

}

foreach ($final as $data)
{
  //Now we are generating the csv from final array 
  fputcsv($out, $data,"\t");
}   
fclose($out);

Can you format the code and add more text on what the code does? — Riyafa Abdul Hameed, Apr 24 '18 at 09:32
I have edited the code and give explanation what the code does — ishant saxena, Apr 24 '18 at 09:51

score 0 · Answer 3 · answered Apr 24 '18 at 08:21

Try this example using fputcsv() function also read this link for getting an idea about fputcsv()

$list = array (
array('aaa', 'bbb', 'ccc', 'dddd'),
array('123', '456', '789'),
array('"aaa"', '"bbb"')
);$fp = fopen('file.csv', 'w');
foreach ($list as $fields) {
fputcsv($fp, $fields);
}
fclose($fp);

php create csv from associative array

3 Answers3