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 vote173 views1 answer
Get words after string in in php
PHP
0 vote257 views1 answer
Laravel deploy without moving public directory
PHP Laravel
2 votes209 views1 answer
Laravel https assets
PHP
0 vote223 views1 answer
DB::statement('SET GLOBAL group_concat_max_len =
PHP
8 votes208 views3 answers
Check for an existing user laravel eloquent
PHP Laravel
1 vote183 views1 answer
Php number format spaces
PHP
0 vote183 views1 answer
Wp wc php out of stock product to bottom
PHP
0 vote215 views2 answers
Access paginator object attribute in laravel
PHP Laravel
0 vote219 views1 answer
Ver version de php en linux
PHP
0 vote202 views1 answer
Fixing unclosed html tags
PHP