Laravel how to loop through array in controller and combine relationship

Question

In my laravel-application I have a blogs- and an author-table. On the index page, where you see all published blog posts, I want the authors name to appear. So I tried to do this:

public function index()
{

    $blogs = Blog::where("publishes_on", "<=", Carbon::now())
        ->orderBy('publishes_on', 'desc')
        ->published()
        ->get();

    foreach ($blogs as $blog) {
        $author = Author::where('id', $blog->author_id)->get();
    }

    return view('app.blog.index', compact('blogs', 'author'));
}

For some reason I do not know, this gives me the last added author to my application and on each post, the name of that author is displayed on all posts.

What am I doing wrong here?

You have to wire a Blog belongs to Author relationship and get the author`s details via that relationship — Flash
– Flash, Commented Sep 16, 2019 at 12:14

Davit Zeynalyan · Accepted Answer · 2019-09-16 12:25:44Z

4

In Blog model add author relation

public function author()
{
   return $this->belongsTo(Author::class);
}

In controller

$blogs = Blog::where("publishes_on", "<=", Carbon::now())
    ->orderBy('publishes_on', 'desc')
    ->published()
    ->with('author:id,name')
    ->get();

In view you can use

@foreach($blogs  as $blog)
    // blog related data 
    Author: {{ $blog->author->name ?? '' }}
@endforeach

edited Sep 16, 2019 at 12:25

answered Sep 16, 2019 at 12:16

Davit Zeynalyan

8,6485 gold badges33 silver badges57 bronze badges

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

2 Comments

Salim Djerbouh Over a year ago

Add the belongsTo relationship in the Blog model, just in case OP's missing that

ST80 Over a year ago

This is awesome! Thanks a lot!! :-)

tanerkay · Accepted Answer · 2019-09-16 12:19:59Z

2

No need for the foreach loop

Blog::with('author')->where( [...]`

In your view

$blog->author->name

Make sure you define author() as a relationship on the Blog model:
https://laravel.com/docs/master/eloquent-relationships

e.g.

class Blog {
    function author(){
        return $this->belongsTo(Author::class);
    }
}

edited Sep 16, 2019 at 12:19

answered Sep 16, 2019 at 12:14

tanerkay

3,9491 gold badge21 silver badges28 bronze badges

1 Comment

ST80 Over a year ago

This is a nice answer too!

Collectives™ on Stack Overflow

Laravel how to loop through array in controller and combine relationship

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