csv to array in php code example
Example 1: php array to csv
Instead of writing out values consider using 'fputcsv()'.
This may solve your problem immediately.
function array2csv($data, $delimiter = ',', $enclosure = '"', $escape_char = "\\")
{
$f = fopen('php://memory', 'r+');
foreach ($data as $item) {
fputcsv($f, $item, $delimiter, $enclosure, $escape_char);
}
rewind($f);
return stream_get_contents($f);
}
$list = array (
array('aaa', 'bbb', 'ccc', 'dddd'),
array('123', '456', '789'),
array('"aaa"', '"bbb"')
);
var_dump(array2csv($list));
Example 2: column of csv to array php
$csv = array_map("str_getcsv", file("data.csv", "r"));
$header = array_shift($csv);
$col = array_search("Value", $header);
foreach ($csv as $row) {
$array[] = $row[$col];
}