/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

15 votes167 views4 answers
One lin if statement php
PHP
2 votes163 views1 answer
A complete piece of nice and clear PHP code returning JSON
PHP
0 vote196 views1 answer
Laravel get all old input
PHP Laravel
3 votes164 views1 answer
Wordpress get domain
PHP Wordpress
3 votes162 views3 answers
Convert stdclass object to array php
PHP
19 votes162 views6 answers
Php sort array by specific key
PHP
17 votes151 views3 answers
Show alert in php
PHP
0 vote190 views1 answer
Php flatten multidimensional array
PHP
2 votes177 views2 answers
Wordpress functions add to header
PHP Wordpress
0 vote175 views1 answer
Laravel run seeder enter timestamps
PHP Laravel