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 vote278 views1 answer
Laravel set field unique
PHP Laravel
0 vote275 views1 answer
Laravel datatable render html
PHP Laravel
0 vote304 views1 answer
Url() inside laravel config files
PHP Laravel
1 vote303 views2 answers
Many to many relationship laravel example
PHP Laravel
0 vote288 views1 answer
Excel return integer from date column laravel
PHP Laravel
0 vote238 views1 answer
Withsuccess laravel 8
PHP Laravel
0 vote279 views1 answer
Laravel vu3
PHP Laravel
0 vote268 views1 answer
WhereJsonContains laravel
PHP Laravel
0 vote280 views2 answers
Adminlte con laravel 8
PHP Laravel
0 vote271 views1 answer
Laravel looping checking if last record has reached
PHP Laravel