Have you set up a working relationship between the 4 tables?
If so you should be able to do something like this,
$user = User::find(1)->get();
//Using Eager Loading
$user->load('country');
//then access the country fields from the user like so
$user->country->name
If not, i can help you set up one.
Last updated
2 years ago.
Solution
Hi evandertino, thanks for your message; relationships works 100%.
Laravel documentation is poor about Eager Loading (http://laravel.com/docs/eloquent#eager-loading) =(
After many tries I found out a soluction:
$results = User::with([
'country' => function ($query) {
$query->select('id','name');
},'posts' => function ($query) {
$query->select('id','user_id','title');
},'posts.attachments' => function ($query) {
$query->select('id','post_id','type');
}])->get(['id','country_id','name']);
Yo need to add either the primary key or the foreign key to the field list.
Last updated
2 years ago.
Your code will work for this kind of relation but you need to select also all foreign keys to let Eloquent match related models to their parents.
Last updated
2 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast