How to write 2 arrays in csv file using php

Question

I want to write 2 arrays in a csv file and display it horizontally.

Array 1

Array
(
    [0] => Array
        (
            [0] => 501
            [1] => 8921
        )

    [1] => Array
        (
            [0] => 502
            [1] => 8446
        )
)

Array 2

Array
(
    [0] => Array
        (
            [0] => 501
            [1] => 8900
        )

    [1] => Array
        (
            [0] => 502
            [1] => 8436
        )
)

Code to write in csv file:

header("Content-type: text/csv; charset=utf-8; encoding=utf-8");
header("Content-Disposition: attachment; filename={$exportFileName}.csv");
header("Pragma: no-cache");
header("Expires: 0");

$file = fopen('php://output', 'w');
fputcsv($file, array('HID', 'WEEK1', 'HID', 'WEEK2')); 
foreach  ($fweek as $k=>$row) 
{
    fputcsv($file, $row);  // I want to include $sweek as well             
}

But currently, it displays only the first array.

Any hint/suggestion will do a great help. Thanks in advance.

Kevin · Accepted Answer · 2014-10-08 11:41:42Z

2

If they are always going to be lined up, you could use the key of the foreach to that other array and merge them. Like this:

foreach($fweek as $k => $row) {
    $row = array_merge($row, $sweek[$k]);
    fputcsv($file, $row);
}

answered Oct 8, 2014 at 11:41

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

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

1 Comment

Raj Over a year ago

You are simply brilliant.Kudos....wtf I spent 2 hrs for this. Thank you so so much.

Collectives™ on Stack Overflow

How to write 2 arrays in csv file using php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related