Another(!) checkbox question

[kbc1]

Hi all,

I have read many posts about this kind of issue but not a straightforward solution which i hope someone can post in reply to me.

I dynamically build a list of checkboxes which are either checked or unchecked:

<input type=\"checkbox\" name=\"objectname[$objid]\" value=\"$objid\"  checked=\"$objchecked\" />

When I post my form:

if ($_POST['submitbutton']) {

I would like to:

a) insert a new record into my table where the checkbox is checked using the $objid as the main record value
b) delete a record from my table where the checkbox value is unchecked using the $objid as the main record value in the WHERE clause

Any snippets of code or links to tutorials would be GREATLY appreciated as I am now hitting my head against a brick wall.

Thank you in advance.
K

[bogu]

<input type="checkbox" name="objectname[]" value="$objid"  checked="$objchecked" />

U dont need to put the id on the checkbox index name is enough to put it on the checkbox value...

When u submit your form u should check your POST array:

print_r($_POST);

There u should find the checkboxes that were checked and their values should be id's...

[leatherback]

hm.. Not sure whether all browsers pass the value of checkboxes. I seem to remember that some don't..

Can someone confirm?

For certainty, I would use:
name="objectname[$objid]"

As for deleting records from your table: As you can only check which boxes were checked, you need to either: Have a list of existing records, and cross-check: If a value is submitted, then insert, else delete.

Probably easiest: Delete all records, and subsequently insert the submitted ones.