Question

我想将 CSV 转换为 Json, 使用页眉行作为键, 将每行作为对象。我该怎么做?

- - - - - - - - - - - - - - - - - - -

 InvKey,DocNum,CardCode
 11704,1611704,BENV1072
 11703,1611703,BENV1073

- - - - - - - - - - - - - - - - - -

  if (($handle = fopen( upload/BEN-new.csv .   , "r")) !== FALSE) {
       while (($row_array = fgetcsv($handle, 1024, ","))) {
            while ($val !=   ) {
                foreach ($row_array as $key => $val) {
                        $row_array[] = $val;
                        }
                }
            $complete[] = $row_array;   
            }
            fclose($handle);
        }
        echo json_encode($complete);

Answer 1

将第一行分开阅读,然后将其合并为每一行:

if (($handle = fopen( upload/BEN-new.csv ,  r )) === false) {
    die( Error opening file );
}

$headers = fgetcsv($handle, 1024,  , );
$complete = array();

while ($row = fgetcsv($handle, 1024,  , )) {
    $complete[] = array_combine($headers, $row);
}

fclose($handle);

echo json_encode($complete);

Answer 2

我发现自己每隔几个月就会转换 Csv 字符串到数组或对象。

我创造了一个班因为我懒惰不喜欢复制/粘贴代码

此类将把 csv 字符串转换为自定义类对象 :

< a href=" "https://github.com/projectivemotion/csv-to-objects" rel=“nofollow” >Convert csv 字符串,用于 PHP 中的阵列或对象

Answer 3

$feed="https://gist.githubusercontent.com/devfaysal/9143ca22afcbf252d521f5bf2bdc6194/raw/ec46f6c2017325345e7df2483d8829231049bce8/data.csv";
//Read the csv and return as array
$data = array_map( str_getcsv , file($feed));
//Get the first raw as the key
$keys = array_shift($data);  
//Add label to each value
$newArray = array_map(function($values) use ($keys){
    return array_combine($keys, $values);
}, $data);
// Print it out as JSON
header( Content-Type: application/json );
echo json_encode($newArray);

Main gist: https://gist.github.com/devfaysal/9143ca22afcbf252d521f5bf2bdc6194

Answer 4

对于那些喜欢的东西的人来说, 写出多一点 + 一些空间, 可以进一步分析任何行/列, 而没有额外的循环 :

function csv_to_json_byheader($filename){
    $json = array();
    if (($handle = fopen($filename, "r")) !== FALSE) {
        $rownum = 0;
        $header = array();
        while (($row = fgetcsv($handle, 1024, ",")) !== FALSE) {
            if ($rownum === 0) {
                for($i=0; $i < count($row); $i++){
// maybe you want to strip special characters or merge duplicate columns here?
                    $header[$i] = trim($row[$i]);
                }
            } else {
                if (count($row) === count($header)) {
                    $rowJson = array();                     
                    foreach($header as $i=>$head) {
                // maybe handle special row/cell parsing here, per column header
                        $rowJson[$head] = $row[$i];                     
                    }
                    array_push($json, $rowJson);
                }
            }
            $rownum++;
        }
        fclose($handle);
    }
    return $json;
}

友情链接