Check Boxes, Arrays, and DB Inserts

[rcoursey]

I want to gather one or more items with a checkbox input. Place these in an array and then pass them to a script to enter them into a MySql DB. Each record would have a recordid (Tied to another table's Primary key) along with one of the items checked. The table could have many record ids and many checkbox values. ie.

table1.recid=2 (call this recid)

For record 1 in table2:
recid = 2
checkbox=10

For record 2 in table2:
recid=2
checkbox=15

For record 3 in table2:
recid=2
checkbox=27

Other instances could be:

For record 4 in table2:
recid=5
checkbox=15

For record 5 in table2:
recid=5
checkbox=30

For record 6 in table2:
recid=1
checkbox=11

My problem is how to gather the checked items into an array, get the table1.recid from an insert to table1, and use the acquired table1.recid to insert each item in the array obtained from the checkboxes into table2 with the table1.recid (multiple times if multiple values in the array).

I hope this explains what I want to do.

Please get me started in the right direction.

[cgraz]

well. . .

Name your checkboxes properly so they become an array when processed.

<input type="checkbox" name="bla1[]" value="<?= $id ?>">

where $id contains the id of that checkbox so you can track it easier. Ofcourse, it will need to be created dynamically somehow.

Then when you process this script, you have access to the array $bla1

You can loop through this array using a foreach loop, or simply insert direction by imploding upon INSERTing. Here's an example using a SELECT query

$query = "SELECT * FROM your_table WHERE id IN ('" . implode("','", $_POST['bla1']) . "')";

Should get you off to a good start.

Cgraz

[rcoursey]

Thanks to all the issue is resolved. Now I am working on displaying this info back into a form for editing