Get Nested json array of data Laravel Eloquent model with Relationship

Question

I am making social network using laravel where I want to show " 'post' 'comments' 'comment_by' user info in single array with nested relationship

Here is my class and database structure

table name and Fields

Members

         ID => primary key,
         name,
         email

Posts

         ID => primary key,
         postText
         fromUserId => foreign key (Members-id)

Comments

         commentText ,
         onPostId = > foreign key (Post-id)
         fromUserId = > foreign key (Members-id)

Eloquent Models

Member.php

class Member extends Model { // }
Post.php

class post extends Model { // public $timestamps = true;

function getUserDetails() { return $this->belongsTo('App\Member', 'fromUserId', 'id'); }

function getCommentDetails() { return $this->hasMany('App\comment', 'onPostId', 'id'); }

}

3.Comment.php

class comment extends Model
  {


  }

call for getting array

 $posts=post::with('getUserDetails','getCommentDetails')->get();

*expected output

{  
   "id":1,
   "postType":1,
   "postText":"my name is parth",
   "url":null,
   "likesCount":0,
   "unlikesCount":0,
   "shareCount":0,
   "commentsCount":0,
   "thumbUrl":null,
   "accessMode":1,
   "fromUserId":1,
   "isAdult":1,
   "created_at":null,
   "updated_at":null,
   "get_user_details":{  
      "id":1,
      "name":"parth",
      "email":"[email protected]",
      "password":"parth123456",
      "remember_token":"e1b28a30ab467c52924df64034c386d4",
      "created_at":null,
      "updated_at":null
   },
   "get_comment_details":[  
      {  
         "id":1,
         "commentsText":"dccd",
         "onPostId":1,
         "fromUserId":1,
         "created_at":"2017-05-25 16:44:51",
         "updated_at":null
         "commented_by":{  
               "id":1,
               "name":"parth",
               "email":"[email protected]",
               "password":"parth123456",
               "remember_token":"e1b28a30ab467c52924df64034c386d4",
               "created_at":null,
               "updated_at":null
             },
      },
      {  
         "id":3,
         "commentsText":"second comment",
         "onPostId":1,
         "fromUserId":1,
         "created_at":"2017-05-26 09:40:51",
         "updated_at":null
         "commented_by":{  
               "id":1,
               "name":"parth",
               "email":"[email protected]",
               "password":"parth123456",
               "remember_token":"e1b28a30ab467c52924df64034c386d4",
               "created_at":null,
               "updated_at":null
             },
      },
      {  
         "id":4,
         "commentsText":"second comment",
         "onPostId":1,
         "fromUserId":1,
         "created_at":"2017-05-26 09:41:16",
         "updated_at":null
         "commented_by":{  
               "id":1,
               "name":"parth",
               "email":"[email protected]",
               "password":"parth123456",
               "remember_token":"e1b28a30ab467c52924df64034c386d4",
               "created_at":null,
               "updated_at":null
             },
      },
      {  
         "id":5,
         "commentsText":"third one",
         "onPostId":1,
         "fromUserId":1,
         "created_at":"2017-05-26 09:41:43",
         "updated_at":null
         "commented_by":{  
               "id":1,
               "name":"parth",
               "email":"[email protected]",
               "password":"parth123456",
               "remember_token":"e1b28a30ab467c52924df64034c386d4",
               "created_at":null,
               "updated_at":null
             },
      }
   ]
}

So what exactly is the issue here?

Sandeesh
– Sandeesh

2017-05-26 14:30:43 +00:00
Commented May 26, 2017 at 14:30 — Sandeesh
– Sandeesh, Commented May 26, 2017 at 14:30
How to get "Commented_by" in comment array

Parth Bhatti
– Parth Bhatti

2017-05-26 15:42:35 +00:00
Commented May 26, 2017 at 15:42 — Parth Bhatti
– Parth Bhatti, Commented May 26, 2017 at 15:42
Added my answer. That should do what you need.

Sandeesh
– Sandeesh

2017-05-26 16:08:25 +00:00
Commented May 26, 2017 at 16:08 — Sandeesh
– Sandeesh, Commented May 26, 2017 at 16:08

Sandeesh · Accepted Answer · 2017-05-26 16:29:33Z

3

Based on your comment, just add the commentedBy relationship to your Member model and eager load it.

In Comment model.

public function commentedBy()
{
    return $this->belongsTo('App\Member', 'fromUserId', 'id');
}

Then eager load the relationship like so.

$posts = post::with('getUserDetails','getCommentDetails.commentedBy')->get();

edited May 26, 2017 at 16:29

answered May 26, 2017 at 16:07

Sandeesh

12k3 gold badges35 silver badges42 bronze badges

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

2 Comments

Parth Bhatti Over a year ago

But how i will call in this $posts=post::with('getUserDetails','getCommentDetails')->get();

Sandeesh Over a year ago

@ParthBhatti updated my answer with how to eager load.

Collectives™ on Stack Overflow

Get Nested json array of data Laravel Eloquent model with Relationship

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