/PHP/Laravel/Wherein laravel

Wherein laravel

Laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

7

Laravel wher in

$users = DB::table('users')
                    ->whereIn('id', [1, 2, 3])
                    ->get();

7

Wherein laravel

 DB::table('user')->whereIn('id', [100,200])->get();

2

Laravel DB wherein

Question::whereIn('id', $request)
            ->update(
                [
                    'status' => 1
                ]
            );

2

Laravel db::query update

 DB::table('user')->where('email', $userEmail)->update(array('member_type' => $plan));

0

Source: stackoverflow.com

Laravel whereIn example

public function index()
{
    $data= User::whereIn('name', ['john','dam','smith'])->get();
   
    dd($data);                    
}

0

Source: tutsmake.com

Similar codes

33 votes203 views6 answers
Laravel carbon
PHP Laravel
3 votes159 views2 answers
Laravel carbon created_at date in current month
PHP Laravel
12 votes141 views4 answers
Count in laravel'
PHP Laravel
8 votes143 views6 answers
Laravel collection unique
PHP Laravel
0 vote141 views1 answer
Laravel migrate error default character 199 boot
PHP Laravel
2 votes150 views3 answers
Laravel url with parameters blade
PHP Laravel
0 vote161 views6 answers
The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/7.3.28 Server at localhost Port 80 error in laravel
PHP Laravel
1 vote132 views1 answer
How to set a validation on a value if its not null in laravel php
PHP Laravel
4 votes350 views6 answers
Laravel jwt
PHP Laravel
-1 vote138 views1 answer
Clear Caching of Queries Laravel Specific Model Cache
PHP Laravel

Share