/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

4 votes178 views1 answer
Wp enqueue
PHP Wordpress
1 vote163 views1 answer
How to check leap year in php?
PHP
0 vote164 views1 answer
Php remove dashes from string
PHP
0 vote170 views1 answer
Your movie name -inurl:(htm|html|php|txt) intitle:index.of "last modified" (mp4|mkv|wmv|avi|webm)
PHP
0 vote179 views2 answers
Php version command linux
PHP
0 vote154 views1 answer
Laravel - Query Builder Raw Query selectRaw
PHP
55 votes183 views6 answers
Php time format
PHP
0 vote183 views1 answer
Start day picker and end date picker in php
PHP
0 vote158 views1 answer
Laravel require vendor autoload
PHP
9 votes180 views6 answers
Pluck laravel
PHP Laravel