dongman5539 2018-08-13 18:34
浏览 96
已采纳

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

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!

  • 写回答

2条回答 默认 最新

  • dongrang2186 2018-08-13 18:55
    关注

    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;
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 5037端口被adb自己占了
  • ¥15 python:excel数据写入多个对应word文档
  • ¥60 全一数分解素因子和素数循环节位数
  • ¥15 ffmpeg如何安装到虚拟环境
  • ¥188 寻找能做王者评分提取的
  • ¥15 matlab用simulink求解一个二阶微分方程,要求截图
  • ¥30 乘子法解约束最优化问题的matlab代码文件,最好有matlab代码文件
  • ¥15 写论文,需要数据支撑
  • ¥15 identifier of an instance of 类 was altered from xx to xx错误
  • ¥100 反编译微信小游戏求指导