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

3 votes192 views2 answers
Spaceship operator
PHP
7 votes192 views1 answer
Php uppercase each word
PHP
0 vote210 views1 answer
Refresh web route laravel
PHP Laravel
5 votes196 views2 answers
Set unique value validation for laravel form request
PHP
13 votes224 views5 answers
Laravel get last record
PHP Laravel
0 vote182 views1 answer
Retirrar ultimo caracter php
PHP
0 vote210 views1 answer
How to create pdf with doompdf in php
PHP
61 votes197 views6 answers
Cache clear in laravel
PHP
11 votes175 views3 answers
How to make validate error when password doesnt match with password confirm laravel
PHP
1 vote179 views1 answer
Remove item from collection
PHP