Laravel show array json

Question

I want to show data from database: for every id_grup has many lapangan(court)

  $groups_resource = Groups::all();
  $groups = [];
  foreach($groups_resource as $group)
  {
    $g = new Groups();
    $g->id_group = "Group_".$group['id_group'];
    $g->name = $group['nama'];
    $g->expanded = true;
    $g->eventHeight = 25;
    $g->children = array();
    $groups[] = $g;

  $lapangan_resource = Lapangan::with('groups')->orderBy('nama')->get();
  foreach($lapangan_resource as $lapangan)
  {
    $l = new Lapangan();
    $l->id_lapangan = $lapangan['id_lapangan'];
    $l->name = $lapangan['nama_lapangan'];
    $g->children[] = $l;
  }
  }
    return json_encode($groups);

output for above code

[{"id_group":"Group_1","name":"Lapangan Badminton","expanded":true,"eventHeight":25,"children":[]},{"id_group":"Group_2","name":"Lapangan Tenis","expanded":true,"eventHeight":25,"children":[]}]

There is no value for children which might be like this.

[{"id":"group_1","name":"Indoor","expanded":true,"eventHeight":25,"children":[
{"id":"1","name":"Court 1"},
{"id":"2","name":"Court 2"},
{"id":"3","name":"Court 3"},
{"id":"4","name":"Court 4"}]},"id":"group_2","name":"Outdoor","expanded":true,"eventHeight":25,"children":[
{"id":"11","name":"Court 5"},
{"id":"12","name":"Court 6"},
{"id":"13","name":"Court 7"},
{"id":"14","name":"Court 8"}]}]

Saumya Rastogi · Accepted Answer · 2016-12-23 15:59:59Z

1

You are using wrong array braces. You shouldn't first initialize the children property of a group instead of that you can do it like this:

foreach($groups_resource as $group)
{
  $g = new Groups();
  $g->id_group = "Group_".$group['id_group'];
  $g->name = $group['nama'];
  $g->expanded = true;
  $g->eventHeight = 25;

  $l_arr = [];
  $lapangan_resource = Lapangan::with('groups')->orderBy('nama')->get();
  foreach($lapangan_resource as $lapangan)
  {
      $l = new Lapangan();
      $l->id_lapangan = $lapangan['id_lapangan'];
      $l->name = $lapangan['nama_lapangan'];
      $l_arr[] = $l;
  }

  $g->children = $l_arr;
  $groups[] = $g;
}

return json_encode($groups);

Hope this helps!

edited Dec 23, 2016 at 15:59

answered Dec 23, 2016 at 15:02

Saumya Rastogi

13.8k5 gold badges45 silver badges45 bronze badges

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

4 Comments

Ferdy Over a year ago

thanks @Saumya Rastogi the children has return value, but var $lapangan_resouce result didn't match as groups. Maybe i wrong for calling data(s)

Ferdy Over a year ago

now i have output [{"id_group":"Group_1","name":"Lapangan Badminton","expanded":true,"eventHeight":25,"children":{"id_lapangan":2,"name":"Lapangan 2"}},{"id_group":"Group_2","name":"Lapangan Tenis","expanded":true,"eventHeight":25,"children":{"id_lapangan":2,"name":"Lapangan 2"}}] the children only give last value

Saumya Rastogi Over a year ago

@Ferdy - See my updated, answer, just push all the children in an array, and push the array inside group's child, as shown in the updated answer!

Ferdy Over a year ago

Done! I just have some change to call data for $lapangan_resource. Thanks

Collectives™ on Stack Overflow

Laravel show array json

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related