Result of checkbox selection into an SQL request

[Nicolas Rubin]

Hi,

I would transfer the result of a checkbox selection into an SQL request.

Could you help me ?

Many thanks in advance

Nicolas

[Marcin Dobrucki]

Nicolas Rubin wrote:

I would transfer the result of a checkbox selection into an SQL request.
Could you help me ?

Checkboxes are a bit of a problem: they will only be submitted if
checked. However, the positive thing is that they take the "value"
argument, so basically you can make then anything.

Suggestion: use HTML_QuickForm, and then use the advcheckbox element,
which removes the need to check if the variable has been set or not, you
only need to worry about processing the value. (=> pear.php.net)

/Marcin

[Barry]

<?php
$sql="select id, name from table";
if (isset($_POST['fieldname'])){
$sql.=" where field='blue'";
}else{
$sql.=" where field='red'";
}
?>
Nicolas Rubin wrote:

Hi,

I would transfer the result of a checkbox selection into an SQL request.

Could you help me ?

Many thanks in advance

Nicolas

[Erwin Moller]

Nicolas Rubin wrote:

Hi,

I would transfer the result of a checkbox selection into an SQL request.

Could you help me ?

Many thanks in advance

Nicolas

Hi

If you expect a checkbox named 'clientwantsspam', try this in the receiving
script:

$clientwantsspam = "N";
if (isset($_POST["clientwantsspam"])){
$clientwantsspam = "Y";
}

or any other variation that suits your needs.

eg: if you want the VALUE of the checkbox:
$clientwantsspam = "notavailable";
if (isset($_POST["clientwantsspam"])){
$clientwantsspam = $_POST["clientwantsspam"];
}
The point/problem is that the checkbox is only send when checked, so your
receiving script must test if it exists.

Of course you can also use shorthandnotation:
$clientwantsspam = ((isset($_POST["clientwantsspam"]) ?
$_POST["clientwantsspam"]: "NotAvailable");

which probably wrapped in your newsreader. ;-)

Good luck.

Regards,
Erwin Moller

[Sandman]

In article <43**********@news.bluewin.ch>, Nicolas Rubin <nr*@e-systems.ch>
wrote:

Hi,

I would transfer the result of a checkbox selection into an SQL request.

Could you help me ?

Yes, but not until you actually give us a bit more information about what you
want to do.
--
Sandman[.net]