以一种形式向数据库添加多个项目

Question

I've got an internal site I'm developing for work. I'm by no means a web developer but know enough to get some basic functionality done. I've got a form working fine for inserting data. I'm trying to figure out this one last piece, though.

The page is designed to add jobs to our site. Each position has assigned responsibilities. The easiest way to make this work (in my brain) is to create a table for responsibilities that has a responsibilityID, PositionID, and then the responsibility. I want a way to kind of bulk add these responsibilities when completing the form for the new position. Something similar to how you add new fields when using the MySQL workbench - where you can just click on the next row and it'll add that field. That would work great.

I'm not sure what to even search for to accomplish this other than adding multiple items - which hasn't turned up what I'm looking for.

Thanks in advance!

Answer 1

Most times people here like to see what you've tried.

This question was asked here.

example MySQL statement:

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

You can replace the values with PHP variables if needed. Just make sure if they are strings, they are in 'quotes'.