Writing multiple where clause query using Eloquent-Laravel

When you want where clause on multiple  conditions and you are using Eloquent query builder  you can use the method given below.

$result=DB::table('users')->where(array(

'column1' => value1,

'column2' => value2,

'column3' => value3))

->get();

Another way is to  create scopes .

public function scopeActive($query)

{

    return $query->where('active', '=', 1);

}


public function scopeThat($query)

{

    return $query->where('that', '=', 1);

}

Then call the scopes as given below

$users = User::active()->that()->get();