使用csv在列中设置数据

Question

I have three different arrays as give below

Array 1

array('column1 value1','column1 value2','column1 value3');

Array 2

array('column2 value1','column2 value2','column2 value3');

Array 3

array('column3 value1','column3 value2','column3 value3');

Now i want output in three columns with headings First Value, Second Value, Third Value in CSV File so my first array value should be in first value column second array value should be in second value column and so on.

I have Searched a lot but haven't find any solution.

Answer 1

<?php
$array1 = array('column1 value1', 'column1 value2', 'column1 value3');

$array2 = array('column2 value1', 'column2 value2', 'column2 value3');

$array3 = array('column3 value1', 'column3 value2', 'column3 value3');

$headers = array('First Value', 'Second Value', 'Third Value');

$result = array_map(null, $array1, $array2, $array3);

$fp = fopen('file.csv', 'w');
fputcsv($fp, $headers);
foreach ($result as $fields) {
    fputcsv($fp, $fields);
}

fclose($fp);

A nice solution that will work for you is to map all your values before you insert them using array_map and insert the headers separately.

The output of the above code is:

"First Value","Second Value","Third Value"
"column1 value1","column2 value1","column3 value1"
"column1 value2","column2 value2","column3 value2"
"column1 value3","column2 value3","column3 value3"