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

1 vote317 views1 answer
Laravel order by raw
PHP Laravel
1 vote290 views1 answer
Laravel refresh server
PHP Laravel
0 vote292 views1 answer
Return view inside subfolder laravel
PHP Laravel
1 vote310 views1 answer
Laravel password verification
PHP Laravel
0 vote302 views1 answer
Laravel update all relations
PHP Laravel
2 votes308 views4 answers
Failed to clear cache. make sure you have the appropriate permissions. laravel
PHP Laravel
44 votes363 views2 answers
Laravel version command
PHP Laravel
18 votes264 views6 answers
Laravel model
PHP Laravel
0 vote219 views1 answer
Laravel foreach localstorage
PHP Laravel
0 vote275 views1 answer
Running laravel project in mobile phone
PHP Laravel