/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

0 vote178 views1 answer
Nova laravel image
PHP
0 vote165 views1 answer
How to extract code from controller to helpers or other method in laravel
PHP
0 vote156 views1 answer
Windows list registered applications
PHP
2 votes171 views3 answers
Write a php program to print hello world
PHP
1 vote199 views1 answer
Get random posts wordpress
PHP Wordpress
35 votes241 views6 answers
Php get current date and time
PHP
24 votes190 views2 answers
How to use join in laravel 5.4
PHP
7 votes238 views10 answers
Php .com
PHP
0 vote172 views1 answer
Drupal 9 select node data with query conditions using entity type manager
PHP
2 votes177 views2 answers
Image upload form
PHP