laravel- eloquent relationships

Question

I have a courses table, a course hasMany sections and sections hasMany lectures and lectures hasMany comments. How should I define the relationship in the LectureComment model, if I have a comment id and I want to know its course name?

table structures

courses: id|title

sections: id|course_id|name

lectures: id|section_id|name|description

lecture_comments: id|lecture_id|user_id|comment_body

Odin Thunder · Accepted Answer · 2017-02-19 08:50:45Z

1

In course model:

public function sections()
{
    return $this->hasMany('App\Section');
}

Section model:

public function course()
{
    return $this->belongsTo('App\Course');
}

public function lectures()
{
    return $this->hasMany('App\Lecture');
}

Lecture model:

public function section()
{
    return $this->belongsTo('App\Section');
}

public function lectures_comments()
{
    return $this->hasMany('App\LecturesComment');
}

LecturesComment model:

public function lecture()
{
    return $this->belongsTo('App\Lecture');
}

To receive required data, you must walk through relations.

If you have correctly written foreign keys, this code will return a course title:

$comment = LecturesComment::find(1);

$courseName = $comment->lecture->section->course->title

Hope it will be helpful :)

answered Feb 19, 2017 at 8:50

Odin Thunder

3,5552 gold badges33 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

laravel- eloquent relationships

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related