naykel

I have a few relationships set up to reach into several tables and return a collection of eager loaded data.

studentCourse->belongsTo->Course
course->hasMany->Sections
sections->haveMany->media

In the controller I eager load all the data with

// collection of course data
$courseData = $studentCourse->load('course.sections.media');

This works perfectly but my problem is that I need one final relationship

media->hasMany->studentLesson

When I try to eager load the final relationship it returns all related records, not just the one I need

// This is returning all the related student lessons, not just the relevant one
$courseData = $studentCourse->load('course.sections.media.studentLesson');

This would be the query but I can not figure out where to put it.

SELECT * FROM student_lessons WHERE media_id = $mid and student_course_id = $scid

Any help would be greatly appreciated.

Thank you @snapey this was exactly the answer.

I am trying to work out how to access eager loaded when only dealing with a single record.

Here I am querying the database to return a menu named ‘main’ and eager loading the links related to this menu.

$menu =  Menu::where('name', 'main')->with('links')->get();

I want to loop throught and display the links but I can not figure out ho to do it without looping through the single menu first which seems counter productive because there is only one menu.

@foreach ($menu as $m)
    @foreach ($m->links as $l)
        {{ $l->name }}
    @endforeach
@endforeach

I have tried the following but it says that links in not in the collection.

@foreach ($menu->links as $menu)
    {{ $menu->name }}
@endforeach
}

Is there a better way?

Thanks in advance.

Yes, I am looping through a collection and passing in the $page object. I actuall tried to pass in the id before I posted but got the same problem.

I have just gone back to using the named route because this is doing my head in. I have other routes where I have used the URI and they work fine so I will just put this unkown mystery category.

I have a form and I can not figure out why I can not get the URI to work. I have no problem with the named route but for what ever reason the URI does not work as expected.

Route and Controller Method

Route::patch('/abc/pages/{page}', '[email protected]')->name('abc.pages');

public function update(Page $page){
    dd($page);
}

The named route works fine, exactly as expected it dumps the $page

<form method="POST" action="{{ route('abc.pages',  $page) }}">

However, when using the uri it returns a page not found and throws the $page object into the url

<form method="POST" action="/abc/pages/{{ $page }}">

What am I missing here?