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 vote136 views1 answer
Seprate day and year from laravel to timestamp
PHP Laravel
1 vote125 views1 answer
Laravel bindings query
PHP Laravel
0 vote131 views1 answer
Dump die laravel
PHP Laravel
0 vote137 views1 answer
Laravel seeding with relationships
PHP Laravel
3 votes168 views3 answers
Laravel carbon count days between dates
PHP Laravel
0 vote137 views1 answer
Cout post on category in controller laravel
PHP Laravel
0 vote130 views1 answer
Display picture in pdf generated with laravel
PHP Laravel
0 vote126 views1 answer
Field doesn't have default value laravel
PHP Laravel
0 vote127 views1 answer
Laravel faker generate country code
PHP Laravel
1 vote123 views3 answers
Laravel eloquent bulk insert
PHP Laravel