Laravel 3 table relationship

Hi there!

Sounds like a perfect many to many relationship. The docs uses almost the same. (Users and roles instead of roles and permissions) For first step, take a look at here:

https://laravel.com/docs/5.8/eloquent-relationships#many-to-many

Hope it helps!

Hi @laravellover

I bet is a many to many relationship

Class Role extends Model{

     public function permissions() {
        return $this->belongsToMany(App\Permission::class, 'role_has_permissions');
    }
}


Class Permission extends Model{

     public function roles() {
        return $this->belongsToMany(App\Role::class,  'role_has_permissions');
    }
}

So lets say yo want to retrieve all the permissions name of a role

$role->permissions()->pluck('name')->toArray();

Maybe you will need to set the third and fourth parameter of the belongsToMany (https://laravel.com/docs/master/eloquent-relationships#many-to-many)

Thanks @janosk and @punksolid !

That was exactly i was looking for! i used many to many with sync method and works like a charm to add/update

https://laravel.com/docs/5.5/eloquent-relationships#updating-many-to-many-relationships

Really appreciating the community for all the quick helps!

@laravellover Glad it worked!

Please mark best reply (no hard feelings if it is not mine :)) so the thread will be listed as solved. Thank you!