Error with relationship - Laravel

Question

Error with relationship - Laravel

Asked 6 years, 4 months ago

Viewed 38 times

0

Guys, I’m with 2 related tables and I want to show you 1 dice that has a just "pulling" this relationship.

tables:

Users:

Permissions:

Table that will list:

Code:

@foreach(App\User::all() as $user)
                              <tr>
                                <td>{{$user->id}}</td>
                                <td>{{$user->name}}</td>
                                <td>{{$user->permission->name}}</td>
                                <td>{{$user->email}}</td>
                              </tr>
                              @endforeach

Model "User":

public function permission()
{
    return $this->hasOne('App\Permission', 'id', 'role');
}

error:

What is the foreign permission key? id or name?

– adventistaam

2018/07/27 at 18:33
id is the permission key, but I want to show the name

– Victor Gabriel

2018/07/27 at 18:33
The name is of the user?

– adventistaam

2018/07/27 at 18:35
name is of the permission I want it to appear, but also name in User

– Victor Gabriel

2018/07/27 at 18:36
You can see in the annex I put to the question

– Victor Gabriel

2018/07/27 at 18:36
Try to put it like this: {{ $user->permission->name }}

– adventistaam

2018/07/27 at 18:37
error, I will put in the publication

– Victor Gabriel

2018/07/27 at 18:38
The two users have scrolls registered for it? you can try to encompass in an optional method, for example {{ optional($user->permission)->name }} if the user has no relation to permission, will return empty

– arllondias

2018/07/27 at 18:42
yes, each has its own registered role

– Victor Gabriel

2018/07/27 at 18:42
Var_dump user output

– adventistaam

2018/07/27 at 18:45
Try it this way {{ $user->permission[0]->name }

– adventistaam

2018/07/27 at 18:46
It doesn’t do that up, it’s gambiarra. I’m sorry, but it is. It has the right.

– Diego Souza

2018/07/27 at 18:47
As it is in the controller?

– adventistaam

2018/07/27 at 18:57
it was no way

– Victor Gabriel

2018/07/27 at 18:58
controller does not have any function

– Victor Gabriel

2018/07/27 at 19:01

Show 10 more comments

1 answer

Browser other questions tagged laravel query

You are not signed in. Login or sign up in order to post.

by Diego Souza • **16,524** points · Answer 1 · 2018-07-27T18:42:31+00:00

The second term of the function belongsTo() is the name of the key has that in the table users which will serve as a comparison with the table permissions.

public function permission()
{
    return $this->belongsTo('App\Permission', 'role');
}

Automatically it will compare with the column id table permissions, unless you define in the third term which column should serve as a comparison.