Forms and Arrays

[timbr8ks]

In my form, I look up in my database all the fruits that are in basket A. It does this using a While statement, listing each fruit with a checkbox until there are no more fruits in basket A.

The person using the form then can select which fruits he wants and submit the form. I then need to read which ones he selected and, for each, insert a record in the person_to_fruit table.

How do I create an array of the selected fruits and then read that array when the form is submitted so that I can create a separate record for each fruit selected by this user?

[cgraz]

to create an array out of checkboxes, give them all the same name and use [] at the end. For example:

<input type="checkbox" name="fruit[]" value="apple"><br>
<input type="checkbox" name="fruit[]" value="orange"><br>
<input type="checkbox" name="fruit[]" value="banana">

now in your php script you'll have access to array variable $fruit. To insert a new record for each fruit item selected, use a foreach loop

foreach($fruit as $value) {
$query = mysql_query("INSERT INTO your_table (fruit) VALUES('$value')");
}

Cgraz