I have an array in this format:
That I want to output to csv. The trouble I'm having is getting that array in the right format. When I do:
foreach ($array as $row) {
fputcsv($df, $row);
}
I only get the integer values. I am missing a column with the names like ACCESSORIES.
Here is the output:
But I want column A to have the names like ACCESSORIES and column B to have the values.
fputcsv just outputs the array values; the keys would usually be column names, not additional columns in the row. You need to make an array out of each element's key and value.
foreach ($array as $row) {
$keys = array_keys($row);
fputcsv($df, array($keys[0], $row[$keys[0]]));
}
You can use the iteration loop of foreach like that :
foreach ($array as $key => $value) {
fputcsv($df, array($key[0], $value[$key[0]]));
}
$array, $key will be indexes 0, 1, 2, etc.
if somebody is looking for exporting the results from a query with dynamic headers to an array then to csv file you could use the following function :
function exportCSVFile($fieldsNames, $result)
{
$fileName = "result.csv";
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=$fileName");
header("Pragma: no-cache");
header("Expires: 0");
$stdout = fopen('php://output', 'w');
fputcsv($stdout, $fieldsNames, ',', '"'); // put the headers or fields Names
$resultArray = array();
$tempRowHolder = array();
/*
build the finalized array which will be used to export the result as csv
*/
for ($i = 0; $i < count($result); $i++) {
for ($j = 0; $j < count($fieldsNames); $j++) {
$tempRowHolder[$j] = $result[$i][$fieldsNames[$j]]; // fetch a row by the different fields names
}
/* push the row from the tempRowHolder array to the main array($resultArray) */
array_push($resultArray, $tempRowHolder);
/* clear the temporary array (the holder of the row) to use it fresh in the next iteration */
$tempRowHolder = [];
}
$i = 0;
/* put the finalized array into the csv file */
while ($i < count($resultArray)) {
fputcsv($stdout, $resultArray[$i++]);
}
fclose($stdout);
}
it will help you ,I used my array like :
Array
(
[0] => Array
(
[NUMBER] => 67
[TYPE] => Other
[DATE] => 3/31/2011
)
[1] => Array
(
[NUMBER] => 87
[TYPE] => something
[DATE] => 3/28/2011
)
[2] => Array
(
[NUMBER] => 67
[TYPE] => Other
[DATE] => 3/2/2011
)
)
<?php
$fp1 = fopen('file.csv', 'w');
foreach ($arr2 as $fields)
{
fputcsv($fp1, $fields);
}
fclose($fp1);
?>
array('ACCESSORIES' => 0, 'ANNUALS' => 0, ...)?