By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,830 Members | 1,758 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,830 IT Pros & Developers. It's quick & easy.

Handling Multiple check boxes

P: n/a
I have a PHP generated page which displays X many records. Each record has
a checkbox preceding it. The user checks several checkboxes, and hits a
delete button. All the corresponding records will be deleted.

But I'm running into difficulty...
Right now the NAME property of each check box is the primary key of the
corresponding record. Hence if I know which checkboxes are checked, I
simply use DELETE using the NAME value.

Generally speaking, how do I get the server side to see which check boxes
were checked?

The check box names may not be sequential, if any records have been deleted
previously, and the first check box might be a number greater than 0.

Is there an easy mechanism to do this? Some kind of built in cnotrol array
allowing me to loop over every check box that was on the form submitted?

I could store the last and first checkbox number in a hidden input, then
loop starting/ending at those values, but that may loop over a lot of
controls that do not exist.
Thoughts?

<Ade
--
Adrian Parker. Ordained priest. <ad***********@sympatico.ca>

"A society that views graphic violence as entertainment ...should not be
surprised when senseless violence shatters the dreams of it's youngest and
brightest..." - Ensign (March 2004)
Jul 17 '05 #1
Share this Question
Share on Google+
13 Replies


P: n/a
I've solved this problem in the past by giving each of the checkboxes
the same name, say id, but then setting the value statement to the
primary key I'm on. When you look in your _POST array, you should find
that each id that was checked is in a comma separated list. Just process
this list as you need to loop over the selected primary keys.

Adrian Parker wrote:
I have a PHP generated page which displays X many records. Each record has
a checkbox preceding it. The user checks several checkboxes, and hits a
delete button. All the corresponding records will be deleted.

But I'm running into difficulty...
Right now the NAME property of each check box is the primary key of the
corresponding record. Hence if I know which checkboxes are checked, I
simply use DELETE using the NAME value.

Generally speaking, how do I get the server side to see which check boxes
were checked?

The check box names may not be sequential, if any records have been deleted
previously, and the first check box might be a number greater than 0.

Is there an easy mechanism to do this? Some kind of built in cnotrol array
allowing me to loop over every check box that was on the form submitted?

I could store the last and first checkbox number in a hidden input, then
loop starting/ending at those values, but that may loop over a lot of
controls that do not exist.
Thoughts?

<Ade

--
Martin
(Personal email: ma****@galese.net)
(Work/Academic email: an**@uchicago.edu)

"As soon as men decide that all means are permitted to fight an evil,
then their good becomes indistinguishable from the evil that
they set out to destroy."
- Christopher Dawson

"And this gray spirit yearning in desire
To follow knowledge like a sinking star,
Beyond the utmost bound of human thought."
- Lord Alfred Tennyson
Jul 17 '05 #2

P: n/a
"Martin Andrew Galese" <ma****@galese.net> wrote in message
news:rn**************@news.uchicago.edu...
I've solved this problem in the past by giving each of the checkboxes
the same name, say id, but then setting the value statement to the
primary key I'm on. When you look in your _POST array, you should find
that each id that was checked is in a comma separated list. Just process
this list as you need to loop over the selected primary keys.
I didn't know the checkbox could have a value. Cool.

The only way I've used the POST array before was by doing things like:
if (isset($_POST["controlname"]))

How do you reference it using your method?
Adrian


Adrian Parker wrote:
I have a PHP generated page which displays X many records. Each record has a checkbox preceding it. The user checks several checkboxes, and hits a
delete button. All the corresponding records will be deleted.

But I'm running into difficulty...
Right now the NAME property of each check box is the primary key of the
corresponding record. Hence if I know which checkboxes are checked, I
simply use DELETE using the NAME value.

Generally speaking, how do I get the server side to see which check boxes were checked?

The check box names may not be sequential, if any records have been deleted previously, and the first check box might be a number greater than 0.

Is there an easy mechanism to do this? Some kind of built in cnotrol array allowing me to loop over every check box that was on the form submitted?

I could store the last and first checkbox number in a hidden input, then
loop starting/ending at those values, but that may loop over a lot of
controls that do not exist.
Thoughts?

<Ade

--
Martin
(Personal email: ma****@galese.net)
(Work/Academic email: an**@uchicago.edu)

"As soon as men decide that all means are permitted to fight an evil,
then their good becomes indistinguishable from the evil that
they set out to destroy."
- Christopher Dawson

"And this gray spirit yearning in desire
To follow knowledge like a sinking star,
Beyond the utmost bound of human thought."
- Lord Alfred Tennyson

Jul 17 '05 #3

P: n/a

"Martin Andrew Galese" <ma****@galese.net> wrote in message
news:rn**************@news.uchicago.edu...
I've solved this problem in the past by giving each of the checkboxes
the same name, say id, but then setting the value statement to the
primary key I'm on. When you look in your _POST array, you should find
that each id that was checked is in a comma separated list. Just process
this list as you need to loop over the selected primary keys.
That doesn't seem to work.

foreach (array_keys($_POST) as $key) {
$$key = $_POST[$key];
print "$key is ${$key}<br />";
}
When I name all the textboxes the same, and make their values the primary
key of the record to delete, the _POST array just contains the total number
of checked checkboxes.

Output:
"deleteMe is 8
Delete is Delete selected"

I check 8 check boxes. Their names are 1, 2, 3, 4, 5, 6, 7, 8

Either _POST is getting the number of how many are checked, or the value of
the last one only.

Adrian

Adrian Parker wrote:
I have a PHP generated page which displays X many records. Each record has a checkbox preceding it. The user checks several checkboxes, and hits a
delete button. All the corresponding records will be deleted.

But I'm running into difficulty...
Right now the NAME property of each check box is the primary key of the
corresponding record. Hence if I know which checkboxes are checked, I
simply use DELETE using the NAME value.

Generally speaking, how do I get the server side to see which check boxes were checked?

The check box names may not be sequential, if any records have been deleted previously, and the first check box might be a number greater than 0.

Is there an easy mechanism to do this? Some kind of built in cnotrol array allowing me to loop over every check box that was on the form submitted?

I could store the last and first checkbox number in a hidden input, then
loop starting/ending at those values, but that may loop over a lot of
controls that do not exist.
Thoughts?

<Ade

--
Martin
(Personal email: ma****@galese.net)
(Work/Academic email: an**@uchicago.edu)

"As soon as men decide that all means are permitted to fight an evil,
then their good becomes indistinguishable from the evil that
they set out to destroy."
- Christopher Dawson

"And this gray spirit yearning in desire
To follow knowledge like a sinking star,
Beyond the utmost bound of human thought."
- Lord Alfred Tennyson

Jul 17 '05 #4

P: n/a

"Martin Andrew Galese" <ma****@galese.net> wrote in message
news:rn**************@news.uchicago.edu...
I've solved this problem in the past by giving each of the checkboxes
the same name, say id, but then setting the value statement to the
primary key I'm on. When you look in your _POST array, you should find
that each id that was checked is in a comma separated list. Just process
this list as you need to loop over the selected primary keys.
I feel supid now.

This doesn't work. If 10 check boxes all have the same name, the only value
used is that of that last one. They cascadingly change the value of the one
checkbox name.


Adrian Parker wrote:
I have a PHP generated page which displays X many records. Each record has a checkbox preceding it. The user checks several checkboxes, and hits a
delete button. All the corresponding records will be deleted.

But I'm running into difficulty...
Right now the NAME property of each check box is the primary key of the
corresponding record. Hence if I know which checkboxes are checked, I
simply use DELETE using the NAME value.

Generally speaking, how do I get the server side to see which check boxes were checked?

The check box names may not be sequential, if any records have been deleted previously, and the first check box might be a number greater than 0.

Is there an easy mechanism to do this? Some kind of built in cnotrol array allowing me to loop over every check box that was on the form submitted?

I could store the last and first checkbox number in a hidden input, then
loop starting/ending at those values, but that may loop over a lot of
controls that do not exist.
Thoughts?

<Ade

--
Martin
(Personal email: ma****@galese.net)
(Work/Academic email: an**@uchicago.edu)

"As soon as men decide that all means are permitted to fight an evil,
then their good becomes indistinguishable from the evil that
they set out to destroy."
- Christopher Dawson

"And this gray spirit yearning in desire
To follow knowledge like a sinking star,
Beyond the utmost bound of human thought."
- Lord Alfred Tennyson

Jul 17 '05 #5

P: n/a
In article <24*******************@news20.bellglobal.com>,
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote:
Is there an easy mechanism to do this? Some kind of built in cnotrol array
allowing me to loop over every check box that was on the form submitted?


Make the "name" attribute an array.

<input type="checkbox" name="checkbox_id[1]" value="a" />
<input type="checkbox" name="checkbox_id[3]" value="b" />
<input type="checkbox" name="checkbox_id[56]" value="c" />
<input type="checkbox" name="checkbox_id[145]" value="d" />

If a and c are checked, then after submitting $_REQUEST['checkbox_id']
is an array containing this: [1] => a [56]=> d.

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.
Jul 17 '05 #6

P: n/a

"Jan Pieter Kunst" <de*****@cauce.org> wrote in message
news:de***************************@news1.news.xs4a ll.nl...
In article <24*******************@news20.bellglobal.com>,
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote:
Is there an easy mechanism to do this? Some kind of built in cnotrol array allowing me to loop over every check box that was on the form submitted?


Make the "name" attribute an array.

<input type="checkbox" name="checkbox_id[1]" value="a" />
<input type="checkbox" name="checkbox_id[3]" value="b" />
<input type="checkbox" name="checkbox_id[56]" value="c" />
<input type="checkbox" name="checkbox_id[145]" value="d" />

If a and c are checked, then after submitting $_REQUEST['checkbox_id']
is an array containing this: [1] => a [56]=> d.


How can I loop through it without knowing how many elements it holds?

Example code?
Adrian
Jul 17 '05 #7

P: n/a
In article <Y0*******************@news20.bellglobal.com>,
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote:
Make the "name" attribute an array.

<input type="checkbox" name="checkbox_id[1]" value="a" />
<input type="checkbox" name="checkbox_id[3]" value="b" />
<input type="checkbox" name="checkbox_id[56]" value="c" />
<input type="checkbox" name="checkbox_id[145]" value="d" />

If a and c are checked, then after submitting $_REQUEST['checkbox_id']
is an array containing this: [1] => a [56]=> d.

(Should be [56] => c, sorry)
How can I loop through it without knowing how many elements it holds?


That's what foreach() is for! See
<http://nl.php.net/manual/en/control-structures.foreach.php>.

Assuming that the form was submitted with method="post":

foreach($_POST[checkbox_id] as $record_id => $value) {

do_something_in_database($record_id);
...
}

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.
Jul 17 '05 #8

P: n/a

"Jan Pieter Kunst" <de*****@cauce.org> wrote in message
news:de***************************@news1.news.xs4a ll.nl...
In article <24*******************@news20.bellglobal.com>,
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote:
Is there an easy mechanism to do this? Some kind of built in cnotrol array allowing me to loop over every check box that was on the form submitted?


Make the "name" attribute an array.

<input type="checkbox" name="checkbox_id[1]" value="a" />
<input type="checkbox" name="checkbox_id[3]" value="b" />
<input type="checkbox" name="checkbox_id[56]" value="c" />
<input type="checkbox" name="checkbox_id[145]" value="d" />

If a and c are checked, then after submitting $_REQUEST['checkbox_id']
is an array containing this: [1] => a [56]=> d.


This seems to work:

foreach(array_keys($_POST["checkBox_Delete"]) as $key)
{
if ($deleteCount == 0)
{
$deleteThese = "'" . $key . "'";
$deleteCount += 1;
} else {
$deleteThese .= ", '" . $key . "'";
}
}
This look good to you?
Adrian
Jul 17 '05 #9

P: n/a
In article <qk*******************@news20.bellglobal.com>,
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote:
This seems to work:

foreach(array_keys($_POST["checkBox_Delete"]) as $key)
{
if ($deleteCount == 0)
{
$deleteThese = "'" . $key . "'";
$deleteCount += 1;
} else {
$deleteThese .= ", '" . $key . "'";
}
}
This look good to you?


If you need the number of checked checkboxes, it is faster to get that
like this:

$deleteCount = count($_POST['checkBox_Delete']);

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.
Jul 17 '05 #10

P: n/a
On Thu, 29 Apr 2004 22:14:59 +0200
Jan Pieter Kunst <de*****@cauce.org> wrote:
In article <Y0*******************@news20.bellglobal.com>,
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote:
Make the "name" attribute an array.

<input type="checkbox" name="checkbox_id[1]" value="a" />
<input type="checkbox" name="checkbox_id[3]" value="b" />
<input type="checkbox" name="checkbox_id[56]" value="c" />
<input type="checkbox" name="checkbox_id[145]" value="d" />

If a and c are checked, then after submitting
$_REQUEST['checkbox_id'] is an array containing this: [1] => a
[56]=> d.


(Should be [56] => c, sorry)
How can I loop through it without knowing how many elements it
holds?


That's what foreach() is for! See
<http://nl.php.net/manual/en/control-structures.foreach.php>.

Assuming that the form was submitted with method="post":

foreach($_POST[checkbox_id] as $record_id => $value) {

do_something_in_database($record_id);
...
}


You can also do

reset($array);

while( list($key,$val) = each( $array ) ) {

echo $key . ' => ' . $val;

}
Jul 17 '05 #11

P: n/a

"Jan Pieter Kunst" <de*****@cauce.org> wrote in message
news:de***************************@news1.news.xs4a ll.nl...
In article <qk*******************@news20.bellglobal.com>,
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote:
This seems to work:

foreach(array_keys($_POST["checkBox_Delete"]) as $key)
{
if ($deleteCount == 0)
{
$deleteThese = "'" . $key . "'";
$deleteCount += 1;
} else {
$deleteThese .= ", '" . $key . "'";
}
}
This look good to you?


If you need the number of checked checkboxes, it is faster to get that
like this:

$deleteCount = count($_POST['checkBox_Delete']);


Nah, the deleteCount is just used to see if it's the first element to be
added to the string deleteCount.

deleteCount is building a single quote and comma delimited string that will
be used as argument for a mySQL IN function.

Adrian
Jul 17 '05 #12

P: n/a
In article <1C*******************@news20.bellglobal.com>,
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote:
Nah, the deleteCount is just used to see if it's the first element to be
added to the string deleteCount.

deleteCount is building a single quote and comma delimited string that will
be used as argument for a mySQL IN function.


Ah, I see. In that case this will build the querystring in less code:

$querystring = "DELETE FROM ... WHERE ... IN ('" . join("','",
array_keys($_POST['checkbox_delete']) . "')";

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.
Jul 17 '05 #13

P: n/a

"Jan Pieter Kunst" <de*****@cauce.org> wrote in message
news:de***************************@news1.news.xs4a ll.nl...
In article <1C*******************@news20.bellglobal.com>,
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote:
Nah, the deleteCount is just used to see if it's the first element to be
added to the string deleteCount.

deleteCount is building a single quote and comma delimited string that will be used as argument for a mySQL IN function.


Ah, I see. In that case this will build the querystring in less code:

$querystring = "DELETE FROM ... WHERE ... IN ('" . join("','",
array_keys($_POST['checkbox_delete']) . "')";


Cool, thanks.
Adrian
Jul 17 '05 #14

This discussion thread is closed

Replies have been disabled for this discussion.