How can i insert multiple checkbox values into join table

[hardikspider]

Hi I have 3 tables.

 

employee-Firstname, last name, teamid

Join_team - id,teamid,officeid

office-officeid, officename

 

I have form. which has below fields

 

firstname, lastname

multiple Office(checkboxes)

 

If I click on submit button. data shoud insert into tables.

 

Can you plase guide me how can I insert multiple office(checkboxes) into join tables?

 

Let me know if you have nay question. I can clarify

 

Thanks

 

[NotionCommotion]

employee------<employeehadcheckboxs>-------checkboxes

 

employee has pk id and a bunch of other columns.

checkboxes has pk id and a bunch of other columns.

employeehadcheckboxs has two columns which are the other two tables pk

 

User submits form which includes employeeID and a bunch of checkbox ids.

 

Either delete all records in  employeehadcheckboxs for employee and reinsert the new ones, or find out which ones have changed, and update accordingly.