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 vote179 views1 answer
Php array viewer
PHP
0 vote182 views1 answer
Php mail if successful
PHP
1 vote257 views3 answers
Symfony datetime now
PHP Symfony
20 votes176 views6 answers
Print array php
PHP
20 votes198 views3 answers
Php check if file exists
PHP
0 vote182 views1 answer
Php count word arabic
PHP
32 votes204 views6 answers
Php for loop
PHP
0 vote183 views1 answer
Return single row from eloquent all collection laravel
PHP
0 vote181 views1 answer
Php throw exception get message
PHP
0 vote227 views1 answer
Wordpresss loop through object
PHP Wordpress