Eloquent Laravel Where And Or And

Question

I would like to make Sql request like this :

Get the ((Age > 10 AND Weight > 50) OR Name = Jack) AND Actif = 1

My Eloquent request look like this :

$user = DB::table('users')
    ->where('Age', '>=', 10)
    ->where('Weight', '>=', 50)
    ->orWhere('Name', 'Jack')
    ->where('Actif', 1)
    ->get();

But actually it will return the result Jack although this column Actif is set to 0.

num8er · Accepted Answer · 2016-03-18 13:38:26Z

5

If we look at nesting of where part so it will be like this:

$sites = DB::table('users')
    ->where(function($q) {                       // (
      $q->where(function($q){                    //   (
             $q->where('Age', '>=', 10)          //     Age > 10
               ->where('Weight', '>=', 50);      //     AND Weight > 50
        })                                       //   )
        ->orWhere('Name', 'Jack');               //   OR Name = Jack
    })                                           // )
    ->where('Actif', 1)                          // AND Actif = 1
    ->get();

edited Mar 18, 2016 at 13:38

answered Mar 18, 2016 at 13:27

num8er

19.5k4 gold badges50 silver badges61 bronze badges

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

Collectives™ on Stack Overflow

Eloquent Laravel Where And Or And

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related