PHP Insert multi-dimensional array values in csv

Question

I have the following array. For simplicity, i have only posted one item but it's a big array that contains a huge number of keys and values

Array
(
[Maths] => Array
    (
        [00] => 0
        [01] => 0
        [02] => 0
        [03] => 0
        [04] => 0
        [05] => 0
        [06] => 0
        [07] => 0
        [08] => 0
        [09] => 0
        [10] => 0
        [11] => 0
        [12] => 0
        [13] => 0
        [14] => 0
        [15] => 0
        [16] => 0
        [17] => 9
        [18] => 5128
        [19] => 5763
        [20] => 1734
        [21] => 632
        [22] => 299
        [23] => 190
    )

I would like to put the contents of the array into a csv file which will be structured like this. One line per outer array and conctenate the values of the inner array to it.

So the above array will appear like this. Please bear in mind that it's not a static array. All the information in the array is dynamic

Math,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9,5128,5763,1734,632,299,190

Please help

mameyugo · Accepted Answer · 2014-01-14 09:37:38Z

1

$data=Array(...);
$csv="";
foreach ($data as $key => $value) {
    $csv.=$key.",".implode(",", $value)."\n";
}

answered Jan 14, 2014 at 9:37

mameyugo

2981 silver badge6 bronze badges

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

Comments

Luca Iaco · Accepted Answer · 2014-01-14 09:30:24Z

0

if your structure is something like:

array ( key1 => array(), key2 => array() ... ) you could do this:

$csvOutput = "";

foreach ($baseAy as $key => $subAy) {

    $csvOutput.= "\n".$key.",";

    foreach ($subAy as $value) {
         $csvOutput.= $value.",";
    }
}

print_r($csvOutput);

answered Jan 14, 2014 at 9:30

Luca Iaco

3,4771 gold badge22 silver badges22 bronze badges

1 Comment

codepiper Over a year ago

above code gives comma(,) at the end, instead of inner foreach, you can use implode with comma(,) and concatenate.

Collectives™ on Stack Overflow

PHP Insert multi-dimensional array values in csv

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related