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

0 vote105 views1 answer
Laravel has one of many relationship
PHP
0 vote129 views1 answer
If condition view page of laravel
PHP Laravel
18 votes103 views5 answers
Create model, controller and migration in single command laravel
PHP
0 vote104 views1 answer
Nano seed generator
PHP
0 vote115 views1 answer
How to get shop page url in wordpress
PHP Wordpress
49 votes185 views6 answers
Laravel clear all cache
PHP Laravel
12 votes116 views6 answers
Run seeder in migration laravel
PHP Laravel
0 vote98 views3 answers
Php to call javascript function
PHP
0 vote107 views1 answer
Php include inside function global
PHP
3 votes140 views6 answers
Laravel find query
PHP Laravel