Add data to a Laravel pivot table

Question

I have a database with 3 tables : users, events and user_event.

I create my event. Once my event is created, I would like to add users.

How can I add him via a form to add users?

My pivot table contain :

event_id, user_id

Do I need to create a UserEventController?

My model relations :

public function users()
{
    return $this->belongsToMany('User')->withPivot('user_event');
}

For create an event :

public function store(Request $request)
{
    $this->validate($request, [
        'course_name'  => 'required|max:255',
        'academic_year' => 'required|max:4|min:4',
        'exam_session' => 'required',
        'date_event' => 'required'
    ]);

    $event = new Event();

    $event->course_name  = $request->course_name;
    $event->academic_year = $request->academic_year;
    $event->exam_session = $request->exam_session;
    $event->date_event = $request->date_event;

    $event->save();
}

Thanks for your help !

I don't add an event, I want to add a user to the already created event. That's why I'm stuck. — Jeremy
– Jeremy, Commented Jan 17, 2019 at 19:01

lovis91 · Accepted Answer · 2019-01-17 19:06:04Z

0

So you need to use the attach()method :

$event->users()->attach($userId);

more informations here : Laravel Eloquent - Attach vs Sync

answered Jan 17, 2019 at 19:06

lovis91

2,1692 gold badges16 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Henrique Menegale · Accepted Answer · 2020-02-06 17:37:38Z

0

Since the event is already created, you can just use the event object to add an existing user, create a new one, or maybe even sync a list of users.

//create a new user
$event->users()->create(['name' => 'user name', 'email' => 'user email']);

//attach existing user
$event->users()->attach($userId);

//sync multiple existing users passing array of user ids
$event->users()->sync([1,2,4]);

You can see details about all of those methods and a few more here: https://laravel.com/docs/5.7/eloquent-relationships#inserting-and-updating-related-models

edited Feb 6, 2020 at 17:37

answered Jan 17, 2019 at 19:10

Henrique Menegale

11 silver badge3 bronze badges

Collectives™ on Stack Overflow

Add data to a Laravel pivot table

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related