Join two tables in Laravel

Question

I am very new to Laravel and here I have one simple question. I need to join one more table to the following

   return $products = Product::where('product_type_id', 1)
                            ->where('quantity', '>=', 50)
                             ->where('deleted', 0)
                            ->orderBy('price')
                            ->paginate(100);

I have another table name product_img where all the images of products are stored. Need to fetch all the records where product id is available in product_img table and where file is not equal to 'Noimg.jpg'. I tried different solutions but didn't worked. How to join two tables in Laravel?

I tried to do the following:

$products = Product::leftJoin('product_img', function($join) {
                                $join->on('products.id', '=', 'product_img.product_id')
                                ->where('product_img.file', '!=', 'Noimg.jpg');
                             }) ;
                                ->where('quantity', '>=', 100)
                                ->where('deleted', 0)
                                ->orderBy('price')
                                ->paginate(100);

replace leftJoin with join method.

Jinal Somaiya
– Jinal Somaiya

2019-12-11 11:37:27 +00:00
Commented Dec 11, 2019 at 11:37 — Jinal Somaiya
– Jinal Somaiya, Commented Dec 11, 2019 at 11:37

BInjal Patel · Accepted Answer · 2019-12-11 11:49:58Z

1

$products = Product::join('product_img', 'products.id', '=', 'product_img.product_id')
                                ->where('product_img.file', '!=', 'Noimg.jpg')
                                ->where('quantity', '>=', 100)
                                ->where('deleted', 0)
                                ->orderBy('price')
                                ->paginate(100);

answered Dec 11, 2019 at 11:49

BInjal Patel

3313 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bello Muktar · Accepted Answer · 2019-12-11 11:50:32Z

0

The correct symbol for Not Equal is <> in SQL, and != is for programming languages.

 $products = Product::join('product_img', function($join) {
                                $join->on('products.id', '=', 'product_img.product_id')
                                ->where('product_img.file', '<>', 'Noimg.jpg');
                             }) ;
                                ->where('quantity', '>=', 100)
                                ->where('deleted', 0)
                                ->orderBy('price')
                                ->paginate(100);

answered Dec 11, 2019 at 11:50

Bello Muktar

263 bronze badges

3 Comments

Akaash K Over a year ago

query worked but products are listing where records with Noimg.jpg or where records are not in the image table

Akaash K Over a year ago

I need to run this query in Laravel -> SELECT a.* FROM products as a JOIN product_img b ON a.id = b.product_id WHERE b.product_id = a.id AND b.file!='Noimg.jpg' GROUP BY id DESC ORDER BY created_at DESC

Akaash K Over a year ago

yes, It didn't worked.. Actually what I am getting in the raw query Is not what I am getting when I run the code

Collectives™ on Stack Overflow

Join two tables in Laravel

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related