Error with relationship - Laravel

Question

Error with relationship - Laravel

Navigation

#1 by (0 votes)

0

I have 2 related tables and I want to show 1 data that has only one "pulling" this relationship.

tables:

Users:

Permissions:

Tablethatwilllist:

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:

query laravel

asked by anonymous 27.07.2018 / 20:27

1 answer

Charts.js listing data from a BD (ionic 3) Filter in DataTable with Checkbox

score 0 · Accepted Answer

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

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

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