Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
I'm going slightly mad.
I have an Event model and an Instance model. An Event hasMany Instances and each Instance belongsTo one Event.
In Eloquent I can therefore say:
Event::find(1)->instances
and list all the instances of an Event.
How can I do the reverse and get the Event information for a specific Instance? If I say:
Instance::find(1)->events
It just returns null
Models:
class Event extends Model {
public function instances()
{
return $this->hasMany('App\Instance');
}
public function categories()
{
return $this->belongsToMany('App\Category');
}
}
class Instance extends Model {
protected $fillable = [
'event_id',
'instance_date',
'venue',
];
protected $dates = [
'instance_date'
];
public function scopeMatchEventId($query,$id)
{
return $query->where('event_id', '=', $id);
}
public function events()
{
return $this->belongsTo('App\Event');
}
public function venues()
{
return $this->belongsToMany('App\Venue');
}
}
Show us the code in your models.
This is just a guess, but you might have issues with the names of your models.
Event and Instance are terms used widely through Laravel and PHP in general. Even if this isn't an issue for PHP to handle, I would suggest renaming them to something a little clearer.
@mstnorris sorry, added to my initial post.
@TimeSocks does the Instance with an ID of 1 actually belong to any Events?
Try something like this:
Event::find(1)->instances;
Use one of the IDs that was returned as the $id for the code below:
Instance::find($id)->events;
@mstnorris yes, if I run App\Event::find(1)->instances in Tinker I get a list of instances. I've cherry-picked several of those listed to do in reverse. No dice.
Just to please me, rename your methods to something other than events() to see if there is a collision somewhere.
Already been trying it since you mentioned it... wibbles are just as ineffective as events I'm afraid.
As there is only one parent event, name your method event. Without s.
The foreign key is inferred from the relation name. It should work with event. Otherwise you can specify it with the second param.
@pmall nice catch ;)
Laravel makes this stuff so simple, I forget sometimes that you need to bend to its will to do these types of things.
@pmall a-ha, that's got it... in Tinker at least.
Supplementary question for super-bonus points: how would I do a join so that I can retrieve all the Instance information for a given instance, but also the event_name from its associated Event?
p.s. @mstnorris thanks for your input too.
Laravel makes this stuff so simple, I forget sometimes that you need to bend to its will to do these types of things.
always stick to the convention.
Plus it allow things like parent() relationship that automagically guess parent_id.
@TimeSocks use
Instance::with('event')->whereId($id)->get();
Check out Eager Loading
Jeffrey has tonnes of videos on it too!
Supplementary question for super-bonus points: how would I do a join so that I can retrieve all the Instance information for a given instance, but also the event_name from its associated Event?
You dont do a join, you eager load the events. $instances = Instance::with('event');.
@pmall @mstnorris that doesn't return anything...
Add get().
@TimeSocks I was updating my reply, you should see it there.
@pmall Aha, of course. I'm an idiot.
Erm, one more thing... how do I retrieve just one column from event as opposed to all columns?
@TimeSocks If an instance only belongs to one event, then rename the relation to just be event, i.e.
public function event()
{
return $this->belongsTo('App\Event');
}
It could be that the name “events” conflicts with some thing internal to Laravel.
@martinbean I'm going to start calling you grandad ;)
@mstnorris @pmall what would happen to me if I accepted @martinbean's answer? :D
Erm, one more thing... how do I retrieve just one column from event as opposed to all columns?
Why do you care about this ?
@TimeSocks you have to query the events table anyway so it doesn't matter, just use the above and then, once you have the $event use $event->name
@pmall because it seems messy to get all the event information (which includes a lot of text in many cases) when all I need is the event_name. Maybe it doesn't matter ¯_(ツ)_/¯
@mstnorris hovers over acceptance tick
@mstnorris Okay. So I'm passing my nicely retrieved $instance variable to my view. Now how do I access the information in the event section in my view? I've tried $instance->event->event_name and it threw an error.
What error, please give details as it might be unrelated. This should also be a new question.
Anyway, is event_name the name of the field?
@mstnorris Yes. I've just done it actually, by putting it in a foreach loop:
@foreach($instance as $event)
{{ $event->event->event_name }}
@endforeach
Seems somehow wasteful to go through a loop for something that will always be one item though. Is there a better way?
How are you passing $instance to the view? Can I see that logic.
return view('instance.show',compact('instance'));
@TimeSocks what is $instance? Show me that code too.
You probably need to use
$instance = Instance::with('event')->whereId($id)->first();
return view('instance.show', compact('instance'));
And then in your view you can do as you were before.
{{ $instance->event->event_name }}
Please or to participate in this conversation.