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

1 vote147 views1 answer
Laravel model find one
PHP Laravel
0 vote197 views1 answer
Add class to row laravel
PHP Laravel
2 votes196 views1 answer
Laravel get list of columns in a table
PHP Laravel
1 vote204 views2 answers
Laravel seconds to hours minutes seconds
PHP Laravel
0 vote243 views1 answer
Count column eloquent laravel
PHP Laravel
8 votes198 views3 answers
Laravel model::query
PHP Laravel
0 vote218 views1 answer
Laravel 5.7
PHP Laravel
0 vote194 views1 answer
Laravel validation unique if this field is changed
PHP Laravel
1 vote190 views1 answer
Laravel active route check
PHP Laravel
1 vote199 views1 answer
Laravel get class name
PHP Laravel