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 vote164 views2 answers
Collection get first element laravel
PHP
0 vote178 views1 answer
Form validation nullable laravel
PHP
1 vote182 views1 answer
Sort relation model count yii2
PHP
0 vote173 views1 answer
Best documentation tools for php
PHP
0 vote197 views1 answer
Laravel collection mode
PHP Laravel
2 votes155 views2 answers
Get php memory limit command line
PHP
0 vote188 views1 answer
Taxonomy_get_parents drupal 8
PHP
0 vote183 views3 answers
Hide wordpress errors
PHP Wordpress
2 votes218 views1 answer
Laravel vendor:publish not working
PHP
0 vote157 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP