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 vote169 views1 answer
Split 10 email out of 50 email using coma separated via php
PHP
0 vote175 views1 answer
In Connection.php line 664:SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema
PHP
3 votes169 views4 answers
Magento Fatal error: Allowed memory size of 134217728 bytes exhausted
PHP
2 votes229 views1 answer
Foreign key constraint is incorrectly formed laravel
PHP Laravel
0 vote339 views1 answer
Show sender name laravel
PHP Laravel
4 votes243 views2 answers
Laravel get authorization bearer token
PHP Laravel
3 votes180 views1 answer
Phpcs
PHP
2 votes147 views1 answer
Live update mysql data in php
PHP
12 votes171 views3 answers
Get featured image url
PHP
1 vote259 views2 answers
Add filter in wordpress
PHP Wordpress