PHP export JSON to CSV

Question

Im try export json result to csv and save data as file, im try with something like this

$getFile = file_get_contents('JSON_URL');
$json_obj = json_decode($getFile);
$fp = fopen('/home/xxxx/public_html/xxxx/api/export/tmp/file.csv', 'w');
    foreach ($json_obj as $row) {
        fputcsv($fp, $row);
    }
fclose($fp);

but seems not working

Here's an example json format for link above

[
    {key:value,key:value...}
...]

What is happening when you do that? And what did you expect to happen? — Patrick Kostjens
– Patrick Kostjens, Commented Aug 11, 2013 at 14:24
in what way is it not working? are you getting any errors? is it creating a file at all? is it creating it empty, or with incorrect data? or mis-formatted? — Spudley
– Spudley, Commented Aug 11, 2013 at 14:25
Just get error in error_log Invalid argument supplied for foreach() , im change title of post, i need to export data to CSV file — Milan Milosevic
– Milan Milosevic, Commented Aug 11, 2013 at 14:27

DevZer0 · Accepted Answer · 2013-08-11 14:29:11Z

1

in order for your code to work as expected, try decoding the json object as an associative array. This is done by passing a boolean true to the 2nd param of json_decode

$json_obj = json_decode($getFile, true);

answered Aug 11, 2013 at 14:29

DevZer0

13.5k7 gold badges29 silver badges54 bronze badges

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

1 Comment

Lee Probert Over a year ago

could you point me at a way to do this if the JSON is being posted to the PHP through a form? I am not a PHP dev but am trying to cobble this together through scraps of code.

Collectives™ on Stack Overflow

PHP export JSON to CSV

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related