Parse JSON with PHP and output to CSV

Question

I'm wondering how I can use PHP to parse the JSON below and output the parsed values into CSV format.

{
 "test":{"12345":"98765","56789":"54321"},
 "control":{"99999":"98765","88888":"98765"}
}

I would like to extract just the keys from the test array (i.e. 12345, 56789) and have them returned in CSV format. Is that possible to do using json_decode?

Please feel free to ask any questions if you need more information

all the values on one row or for each value one row? and do you want to output as web-page or locally to a file? — Roger
– Roger, Commented May 3, 2013 at 23:19

Explosion Pills · Accepted Answer · 2013-05-03 23:24:37Z

5

$json = json_decode($json, true);
fputcsv(fopen('file', 'w'), array_keys($json['test']));

answered May 3, 2013 at 23:24

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

1 Comment

Dinesh Over a year ago

crap.. didnt see the true.. sorry buddy.. +1

chelmertz · Accepted Answer · 2013-05-03 23:24:27Z

0

$s = '{
 "test":{"12345":"98765","56789":"54321"},
 "control":{"99999":"98765","88888":"98765"}
}';


$json = json_decode($s, true);
echo implode("\n", array_keys($json['test']));

Would that do?

answered May 3, 2013 at 23:24

chelmertz

20.6k5 gold badges42 silver badges46 bronze badges

2 Comments

conbask Over a year ago

This worked, but did not output to a CSV file. Thanks though!

chelmertz Over a year ago

@585connor writing to a file is something you probably should read up on then. :) See se1.php.net/file_put_contents

Collectives™ on Stack Overflow

Parse JSON with PHP and output to CSV

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related