how to insert the pivot relationship in laravel

Question

consider i have 2 models that have the pivot relationship many to many between them . now when i want to insert the pivot table how can i achieve it currently i am doing this :

DB::table('model1_model2')
            ->insert([
                'something' => $something,
                'something2' => $something2,
            ]);

and i kinda feel that its not right and i have do save it with some relation ship or sync !! any idea how to do this ? EDIT‌: Added relationship

 public function accommodationRoom()
    {
        return $this->belongsToMany(AccommodationRoom::class)->withPivot('guest_first_name','guest_last_name','guest_cell_phone','guest_nationality_id');
    }

visit: https://laravel.com/docs/5.8/eloquent-relationships#updating-many-to-many-relationships — Jinal Somaiya, Jul 17 '19 at 11:06
Just insert records as array of first table foreign key and second table foreign key. That's all — Sagar Gautam, Jul 17 '19 at 11:06
https://stackoverflow.com/questions/41949911/laravel-many-to-many-insertion — HTMHell, Jul 17 '19 at 11:06
Do you have models set up for both tables and do they have the appropriate `belongsToMany` relationships set up? If so, please may you add the code for one of the relationships. — Rwd, Jul 17 '19 at 11:45
@RossWilson yes Ross Every thing is up and ready i just wanna know how to insert into database with relationship — Farshad, Jul 17 '19 at 11:48
Ok cool. Can you add the code for one of the relationships to your question? — Rwd, Jul 17 '19 at 12:02

score 2 · Answer 1 · answered Jul 17 '19 at 12:11

As mentioned in the Inserting & Updating Related Models - Many To Many Relationships documentation:

When attaching a relationship to a model, you may also pass an array of additional data to be inserted into the intermediate table:

$model1->accommodationRoom()->attach($accommodationRoomId, [
    'something'  => $something,
    'something2' => $something2,
]);

If you're attaching multiple relations then you would would pass a multidimensional array with the keys are the id of the relation and the values are the arrays of additional data:

$model1->accommodationRoom()->attach( [
    1 => ['something'  => $something, 'something2' => $something2,],
    3 => ['something'  => 'something else', 'something2' => $something2,],
]);

The same is true for the sync() method as well.

@Farshad Did this answer your question or do you still need help? — Rwd, Jul 20 '19 at 06:36

how to insert the pivot relationship in laravel

1 Answers1

Linked