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

13 votes142 views6 answers
How to create model in laravel
PHP Laravel
1 vote142 views2 answers
Re migrate laravel
PHP Laravel
0 vote128 views1 answer
Post request data not getting from guzzle laravel
PHP Laravel
34 votes123 views6 answers
Laravel create controller with methods
PHP Laravel
0 vote129 views1 answer
Laravel media library regenerate
PHP Laravel
2 votes116 views3 answers
Laravel subdays
PHP Laravel
1 vote124 views2 answers
Laravel throttle
PHP Laravel
1 vote79 views1 answer
Redirect from laravel controller to another link
PHP Laravel
51 votes176 views6 answers
Laravel run all seeders
PHP Laravel
0 vote154 views1 answer
Onclick call route laravel
PHP Laravel