How to get products from a category?

Question

Laravel

I have three tables: product - products, catalog - product categories, product_catalog - table combining products and categories.
Tell me, how can I get products in the category I have chosen on laravel?

Answer 1

In product, records have a field, what category do they belong to?
If not, then do it.

Answer 2

You need to use belongsToMany documentation

Answer 3

Let's use relationships. Add a method to the Category model:

public function products()
{
    return $this->belongsToMany(Prdouct::class, 'product_catalog', 'category_id', 'product_id', 'id');
}

Where Product is the product model. 'product_catalog' - the so-called pivot table (a table combining products and categories). 'product_id' - product id in the pivot table, 'category_id' - category id in the pivot table.
Thus, you will be able to receive products belonging to a specific category like this:
Categoty::find(1)->products;