Eloquent where condition based on a "belongs to" relationship

Question

Let's say I have the following model:

class Movie extends Eloquent {     public function director()     {         return $this->belongsTo('Director');     } } 

Now I'd like fetch movies using a where condition that's based on a column from the directors table.

Is there a way to achieve this? Couldn't find any documentation on conditions based on a belongs to relationship.

Answer 1

You may try this (Check Querying Relations on Laravel website):

$movies = Movie::whereHas('director', function($q) {     $q->where('name', 'great'); })->get(); 

Also if you reverse the query like:

$directorsWithMovies = Director::with('movies')->where('name', 'great')->get(); // Access the movies collection $movies = $directorsWithMovies->movies; 

For this you need to declare a hasmany relationship in your Director model:

public function movies() {     return $this->hasMany('Movie'); } 

If you want to pass a variable into function($q) { //$variable } then

function($q) use ($variable) { //$variable } 

Answer 2

whereBelongsTo()

For new versions of Laravel you can use whereBelongsTo().

It will look something like this:

$director = Director::find(1); $movies = Movie::whereBelongsTo($director); 

More in the docs.

is()

For one-to-one relations is() can be used.

$director = Director::find(1); $movie = Movie::find(1);  $movie->director()->is($director);