more

How do I make a selection from two related tables?

Posted On
Posted By Layla Brooks

I have a table with products, relation to the tables of categories and collections as many to many. I need to make a selection by category and collection so that I get the products that are included there

I have written some selection, but it does not take into account that the products are related with collections and categories.

$filter_collections = [1, 3];
$filter_categories = [2, 5];


$products = Product::whereHas('collection', function ($query) use ($filter_collections) {
                $query->whereIn('collection_id', $filter_collections);
            })->whereHas('category', function ($query) use ($filter_categories) {
                $query->whereIn('category_id', $filter_categories);
            })->get();

How do I make the selected products belong to the specified categories and collections?

Related Post

Latest Post

Dress Rings
jewellery

The Elegance of Lab Grown Diamonds in Dress Rings

Read More
Posted On
Man Made Diamonds
more

Loose Man Made Diamonds: A Top to bottom Manual for Lab Diamonds

Read More
Posted On
Lab Diamond Rings: The Smart Choice for Modern Jewelry
Business

Lab Diamond Rings: The Smart Choice for Modern Jewelry

Read More
Posted On
Regular
more

Toi et Moi: The Allure of Man-Made Diamonds

Read More
Posted On
PAFI Kota Solok
Health

The Visionary Efforts of PAFI Kota Solok: Shaping a Better Future

Read More
Posted On