Laravel Eloquent 按关系列过滤 [英] Laravel Eloquent Filter By Column of Relationship

问题描述

使用 Eloquent ORM 我的模型设置如下:Post belongsToMany Category

Using the Eloquent ORM I have my models set up like so: Post belongsToMany Category

Post.php

public function categories()
{
    return $this->belongsToMany('Category', 'posts_categories');
}

我想按类别关系的列过滤帖子.

I want to filter posts by a column of the categories relationship.

所以我想做类似的事情:

So I want to do something like:

$posts->where('categories.slug', '=', Input::get('category_slug'));

但这不起作用.

我也试过:

$with['categories'] = function($query){ 
    $query->where('slug', '=', Input::get('category_slug'));
};

$posts::with($with)->get();

但我认为这是过滤类别而不是按类别过滤.

But I thnk that's for filtering the categories not filtering BY the category.

谁能给我指路?

推荐答案

我现在无法访问我的 Vagrant box，但我相信这应该可行:

I can't access my Vagrant box right now, but I believe this should work:

$posts = Post::whereHas('categories', function($q)
{
    $q->where('slug', '=', Input::get('category_slug'));

})->get();

这篇关于Laravel Eloquent 按关系列过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！