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

0 vote195 views1 answer
Laravel validation get failed rules
PHP Laravel
-1 vote179 views1 answer
Check request method laravel
PHP Laravel
0 vote216 views1 answer
Check array is associative laravel
PHP Laravel
3 votes208 views1 answer
Laravel throw function
PHP Laravel
0 vote203 views1 answer
Request update password laravel
PHP Laravel
8 votes214 views5 answers
Laravel belongs to
PHP Laravel
0 vote244 views1 answer
Deleting all files inside a directory laravel 8
PHP Laravel
0 vote256 views1 answer
Compiling multiple CSS into ONE CSS with Laravel MIX
PHP Laravel
26 votes218 views6 answers
Laravel migration rollback
PHP Laravel
24 votes213 views6 answers
Laravel create method
PHP Laravel