convert json to csv using php not getting right format

Question

I am trying to save simple JSON data to csv using php. But the problem is that I am getting data in columns instead of rows. My JSON looks like: {"userid":"686868","deviceid":"dummy"}

and the code is:

   $csv_write_path = "test.csv";
   $json_str = file_get_contents($json_file);
   $json_obj = json_decode($json_str, true);
   $f = fopen($csv_write_path, 'w');
   foreach ($json_obj as $line){
       fputcsv($f, (array)$line);//tried using fputcsv($f, $line); // it saves nothing
   }
   fclose($f);

And the output is:

693936

dummy

But I want the output file to look like: 693936 | dummy //i mean col wise

can someone suggest me that what possibly is wrong?

meda · Accepted Answer · 2015-06-28 19:36:45Z

1

You need to pass it an array of objects.

Your code currently is putting a line on each key of your single object.

example:

[
    {
        "userid": "686868",
        "deviceid": "dummy"
    }
]

then you dont need to cast to an array

fputcsv($f, $line);

edited Jun 28, 2015 at 19:36

answered Jun 28, 2015 at 18:48

meda

45.5k14 gold badges96 silver badges123 bronze badges

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

3 Comments

And_Dev Over a year ago

can you give me an example, i am new to json and php

And_Dev Over a year ago

but the issue is that i need to pass simple information only i.e. {"userid":"686868","deviceid":"dummy"}, is there any suggestion on this?

meda Over a year ago

I gave you the answer [{"userid":"686868","deviceid":"dummy"}]

Collectives™ on Stack Overflow

convert json to csv using php not getting right format

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related