echo多维数组到csv

Question

I have json array like bellow:

Array
(
    [total] => 1
    [rows] => Array
    (
        [0] => Array
            (
                [date] => 2014-11-12
                [A] => 1
                [B] => 2
                [C] => 2
                [D] => No
                [E] => New
                [F] => New
                [G] => 1
                [H] => 1
                [I] => 1
                [A] => 1
                [J] => 1
                [B] => 1
            )
        [1] => Array
            (
                [date] => 2014-12-12
                [A] => 1
                [B] => 1
                [C] => 2
                [D] => No
                [E] => New
                [F] => New
                [G] => 2
                [H] => 2
                [I] => 2
                [A] => 2
                [J] => 2
                [B] => 2
            )

    )

)

I want to echo like below:

date      A B C D E F G H I A J B
2014-11-12  1 2 2 No  New New 1 1 1 1 1 1
2014-12-12  1 1 2 No  New New 2 2 2 2 2 2

how i do this thing what is the best way any suggestion.

Answer 1

You can just use plain foreach in this case. As for the headers, you may need to use array_keys() for them. Example:

<?php

$array = [ 'total' => 1, 'rows' => [ [ 'date' => '2014-11-12', 'A' => '1', 'B' => '2', 'C' => '2', 'D' => 'No', 'E' => 'New', 'F' => 'New', 'G' => '1', 'H' => '1', 'I' => '1', 'A' => '1', 'J' => '1', 'B' => '1', ], [ 'date' => '2014-12-12', 'A' => '1', 'B' => '1', 'C' => '2', 'D' => 'No', 'E' => 'New', 'F' => 'New', 'G' => '2', 'H' => '2', 'I' => '2', 'A' => '2', 'J' => '2', 'B' => '2', ], ],];
$keys = array_keys(reset($array['rows']));

?>

<table cellpadding="10">
    <thead>
    <tr align="left">
        <?php foreach($keys as $header): ?>
            <th><?php echo $header; ?></th>
        <?php endforeach; ?>
    </tr>
    </thead>
    <tbody>
    <?php foreach($array['rows'] as $row): ?>
        <tr><?php foreach ($row as $value): ?>
            <td><?php echo $value; ?></td>
        <?php endforeach; ?></tr>
    <?php endforeach; ?>
    </tbody>
</table>

Sample Output

Printing in CSV:

$array = [ 'total' => 1, 'rows' => [ [ 'date' => '2014-11-12', 'A' => '1', 'B' => '2', 'C' => '2', 'D' => 'No', 'E' => 'New', 'F' => 'New', 'G' => '1', 'H' => '1', 'I' => '1', 'A' => '1', 'J' => '1', 'B' => '1', ], [ 'date' => '2014-12-12', 'A' => '1', 'B' => '1', 'C' => '2', 'D' => 'No', 'E' => 'New', 'F' => 'New', 'G' => '2', 'H' => '2', 'I' => '2', 'A' => '2', 'J' => '2', 'B' => '2', ], ],];
$data[] = array_keys(reset($array['rows'])); // push header inside
$data = array_merge($data, $array['rows']); // push values inside

$file = fopen('whatevertname.csv', 'w+');
foreach ($data as $value) {
    fputcsv($file, $value);
}
fclose($file);