Where clause in laravel

Laravel not in query

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

Laravel wher in

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

Wherein laravel

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

Laravel with and where

$projects = Project::whereHas('projectOffers', function ($offer) {
            $offer->where('teacher_id', "Ahmed");
            $offer->where('status_id', "Accepted");
        })->where('status_id', "inprogress")->get();

Where clause in laravel

        $users = DB::table('user')->select('id', 'name', 'email','api_token','created_at')->where('email' , $email)->get();
        return response()->json($users);

Laravel db::query update

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

Source: stackoverflow.com

Similar codes

1 vote199 views1 answer
How to return with open model popup in laravel
PHP Laravel
0 vote179 views1 answer
Laravel role
PHP Laravel
12 votes298 views6 answers
Email validation in laravel
PHP Laravel
0 vote198 views1 answer
Create table laravel give name table
PHP Laravel
2 votes227 views2 answers
Laravel read json file from storage
PHP Laravel
10 votes197 views2 answers
Laravel route list
PHP Laravel
11 votes170 views2 answers
How login one user with id in laravel
PHP Laravel
0 vote220 views2 answers
Laravel login register api
PHP Laravel
0 vote190 views1 answer
Use id as key in co;lection laravel
PHP Laravel
1 vote184 views2 answers
How set field after another field in migration in laravel
PHP Laravel