How in laravel eloquent make query with multiple 'and'?

Question

I have this query :

SELECT * 
FROM `groups` 
WHERE `status` = 1 
    AND `active` != 1 
    AND (`approved` != 1 OR `approved` IS NULL)

And I try this in query builder but don't know how to make it properly

Here is my query builder :

Group::where([['status', '=', 1], ['active', '!=', 1]])
    ->where([['approved', '!=', 1]])
    ->orWhereNull()
    ->get();

Possible duplicate of Laravel 5.0 Query Builder - Where with multiple parameters — Walter Cejas
– Walter Cejas, Commented Dec 11, 2018 at 14:55

IndianCoding · Accepted Answer · 2018-12-11 13:38:57Z

3

You should use where with Closure to group params. https://laravel.com/docs/5.7/queries#parameter-grouping

$data = Group::where(function($query){
        $query
            ->where('approved', '!=', 1)
            ->orWhereNull('approved');
    })
    ->where('status', 1)
    ->where('active', '!=', 1)
    ->get();

answered Dec 11, 2018 at 13:38

IndianCoding

2,6831 gold badge9 silver badges13 bronze badges

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

Comments

Maxime · Accepted Answer · 2018-12-11 13:37:54Z

0

You can try something like:

$articles = \App\Article::where('foo', 'bar')
    ->where('color', 'blue')
    ->orWhere('name', 'like', '%John%')
    ->whereIn('id', [1, 2, 3, 4, 5])
    ->get();

edited Dec 11, 2018 at 13:37

Maxime

9,0595 gold badges53 silver badges54 bronze badges

answered Dec 11, 2018 at 13:35

Ivheror

173 bronze badges

1 Comment

domagoj Over a year ago

Doesn't seem enough to help the author. If he already gave you an example of the code he has, try to work on that and see how you could improve it.

Jignesh Joisar · Accepted Answer · 2018-12-11 13:41:16Z

0

try this one

 Group::where('status', 1)
    ->where('active', '!=', 1)
    ->where(function($query){
       $query->where('approved', '!=', 1)
            ->orWhereNull('approved')
    })->get();

use where in closure in laravel see

answered Dec 11, 2018 at 13:41

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

Comments

Kusy · Accepted Answer · 2018-12-11 13:41:19Z

0

try this

Group::where('status', 1)->where('active', '!=', 1)->where('approved', '!=', 1)
->orWhere('status', 1)->where('active', '!=', 1)->where('approved', NULL)
->get();

or

$x = Group::where(function($q){
        $q->where('approved', '!=', 1)
          ->orWhereNull('approved')
        })
           ->where('status', 1)->where('active', '!=', 1)
           ->get();

answered Dec 11, 2018 at 13:41

Kusy

2381 silver badge12 bronze badges

Collectives™ on Stack Overflow

How in laravel eloquent make query with multiple 'and'?

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related