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

During Capsule
more

Common Problems During Capsule Production and Their Solutions 

Read More
Posted On
Reliable Medical Tubing
more

Material Decisions Behind Reliable Medical Tubing

Read More
Posted On
The Link Between Creativity and Mental Health
Health

The Link Between Creativity and Mental Health

Read More
Posted On
Gaming Strategies for a Better Online Experience
more

Gaming Strategies for a Better Online Experience

Read More
Posted On
Calcium Carbide Supply
more

Quality, Safety, and Reliability in Calcium Carbide Supply

Read More
Posted On