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 vote226 views1 answer
Trying to access variable outside laravel collection
PHP Laravel
0 vote216 views1 answer
Csv file import to mysqli using php
PHP
0 vote212 views1 answer
Css adding corner
PHP
0 vote203 views1 answer
Spatie/laravel-health
PHP
0 vote247 views1 answer
Laravel make directory if not exists
PHP Laravel
0 vote260 views1 answer
Count array index foreach in php
PHP
2 votes193 views3 answers
Laravel get file size uploaded
PHP
0 vote196 views1 answer
Twig get array key name
PHP
0 vote197 views1 answer
Javascript date to php date
PHP
1 vote301 views1 answer
Wordpress image text acf
PHP Wordpress