How to create nested json with laravel or mysql?

Question

I need to have something like this:

  "results":[  
  {  
     "id":1,
     "date":{  
        "date":"2015-04-1 00:00:00.000000",
        "timezone_type":3,
        "timezone":"America\/Denver"
     }
  },

query:

$find = DB::select( DB::raw("SELECT created_at as date, 'America/Denver' as timezone, 3 as timezone_type FROM table"));
return Response::json($find);

How to create date within date with mysql/Laravel? I tried to use array_merge but date will be appended at the bottom instead of make itself nested.

Show us how your table in mysql looks like and the code that you use to get the array from datatabase? — Arlind Hajredinaj
– Arlind Hajredinaj, Commented Apr 1, 2015 at 10:11

Arlind Hajredinaj · Accepted Answer · 2015-04-01 11:57:06Z

3

Just change your code to the code below:

        $tableIds = DB::select( DB::raw("SELECT id FROM table"));
        $jsonResult = array();

        for($i = 0;$i < count($tableIds);$i++)
        {
            $jsonResult[$i]["id"] = $tableIds[$i]->id;
            $id = $tableIds[$i]->id;
            $jsonResult[$i]["date"] = DB::select( DB::raw("SELECT created_at as date, 'America/Denver' as timezone, 3 as timezone_type  FROM table WHERE id = $id"));
        }

        return Response::json(array(
                    'error'     =>  false,
                    'stores'    =>  $jsonResult),
                    200
            );

answered Apr 1, 2015 at 11:57

Arlind Hajredinaj

8,5193 gold badges33 silver badges49 bronze badges

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

2 Comments

Arlind Hajredinaj Over a year ago

You could use a recursive function that iterates through each level, what do you have in mind?

seema Over a year ago

Great coding but faced problem, I am creating nested json response in laravel. I am taking three tables as category_type={category_type_id,category_name}; main_category={main_category_id,category_type_id,main_category_name} sub_category={sub_category_id,category_type_id,main_category_id,sub_category_name} and I am using coding and getting json but I want to nested third table in second plZ changes in coding I already nested second in first now I want nested third table in second

Collectives™ on Stack Overflow

How to create nested json with laravel or mysql?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related