How do populate pivot with extra info

I've always struggled with getting my head around pivot tables. I have 3 tables: users, conditions, and condition_user. The condition_user table has extra columns (years, months, days). How would I fill out the pivot table when a new user submits a condition (they may have more than one condition to input) alongside filling out the extra columns? I have no idea where to begin

a4ashraf

5 years ago

Level 33

@mattb

you can get a pivot table date by this

return $this->belongsToMany('App\Models\Role')->withPivot('column1', 'column2')-> withTimestamps();

even you can change the pivot attribute name

return $this->belongsToMany('App\Models\Podcast') ->as('subscription') ->withTimestamps() ->withPivot('column1', 'column2');

MattB

5 years ago

Level 2

It wasn't about reading the data just yet, I want to know how to populate the pivot table with the extra information along side the 2 IDs

keithmclaughlin

5 years ago

Best Answer

Level 9

What kind of a relationship is there between the tables?

https://laravel.com/docs/7.x/eloquent-relationships#updating-many-to-many-relationships has a section called "Saving Additional Data On A Pivot Table".

a4ashraf

5 years ago

Level 33

@mattb

here are

$user->roles()->attach([
    1 => ['expires' => $expires],
    2 => ['expires' => $expires],
]);


$user->roles()->sync([1 => ['expires' => true], 2, 3]);

see doc as well

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

Please or to participate in this conversation.