/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

0 vote221 views2 answers
Sage theme
PHP
4 votes262 views2 answers
Php xml to array
PHP
101 votes264 views6 answers
Php array append
PHP
0 vote236 views2 answers
Php.ini path
PHP
0 vote195 views1 answer
Php set int
PHP
0 vote239 views1 answer
Create fake users on click laravel
PHP
0 vote225 views1 answer
Magento 1.9 get all product
PHP
-1 vote326 views2 answers
Send email php form
PHP
2 votes250 views2 answers
Update kali
PHP
0 vote340 views1 answer
Définir un nombre maximum de mots sur les titres des publications WordPress
PHP Wordpress