PHP CSV到关联数组，顶行为键，列为值数组

Question

I am trying to create a multidimensional array using CSV file so that for example:

"a","b","c"
1,2,3
4,5,6

would return as:

array(  
    'a' => array(1, 4),  
    'b' => array(2, 5),  
    'c' => array(3, 6),  
    )

But the code I have:

<?php
function readCSV($csvFile) {
    $aryData = [];
    $header = NULL;
    $handle = fopen($csvFile, "r");
    if($handle){
        while (!feof($handle)){
            $aryCsvData = fgetcsv($handle);
            if(!is_array($aryCsvData)){
                continue;
            }
            if(is_null($header)){
                $header = $aryCsvData;
            } 
            elseif(is_array($header) && count($header) == count($aryCsvData)){
                $aryData[] = array_combine($header, $aryCsvData);
            }
        }
        fclose($handle);
    }
    return $aryData;
}

print_r(readCSV("Book1.csv"));
?>

Returns it as:

Array(  
[0] => Array ( [a] => 1 [b] => 2 [c] => 3 )   
[1] => Array ( [a] => 4 [b] => 5 [c] => 6 )   
)

Would appreciate any help!

Answer 1

Instead of building the end array as you go along. This code reads the header row before the loop, then just reads all of the data lines into another array. It then combines each element of the header array with the matching column from the data array (using array_column() and the position of the header element)...

function readCSV($csvFile) {
    $aryData = [];
    $output = [];
    $header = NULL;
    $handle = fopen($csvFile, "r");
    if($handle){
        $header = fgetcsv($handle);
        while ($aryData[] = fgetcsv($handle));
        foreach ( $header as $key=>$label) {
            $output[$label] = array_column($aryData, $key);
        }
        fclose($handle);
    }
    return $output;
}