CSV to Json with header row as key

Question

I would like to convert a CSV to Json, use the header row as a key, and each line as object. How do I go about doing this?

----------------------------------CSV---------------------------------

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

---------------------------------PHP-----------------------------------

  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);

deceze · Accepted Answer · 2012-05-23 03:04:18Z

19

Just read the first line separately and merge it into every row:

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);

answered May 23, 2012 at 3:04

deceze♦

525k89 gold badges806 silver badges954 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

deceze Over a year ago

What don't you understand about it? It opens a file handle, reads the first line into $headers, then reads the remaining lines. It combines each line with the $headers. See array_combine.

Amado Martinez · Accepted Answer · 2016-04-04 21:33:43Z

1

I find myself converting csv strings to arrays or objects every few months.

I created a class because I'm lazy and dont like copy/pasting code.

This class will convert a csv string to custom class objects:

Convert csv string to arrays or objects in PHP

answered Apr 4, 2016 at 21:33

Amado Martinez

4392 silver badges8 bronze badges

Comments

devfaysal · Accepted Answer · 2019-10-23 06:15:26Z

1

$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

answered Oct 23, 2019 at 6:15

devfaysal

1682 silver badges9 bronze badges

Comments

E.A.T · Accepted Answer · 2016-06-23 00:44:41Z

For those who'd like things spelled out a little more + some room to further parse any row / column without additional loops:

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;
}

Collectives™ on Stack Overflow

CSV to Json with header row as key

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related