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

What You Need to Know About IGI vs GIA Lab Grown Diamonds
jewellery

What You Need to Know About IGI vs GIA Lab Grown Diamonds

Read More
Posted On
Lab Grown Diamonds
jewellery

The 4Cs of Lab Grown Diamonds: Understanding the Essential Elements

Read More
Posted On
Diamond Shapes
jewellery

Understanding Different Diamond Shapes: A Guide to Choosing the Perfect Cut

Read More
Posted On
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