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

4 votes144 views2 answers
Laravel reduce
PHP Laravel
11 votes139 views4 answers
Redirect back with input laravel in request
PHP Laravel
23 votes149 views6 answers
Updateorcreate laravel
PHP Laravel
25 votes171 views6 answers
Laravel where
PHP Laravel
2 votes147 views2 answers
Laravel insert timestamp now
PHP Laravel
2 votes149 views1 answer
Laravel where update query
PHP Laravel
1 vote146 views1 answer
Laravel get class name
PHP Laravel
0 vote144 views1 answer
Laravel eloquent return array where
PHP Laravel
1 vote98 views1 answer
Laravel model find one
PHP Laravel
0 vote135 views2 answers
Laravel PackageManifest.php: Undefined index: name
PHP Laravel