Re: [PHP-DB] Dealing with Unchecked Checkboxes
If you want to have an answer for each item, you should use yes/no radio buttons. With checkboxes you only get yes answer, as you are aware. The assumption is that you could care less about no answers since you are only interested in the yes set. Checkboxes reveal yes answers, radio buttons can reveal yes or no (or perhaps no answer if there is no default). If you want to stick with checkboxes, then I would have a hidden field for each checkbox you have. The hidden field could then be set with a yes or no value via javascript and an onChange event capture. On Saturday, October 26, 2002, at 05:02 PM, Graeme McLaren wrote: Hey all, I'm trying to get my head around checkboxes. I can insert checked checkboxes into a DB no problem but I get an error when the checkboxes are unchecked. -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Dealing with Unchecked Checkboxes
how about a default value...so if you use a CHECKBOX_FIELD1 ENUM('Y', 'N')
DEFAULT N type of definition, then if box is not checked, then it will
deault to N otherwise a Y will override the default.
just a thoughtdont' know if it will work for you or not...
Jeff
Brent Baisley
brent@landove To: Graeme McLaren
[EMAIL PROTECTED]
r.com cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Dealing with
Unchecked Checkboxes
10/28/2002
10:49 AM
If you want to have an answer for each item, you should use yes/no radio
buttons. With checkboxes you only get yes answer, as you are aware.
The assumption is that you could care less about no answers since you
are only interested in the yes set.
Checkboxes reveal yes answers, radio buttons can reveal yes or no
(or perhaps no answer if there is no default).
If you want to stick with checkboxes, then I would have a hidden field
for each checkbox you have. The hidden field could then be set with a
yes or no value via javascript and an onChange event capture.
On Saturday, October 26, 2002, at 05:02 PM, Graeme McLaren wrote:
Hey all, I'm trying to get my head around checkboxes. I can insert
checked checkboxes into a DB no problem but I get an error when the
checkboxes are unchecked.
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
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
Re: [PHP-DB] Dealing with Unchecked Checkboxes
Hi all, thanks for all your replies, I got the problem with checkboxes fixed
:)
Cheers,
Graeme :)
- Original Message -
From: [EMAIL PROTECTED]
To: Graeme McLaren [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 28, 2002 3:53 PM
Subject: Re: [PHP-DB] Dealing with Unchecked Checkboxes
how about a default value...so if you use a CHECKBOX_FIELD1 ENUM('Y', 'N')
DEFAULT N type of definition, then if box is not checked, then it will
deault to N otherwise a Y will override the default.
just a thoughtdont' know if it will work for you or not...
Jeff
Brent Baisley
brent@landove To: Graeme McLaren
[EMAIL PROTECTED]
r.com cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Dealing
with Unchecked Checkboxes
10/28/2002
10:49 AM
If you want to have an answer for each item, you should use yes/no radio
buttons. With checkboxes you only get yes answer, as you are aware.
The assumption is that you could care less about no answers since you
are only interested in the yes set.
Checkboxes reveal yes answers, radio buttons can reveal yes or no
(or perhaps no answer if there is no default).
If you want to stick with checkboxes, then I would have a hidden field
for each checkbox you have. The hidden field could then be set with a
yes or no value via javascript and an onChange event capture.
On Saturday, October 26, 2002, at 05:02 PM, Graeme McLaren wrote:
Hey all, I'm trying to get my head around checkboxes. I can insert
checked checkboxes into a DB no problem but I get an error when the
checkboxes are unchecked.
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Dealing with Unchecked Checkboxes
Hey all, I'm trying to get my head around checkboxes. I can insert checked
checkboxes into a DB no problem but I get an error when the checkboxes are unchecked.
I've used the following to try and handle unchecked checkboxes but I still get the
error query was empty can anyone point me in the right direction?
$number=count($GiftWrapping);
for($a=0;$a$number;$a++)
{
echo $GiftWrapping[$a];
if ( empty( $GiftWrapping ) )
{
$GW = 'N';
}
INSERT INTO DB CODE HERE
GiftWrapping = '$GW';
}
Cheers in advance,
Graeme :)
Public Sub House()
On Error Resume drink
If Pint.empty = True Then
Pint.refill
Else
Pint.drink
End if
stomach.add Pint
MsgBox I've had stomach.count Pints
MsgBox VERY DRUNK
End Sub
Re: [PHP-DB] Dealing with Unchecked Checkboxes
Unchecked checkboxed do not return a value. They don't return a NULL or
empty string or anything. So what you have to do is check to see if the
variable is set. If it is set, then it's checked, if it's not set, then
it's unchecked.
Kinda sucks if your variable names are dynamic, I just erase the whole
record and re-insert in that case.
-Micah
At 09:02 PM 10/26/2002 +0100, Graeme McLaren wrote:
Hey all, I'm trying to get my head around checkboxes. I can insert
checked checkboxes into a DB no problem but I get an error when the
checkboxes are unchecked. I've used the following to try and handle
unchecked checkboxes but I still get the error query was empty can
anyone point me in the right direction?
$number=count($GiftWrapping);
for($a=0;$a$number;$a++)
{
echo $GiftWrapping[$a];
if ( empty( $GiftWrapping ) )
{
$GW = 'N';
}
INSERT INTO DB CODE HERE
GiftWrapping = '$GW';
}
Cheers in advance,
Graeme :)
Public Sub House()
On Error Resume drink
If Pint.empty = True Then
Pint.refill
Else
Pint.drink
End if
stomach.add Pint
MsgBox I've had stomach.count Pints
MsgBox VERY DRUNK
End Sub
Re: [PHP-DB] Dealing with Unchecked Checkboxes
Try to assign a value for each of these variables, or elements of array.
If it is checked let's say is =1,otherwise=0. Then grab the whole set of
variables with GET_VARS or something like this. Create the new array in
the page where you insert data, and then use if's to insert data in your
tables.
I am pretty sure is not the cleanest way, but I hope it makes sense.
Mihai
On Sat, 26 Oct 2002, Micah Stevens wrote:
Unchecked checkboxed do not return a value. They don't return a NULL or
empty string or anything. So what you have to do is check to see if the
variable is set. If it is set, then it's checked, if it's not set, then
it's unchecked.
Kinda sucks if your variable names are dynamic, I just erase the whole
record and re-insert in that case.
-Micah
At 09:02 PM 10/26/2002 +0100, Graeme McLaren wrote:
Hey all, I'm trying to get my head around checkboxes. I can insert
checked checkboxes into a DB no problem but I get an error when the
checkboxes are unchecked. I've used the following to try and handle
unchecked checkboxes but I still get the error query was empty can
anyone point me in the right direction?
$number=count($GiftWrapping);
for($a=0;$a$number;$a++)
{
echo $GiftWrapping[$a];
if ( empty( $GiftWrapping ) )
{
$GW = 'N';
}
INSERT INTO DB CODE HERE
GiftWrapping = '$GW';
}
Cheers in advance,
Graeme :)
Public Sub House()
On Error Resume drink
If Pint.empty = True Then
Pint.refill
Else
Pint.drink
End if
stomach.add Pint
MsgBox I've had stomach.count Pints
MsgBox VERY DRUNK
End Sub
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Dealing with Unchecked Checkboxes
Mihail, do u mean something like this?
?
if (!isset($pick)) {
echo Fill out and submit the form below.; }
else {
$j = count($pick);
for($i=0; $i$j; $i++) {
echo Pick b$pick[$i]/b is Checkedbr /; }
}
?
form action=? echo $PHP_SELF; ?
ol
liPaintinginput name=pick[] type=checkbox value=Painting //li
liPlumbinginput name=pick[] type=checkbox value=Plumbing //li
liElectricinput name=pick[] type=checkbox value=Electric //li
/ol
input type=submit value=Submit! /
input type=reset value=Reset /
/form
Cheers,
Graeme :)
- Original Message -
From: Mihail Bota [EMAIL PROTECTED]
To: Micah Stevens [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, October 26, 2002 10:01 PM
Subject: Re: [PHP-DB] Dealing with Unchecked Checkboxes
Try to assign a value for each of these variables, or elements of array.
If it is checked let's say is =1,otherwise=0. Then grab the whole set of
variables with GET_VARS or something like this. Create the new array in
the page where you insert data, and then use if's to insert data in your
tables.
I am pretty sure is not the cleanest way, but I hope it makes sense.
Mihai
On Sat, 26 Oct 2002, Micah Stevens wrote:
Unchecked checkboxed do not return a value. They don't return a NULL or
empty string or anything. So what you have to do is check to see if the
variable is set. If it is set, then it's checked, if it's not set, then
it's unchecked.
Kinda sucks if your variable names are dynamic, I just erase the whole
record and re-insert in that case.
-Micah
At 09:02 PM 10/26/2002 +0100, Graeme McLaren wrote:
Hey all, I'm trying to get my head around checkboxes. I can insert
checked checkboxes into a DB no problem but I get an error when the
checkboxes are unchecked. I've used the following to try and handle
unchecked checkboxes but I still get the error query was empty can
anyone point me in the right direction?
$number=count($GiftWrapping);
for($a=0;$a$number;$a++)
{
echo $GiftWrapping[$a];
if ( empty( $GiftWrapping ) )
{
$GW = 'N';
}
INSERT INTO DB CODE HERE
GiftWrapping = '$GW';
}
Cheers in advance,
Graeme :)
Public Sub House()
On Error Resume drink
If Pint.empty = True Then
Pint.refill
Else
Pint.drink
End if
stomach.add Pint
MsgBox I've had stomach.count Pints
MsgBox VERY DRUNK
End Sub
--
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
Re: [PHP-DB] Dealing with Unchecked Checkboxes
I think you should a loop under the form.
my 2 cents...
Mihai
On Sat, 26 Oct 2002, Graeme McLaren wrote:
Mihail, do u mean something like this?
?
if (!isset($pick)) {
echo Fill out and submit the form below.; }
else {
$j = count($pick);
for($i=0; $i$j; $i++) {
echo Pick b$pick[$i]/b is Checkedbr /; }
}
?
form action=? echo $PHP_SELF; ?
ol
liPaintinginput name=pick[] type=checkbox value=Painting //li
liPlumbinginput name=pick[] type=checkbox value=Plumbing //li
liElectricinput name=pick[] type=checkbox value=Electric //li
/ol
input type=submit value=Submit! /
input type=reset value=Reset /
/form
Cheers,
Graeme :)
- Original Message -
From: Mihail Bota [EMAIL PROTECTED]
To: Micah Stevens [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, October 26, 2002 10:01 PM
Subject: Re: [PHP-DB] Dealing with Unchecked Checkboxes
Try to assign a value for each of these variables, or elements of array.
If it is checked let's say is =1,otherwise=0. Then grab the whole set of
variables with GET_VARS or something like this. Create the new array in
the page where you insert data, and then use if's to insert data in your
tables.
I am pretty sure is not the cleanest way, but I hope it makes sense.
Mihai
On Sat, 26 Oct 2002, Micah Stevens wrote:
Unchecked checkboxed do not return a value. They don't return a NULL or
empty string or anything. So what you have to do is check to see if the
variable is set. If it is set, then it's checked, if it's not set, then
it's unchecked.
Kinda sucks if your variable names are dynamic, I just erase the whole
record and re-insert in that case.
-Micah
At 09:02 PM 10/26/2002 +0100, Graeme McLaren wrote:
Hey all, I'm trying to get my head around checkboxes. I can insert
checked checkboxes into a DB no problem but I get an error when the
checkboxes are unchecked. I've used the following to try and handle
unchecked checkboxes but I still get the error query was empty can
anyone point me in the right direction?
$number=count($GiftWrapping);
for($a=0;$a$number;$a++)
{
echo $GiftWrapping[$a];
if ( empty( $GiftWrapping ) )
{
$GW = 'N';
}
INSERT INTO DB CODE HERE
GiftWrapping = '$GW';
}
Cheers in advance,
Graeme :)
Public Sub House()
On Error Resume drink
If Pint.empty = True Then
Pint.refill
Else
Pint.drink
End if
stomach.add Pint
MsgBox I've had stomach.count Pints
MsgBox VERY DRUNK
End Sub
--
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
