How do I assign my users to existed roles in many to many relationship?

Hi, I'm new to Laravel.

I have Users and Roles with an intermediate role_user table. Both of the Users and Roles table have data but how do I assign user to any role using eloquent?

The below code doesn't work and I can't use the save() also.

Route::get('/assign', function(){
    $user = User::find(1);
    $role = $user->roles;
    $role->id='2';
});

Is there anyway to assign user to some role without going into dbms?

tisuchi

8 years ago

Level 70

You need to follow this convention-

$comment = new App\Comment(['message' => 'A new comment.']);

$post = App\Post::find(1);

$post->comments()->save($comment);

Ref: https://laravel.com/docs/5.4/eloquent-relationships#inserting-and-updating-related-models

1 like

Please or to participate in this conversation.