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();

了解查询关系

当然，您需要配置具有categories关系的Product模型.

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

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