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 vote320 views1 answer
Invalid command 'php_value', perhaps misspelled or defined by a module not included in the server configuration
PHP
2 votes316 views1 answer
Delete confirmation destroy laravel
PHP
0 vote324 views1 answer
Php month single digit
PHP
0 vote322 views1 answer
Toggle switch php
PHP
0 vote306 views1 answer
Php round function syntax
PHP
1 vote343 views4 answers
Laravel get route path uri
PHP Laravel
26 votes366 views4 answers
Carbon date time laravel
PHP Laravel
11 votes368 views3 answers
Laravel get last month records
PHP Laravel
14 votes292 views6 answers
Wp enqueue style
PHP
2 votes345 views2 answers
“In fortify.php line 134:Class 'Laravel\Fortify\Features' not found ” Code Answer’s
PHP