php to convert CSV to JSON with nested objects

Question

I have csv file like this:

data,IF,VVS1,VVS2
D,23,17,15
E,17,15,14

What i need is to convert this CSV into JSON but to look like this:

{"D" : {"IF":"23", "VVS1":"17", "VVS2":"15"},"E" : {"IF":"17", "VVS1":"15", "VVS2":"14"}}

Any help?

those answers were setting each row as an object, but problem was that I needed first column to be "key" of the nested object. — iva
– iva, Commented Feb 10, 2014 at 8:42

Suraj Kumar · Accepted Answer · 2014-02-09 18:37:29Z

2

/* Lets suppose, the csv file is, mydata.scv */

<?php
 $mydata = array();

 if($file = fopen("mydata.csv","r")){
   $csvheaders = fgetcsv($file);
   while(($row = fgetcsv($file)) !== FALSE){
     $arr = array();
     for($i=1; $i<count($csvheaders); $i++){
      $arr[$csvheaders[$i]] = $row[$i];
     } 
     $mydata[$row[0]] = $arr;
    }
  fclose($file);
  // encode $mydata array into json to get result in the required format
  $mydatainformat = json_encode($mydata);
  echo $mydatainformat; // This is your output.
 }
?>

answered Feb 9, 2014 at 18:37

Suraj Kumar

5741 gold badge3 silver badges11 bronze badges

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

Comments

Jiří Chmiel · Accepted Answer · 2014-02-09 18:19:58Z

2

Maybe help you, but I recommend add error handling.

<?php

$file = fopen('test.csv', 'r');

$header = fgetcsv($file);
array_shift($header);

$data = array();

while ($row = fgetcsv($file))
{
  $key = array_shift($row);

  $data[$key] = array_combine($header, $row);
}

echo json_encode($data);

fclose($file);

answered Feb 9, 2014 at 18:19

Jiří Chmiel

8766 silver badges21 bronze badges

Collectives™ on Stack Overflow

php to convert CSV to JSON with nested objects

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related