Laravel 查询多对多 [英] Laravel query many to Many

问题描述

我需要帮助.我有 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.

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