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

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
elder care
Health

Understanding the Costs of Elder Care: Budgeting Tips and Considerations

Read More
Posted On