/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

4 votes127 views2 answers
Numbric validate laravel
PHP Laravel
3 votes133 views1 answer
Get soft deleted data laravel
PHP Laravel
0 vote131 views2 answers
Laravel permission to vuejs
PHP Laravel
0 vote137 views1 answer
Set custome table laravel eloquent
PHP Laravel
1 vote122 views1 answer
How to catch query exception in laravel 8
PHP Laravel
0 vote128 views1 answer
Show images laravel 8 showJobImage($filename)
PHP Laravel
1 vote153 views1 answer
Laravel api form request validation 404
PHP Laravel
1 vote134 views2 answers
Htaccess redirect https laravel
PHP Laravel
0 vote129 views1 answer
Determining if input is present in Laravel
PHP Laravel
0 vote126 views1 answer
Howw to see if a value is posted laravel
PHP Laravel

Share