/PHP/Laravel adding condition to relation

Laravel adding condition to relation

Laravel where condition on relationship

App\Request::where('id',4)
    ->whereHas('quotes', function ($query) {
        $query->where('status','=','3');
    })
    ->with('quotes','sourceTable','destinationTable')
    ->get();

Source: laracasts.com

Laravel adding condition to relation

class Game extends Eloquent {
    // many more stuff here

    // relation without any constraints ...works fine 
    public function videos() {
        return $this->hasMany('Video');
    }

    // results in a "problem", se examples below
    public function available_videos() {
        return $this->videos()->where('available','=', 1)->get();
    }
}

Source: stackoverflow.com

Similar codes

15 votes213 views3 answers
Php sort array of array by key
PHP
0 vote176 views1 answer
Laravel/framework[v7.29.0, ..., 7.x-dev] require ext-mbstring * -> it is missing from your system. Install or enable PHP's mbstring extension.
PHP Laravel
14 votes168 views6 answers
How to install laravel
PHP Laravel
63 votes342 views6 answers
Laravel artisan clear cache
PHP Laravel
0 vote130 views1 answer
Php clone datetime
PHP
1 vote193 views2 answers
Return response at failedValidation() in request laravel
PHP Laravel
0 vote151 views1 answer
Alert in php after header location
PHP
0 vote244 views1 answer
Php list all constants
PHP
0 vote137 views1 answer
The last ship -inurl:(htm/html/php/pls/txt) intitle:index.of "last modified" (mp4/wma/aac/avi)
PHP
2 votes144 views2 answers
Validator number laravel
PHP