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

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
Top Conversation Starters That Work on Tinder
more

Top Conversation Starters That Work on Tinder

Read More
Posted On
Novita and Dress for Success: Lab-Created Diamonds
Business

Novita and Dress for Success: Lab-Created Diamonds

Read More
Posted On
lab created diamonds
jewellery

Engineered Precious stone Hoops: The Ascent of Lab Created Diamonds

Read More
Posted On