Select MySQL records to update with checkbox

[bcreigh]

I need to be able to select which records will be passed to a query. I have designed a page that displays all of the records from a table and at the end of each line, I have placed a checkbox. I want to be able to pass only the records that have a check in the box to the update query.

I guess the real question is can I pass an array to either post or get or as a session variable.

Any ideas will be greatly appreciated.

Bob

 

[sleipnir214]

Yes, you can pass an array to $_POST or $_GET.

If your form element names take the appearance of a PHP array reference, they will appear in a single array in $_POST or $_GET.

For example, this form:

<form method=&quot;POST&quot; action=&quot;foo.php&quot;>
<input type=&quot;checkbox&quot; name=&quot;check[1]&quot;>
<input type=&quot;checkbox&quot; name=&quot;check[2]&quot;>
<input type=&quot;checkbox&quot; name=&quot;check[3]&quot;>
</form>

when submitted, $_POST['check'] will itself be an array containing indeces and values only for those checkboxes that were selected.

If you use the record IDs from your table in the place of 1, 2, 3 in my example, then the indeces of $_POST['check'] will contain the table record IDs of those records that should be manipulated.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!