Eloquent relationships question (whereHas)

Hi friends,

how can I pass a param to the where inside the function?

public function getPostTags($tag_id = null)
{
    return \App\Post::whereHas('post_tags', function ($query){
        $query->where('post_tags.tag_id', '=', $tag_id);
    })->get();
}

I have the table "Post" with a list of posts and the table"Post_tags" which relation the "posts" with "tags" (post_id, tag_id). Then I want to get the posts with a concret tag_id.

Lina

8 years ago

Best Answer

Level 1

[Solved] Thanks to: https://laracasts.com/discuss/channels/eloquent/wherehas-relationship-getting-the-latest-row-but-want-to-do-a-where-on-this-result

public function getPostTags($tag_id = null)
{
    return \App\Post::whereHas('post_tags', function ($query) use ($tag_id){
        $query->where('post_tags.tag_id', '=', $tag_id);
    })->get();
}

2 likes

Please or to participate in this conversation.