Laravel 查询多对多

2021-12-26 00:00:00 php laravel laravel-5 eloquent

我需要帮助.我有 2 个表 products 和 categories:

I need help.I have 2 tables products and categories:

获取请求发送类别 ID.我的问题是:如何使用产品模型构建查询???(查询看起来像这样:输出类别 id 等于 $ request-> category 的产品).表连接配置好了，我只需要查询，(我看了文档，但没看懂)

Get request sends category id. My question is: how to build a query using the product model??? (The query looks like this: Output the product where the category id is equal to $ request-> category). Table connections are configured, I only need the query, (I read the documentation, but do not not understand it)

推荐答案

您可以使用:

$products = Product::whereHas('categories', function($q) use ($categoryId) {
   $q->where('id', $categoryId);
})->get();

阅读查询关系

当然你需要配置Product模型和categories关系.

Of course you need to have configured Product model with categories relationship.

相关文章