Accessing many to many relationships - Student groups.

Hi I am an absolute newbie in Laravel. I tried searching the internet but I can't seem to find a solution to my problem.

We have student groups. Students change groups each month. In our Student model we declared the following relationship:

//Student.php

public function groups()
{
    return $this->belongsToMany(Group::class);
}

The groups table contains name, month, moderator, etc.

When I need to get the group information of a particular student in a given month, I have to:

$student->groups->where('month', $month)->first()->name;
$student->groups->where('month', $month)->first()->moderator;

Which I think is too long and tedious. Is there a way to simplify this like so:

$student->groupMonth($month)->name;
$student->groupMonth($month)->moderator;

How do I do that? Or Is there a better way of doing this?

Thank you.

Best Answer

Level 122

also, you don't need to keep re-running the query for each field.

$studentGroup = $student->groups->where('month', $month)->first()

$studentGroup->name;
$studentGroup->moderator;

1 like

Please or to participate in this conversation.