重复表单 - 添加到数据库

Question

Ok so the form starts with a drop down which asks the question 'Select how many children you have' and you can select 1-10 and this generates duplicate forms (exact same fields) for the appropriate amount. What I want to know is how can I add each duplicate form to one table.

For example, what I want is: someone has 5 children, each child would get a row in the children table.

At the moment, if 1 child is selected and details are entered, they get entered in the table just fine. So why is it stopping that when its done for more than one, and how can I fix it?

I can update the question to post code if anyone wishes to see it, however the code is just a small part of the whole page (using JavaScript, PHP, HTML and MySQL) and things will get confusing. I'm just looking for ideas and pointers.

Answer 1

Use a counter for the form and add a number to the fieldname

<form>
<?php $counter = 1; ?>
<input type="text" name="child[<?php echo $counter; ?>][name]">
<input type="text" name="child[<?php echo $counter; ?>][age]">
... rest of the form ...
<?php $counter++; ?>
</form>

use $_POST array to retrieve the data in the script that updates the database