Laravel雄辩筛选由关系列 [英] Laravel Eloquent Filter By Column of Relationship
本文介绍了Laravel雄辩筛选由关系列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
使用雄辩的ORM我的模型设置如下: Post
belongsToMany
类别
Post.php
public function categories()
{
return $ this-> belongsToMany('Category','posts_categories');
}
我想按类别关系的列过滤帖子。 >
所以我想做一些像:
$ posts-> where ('categories.slug','=',Input :: get('category_slug'));
这不行。
我还试过:
$ with ['categories'] = function($ query){
$ query- > where('slug','=',Input :: get('category_slug'));
};
$ posts :: with($ with) - > get();
但是我想,这是为了过滤不按类别过滤的类别。
任何人都可以显示我的方式?
解决方案
我现在无法访问我的Vagrant框,但我相信这应该工作:
$ posts = Post :: whereHas('categories',function($ q)
{
$ q-> where('slug','=',Input :: get('category_slug'));
}) - > get() ;
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'));
This doesn't work though.
I also tried:
$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.
Can anyone show me the way?
解决方案
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雄辩筛选由关系列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文