/PHP/Laravel/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

-1 vote125 views4 answers
Include blade file in laravel
PHP Laravel
0 vote213 views1 answer
Laravel get old url
PHP Laravel
9 votes148 views4 answers
Convert laravel hash password online
PHP Laravel
0 vote127 views1 answer
Laravel fetch max value
PHP Laravel
1 vote141 views1 answer
[InvalidArgumentException] Could not find package laravel/laravel with version 7.0 in a version installable using your PHP version, PHP extensions and Composer version.
PHP Laravel
6 votes130 views2 answers
WhereHas site:https://laravel.com/docs/
PHP Laravel
0 vote129 views1 answer
Laravel $browser->keys alt click
PHP Laravel
0 vote137 views1 answer
Laravel find model inside the same model
PHP Laravel
38 votes188 views6 answers
Laravel foreign key
PHP Laravel
10 votes136 views2 answers
Get current date laravel
PHP Laravel