Laravel where closure

Laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

Laravel where closure

$externalValue = "User";
$users = User::where(function ($query) use($externalValue) {
            return $query->where('type','Admin')->orWhere('type',$externalValue);
        })->where("role",1)->get();

DB::table('users')->get();

DB::table('users')->where('name', Input::get('name'))->get();

Source: stackoverflow.com

Similar codes

0 vote330 views1 answer
Laravelstart project
PHP Laravel
0 vote307 views1 answer
Laravel count group by date
PHP Laravel
18 votes289 views5 answers
If statement in laravel blade
PHP Laravel
12 votes306 views6 answers
Laravel redirect back with input
PHP Laravel
0 vote306 views1 answer
Laravel many to many migration
PHP Laravel
0 vote293 views1 answer
Laravel form validation based on another field value
PHP Laravel
31 votes290 views2 answers
Laravel sample controller
PHP Laravel
0 vote303 views1 answer
Laravel Secured Password
PHP Laravel
3 votes301 views2 answers
Current user laravel
PHP Laravel
3 votes274 views2 answers
Using laravel back function on blade
PHP Laravel