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 vote280 views1 answer
Laravel notification attach file
PHP
-2 votes319 views4 answers
Laravel get ID from insert
PHP
3 votes270 views1 answer
Laravel validation greater than or equal to
PHP
0 vote294 views1 answer
Create fake users on click laravel
PHP
0 vote289 views1 answer
If name value contains space in php
PHP
35 votes278 views6 answers
Php format date
PHP
2 votes290 views2 answers
Wordpress theme The link you followed has expired.
PHP
0 vote271 views1 answer
Wp-admin File not found (404 error)
PHP
1 vote325 views2 answers
Carbon date minus days
PHP
0 vote342 views1 answer
Laravel blade php variable concatenate javascript variable
PHP Laravel