Laravel DB Query : Get One to Many Multidimentional Array Result

Question

I'm new to Laravel, let me straight forward to the question.

Suppose I have 'Posts' table and 'Comments' table

And the first 'Post' has 3 comments,

What is the best query method to achieve this kind of result

Post => (
   [0]=> array (
      [id]=>1
      [content]=> This is my first Post!
      [comments]=> array(
         [0]=>array(
            [id]=>1
            [post_id]=>1
            [content]=> First comment!
         )

         [1]=>array(
            [id]=>2
            [post_id]=>1
            [content]=> Second comment!
         )

         [2]=>array(
            [id]=>3
            [post_id]=>1
            [content]=> Third comment!
         )


      )
   )
)

Alexey Mezenin · Accepted Answer · 2017-03-27 15:08:18Z

1

Eager load the relationship:

$posts = Post::with('comments')->get()->toArray();

answered Mar 27, 2017 at 15:08

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

2 Comments

Angger Over a year ago

Mazenin : please help :(

Alexey Mezenin Over a year ago

@Angger you need to define hasMany() relationship first to make it work.

user6705732 · Accepted Answer · 2017-03-27 15:08:02Z

0

You can use Eloquent relationships. https://laravel.com/docs/5.4/eloquent-relationships#one-to-many.

The example is exactly what you're looking for! (:

answered Mar 27, 2017 at 15:08

user6705732

1 Comment

Angger Over a year ago

No, It only return comments values

Collectives™ on Stack Overflow

Laravel DB Query : Get One to Many Multidimentional Array Result

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related