Laravel where and where

Laravel orWhere

$camps = $field->camps()->where('status', 0)->where(function ($q) {
    $q->where('sex', Auth::user()->sex)->orWhere('sex', 0);
})->get();

Source: laracasts.com

Where with and and or in a laravel

        $users = DB::table('user')->select('id', 'name', 'email','api_token','created_at')
                                  ->where('email' , $email)
                                  ->where('name' , $name)
                                  ->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 where in

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

Laravel where and where

Table::where('Column', Value)->where('NewColumn', Value)->get();

Source: laracasts.com

Similar codes

5 votes223 views2 answers
Laravel groupby and latest
PHP Laravel
-1 vote165 views1 answer
Validate rule if row exist laravel
PHP Laravel
9 votes210 views4 answers
Laravel time format
PHP Laravel
4 votes212 views5 answers
Laravel array_pluck
PHP Laravel
0 vote243 views1 answer
Combine 2 columns search query laravel
PHP Laravel
0 vote211 views1 answer
How to disable auto prediction html input in laravel
PHP Laravel
19 votes222 views4 answers
Laravel bootstrap auth
PHP Laravel
25 votes224 views4 answers
ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel
PHP Laravel
0 vote247 views1 answer
Centos 8 laravel permission denied
PHP Laravel
0 vote220 views1 answer
Laravel get data from model to controller
PHP Laravel