The &quot;checkbox&quot; input type

The "checkbox" input type

joeywoodbury

I am having trouble with passing values from the checkbox's on my form to my query. I have my checkbox on my html form like this:

The part of the query that is supposed to be accepting this is like this:

AND (propType LIKE '$propType' OR '$propType' = ' ')

I have a print ("$listDate<br>"); before any of the $query begins and it is giving me "Array" as the value and not passing any of the values of the checkbox's through.

What am I doing wrong? Thanks a bunch for you help in advance.

kailien

are there more than one checkbox value for the property? ie, commercial, residential, etc.

if yes, you will need to extract the data from the propType[] array.

then, you will need to modify your sql query since there are more than one value for propType variable. you probabily need a for loop since you do not know how many checkboxs will be checked for each property.

OTOH, if there is only ONE value for propType, then you do NOT need the array.

joeywoodbury

yes there are four checkboxes.

question#1 - how do I extract the data from the array?

and

question#2 - how do I put a loop inside my query?

These may be stupid quesitons but I am a rookie at this. Sorry!

Thanks again!

Anon

Here is a direct quote from php.net:

http://www.php.net/manual/en/function.implode.php

This will get you started.

Hey, I found a good use for implode() today. It came from a need to have a
<select name=state multiple> box on the page that a person could
select multiple states from and send those to a >SELECT * FROM
customers WHERE state='$state'; query. But they need to be able to send
just one state also. Well, I changes the html select box to say <select
name=state[] multiple>. This turns $state into an array as you may
know. I then, later on in the script, did this:

$count = count( $state );
if( $count > 1 ) {
$states = implode( "'.'", $state );
$result = $database->query( "SELECT * FROM currentOrders
WHERE date>=$from AND date <=$to AND state IN ('$states')" );
}

//This takes care of multiple states, but if the user sent only one state,
I catch it here:

foreach( $state as $value );
if( $value )
$result = $database->query( "SELECT FROM currentOrders
WHERE date>=$from AND date<=$to AND state='$value'" );
else //This one will catch the ALL states option if they choose that.
$result = $database->query( "SELECT FROM currentOrders
WHERE date>=$from AND date<=$to" );