Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
my db tables
relation logic:
// in Item.php
protected $fillable = ['title', 'session_id', 'series_no', 'desc', 'image_url', 'aws_video_url'];
public function series()
{
return $this->belongsTo(Series::class, 'series_id');
}
// in Series.php
public function items()
{
return $this->hasMany(Item::class, 'series_id');
}
// in Session.php
public function items()
{
return $this->hasMany('App\Item', 'session');
}
it's okey when I fetch result from any single model.
But I want to fetch item like
session 1
session 2
session 3
continue ...
ok, so
Series hasMany Session, Session belongsTo Series
Session hasMany Item, Item belongsTo Session
You need series_id on sessions table
You need session_id on items table
define the relationships as described above and you won't need to provide key names in your relationship (as these are often wrong)
But the problem is every series owned all of session.
so how we can set the relation if you put session id in items table.
Write it out like I did and it will be clearer
like
Here, Every Series has session 1 to session 10
I think I have some similar code somewhere in beetv movie app which is also one of the finest movie app that also provide tv shows, series, serials under separate categories which are actually well categorised.
When you say session, it it same as season?
In one I did, I just have columns for season and episode,
"some show title", "S3", "E22"
The series has a unique id. So you can easily query a series if needed.
Please or to participate in this conversation.