/PHP/Laravel where condition on relationship

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

22 votes120 views6 answers
Strtoupper in php
PHP
0 vote124 views1 answer
Comparing floats php
PHP
8 votes174 views5 answers
Laravel route is current route
PHP Laravel
0 vote136 views1 answer
Server error in laravel
PHP
2 votes141 views2 answers
Laravel get public path url
PHP Laravel
0 vote118 views2 answers
Yii1 refresh cache schema
PHP
0 vote172 views4 answers
Sweetalert laravel
PHP Laravel
40 votes119 views2 answers
$dom->getElementById
PHP
0 vote228 views1 answer
How to use “find_in_set” in cakephp 3 find method
PHP CakePHP
15 votes137 views4 answers
Change existing migration laravel
PHP Laravel