Thank you for your generous response.
I am almost there, but not quite.
I changed my checkbox statement to looke like the following:
INPUT type=checkbox name=isSelected[] value=?php $row['ID'] ?
where ID is the name of the auto-incremental id of my table.
This is the output I get from my post_r debug statement:
Array
(
[isSelected] = Array
(
[0] =
[1] =
[2] =
)
[SUBMIT] = Edit
)
As I was debugging I tried the checkbox statement without the value
attribute or parameter, so it looked like the following:
INPUT type=checkbox name=isSelected[]
and the debug info from post_r is the following
Array
(
[isSelected] = Array
(
[0] = on
[1] = on
[2] = on
)
[SUBMIT] = Edit
)
which makes me wonder whether or not an 'int' value can be input for the
value of a checkbox array.
From: John Holmes [EMAIL PROTECTED]
To: Mahmoud Badreddine [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] How to emulate phpMyadmin for editing with checkboxes
Date: Wed, 23 Feb 2005 22:11:18 -0500
Mahmoud Badreddine wrote:
Problem statement:
I would like to give my users the option of clicking on a checkbox which I
have provided as a field in a table and then clicking on the edit (or
delete ) button to edit the info pertaining to the checked record.
In other words , in case my statement of the problem isn't clear, I would
like to do the editing or deletion the same way it's done in phpMyadmin.
Click on the checkbox followed by the desired action.
Details:
I have included in my table a field which I have called chosen which is
of type enum('1','0')
As soon as I hit the edit button , I am redirected to a php script. In
that scritp the first action I would like to make is to update the field
chosen from the value '0' to the value '1'.
This way I will be able to update based on the value of that field. But my
problem is how to link the checkbox input to this field. The checkbox
input is blind to which record it is acting upon. But there must be a way.
Each record has an ID, right? So set the value of the checkbox to the ID of
the record. Make the checkboxes an array, also.
input type=checkbox name=choices[] value=?=$record['id']?
Do that for each checkbox. When the form is submitted, you'll have
$_POST['choices'] that contain the IDs of all the records selected.
array_values($_POST['choices']) will give you the values or you can loop
through the array yourself.
Now perform whatever action was selected. The action can be a value
passed from a drop down select box. No need for a chosen column in the
database. You'll just run into trouble with that anyhow, because how do you
get the records back to unchosen? How do you determin who chose a
record? What happens if they choose records, but don't perform an action?
If their browser or computer crashes? etc... :)
--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals www.phparch.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
