从表单到表格发布多个下拉列表值

Question

Currently I am creating a form (70+ questions) but I am stuck on one part. I would like to get people to fill in the opening hours for every day of the week.

This will consist of the day of the week followed by 4 dropdowns, from : to (afternoon break) from : to

That part of the form looks like this: http://dgoods.eu/php/form.jpg

How can I get these values into the mysql table? Also please keep in mind that I will have to be able to extract the values from the table and work with them later on.

Answer 1

You would have to retrieve the data from the form, and add it to a MySQL table using and INSERT statement with the values. You can then get the values from the table using SELECT statements.

EDIT: I don't know much php, but it would be something like:

$sql="INSERT INTO tablename (morning_time, evening_time)
           VALUES ('$_POST[combobox1]','$_POST[combobox2]')";
mysql_real_query($sql,$con)

Also you can use $_GET instead of $_POST

You can also take a look at this.