Newbie-Checkboxes mySQL Help!

cwilson

I will try to be as specific as I possibly can.

I have a table with the following fields.

show
channel
series
interactive
reward
romance
twist
fame
celebrity

I would like to create checkboxes for users to click on for a keyword search (for example..they want a show that is romance & twist they would check those boxes)

Within my table I already have the values of the show...if the show is a romance it will have a 1 in the romance field. If it's not a romance show then it will have a 0.

I would like the checkboxes created/formatted from an array (that way I can add more columns as needed) from the table. I would like to exclude the fields "show" "channel" "series".

After the user clicks submit I would like to for a query from the checkboxes clicked.

example

$query = "select * from reality where series = 1";

then I would like to loop through the fields that were checked and for the first field name the query string would be adding

$query .= " AND $checkboxName = 1"

then for each and every subsequent checkbox the query string would add

$query .= " OR $checkboxName = 1"

2 things I need to know:

1) How to set up the checkboxes
2) suggestions for the loop on the query

Thank you!

blr32

Hello,

I would name the checkboxes in the HTML form like this:
<input type="checkbox" name="keyword[]" value="show">
<input type="checkbox" name="keyword[]" value="channel">
etc.

This would create an array with only the values selected hence you can fairly easy do the loop:

while (list($key,$checkboxName) = each($keyword)) {
$query .= " AND $checkboxName = 1"
}

This is just untried metacode - but it should give you an idea... As always, remember to make a check on the $keyword variable to ensure that malicious users do not enter something funny...

Hope it helped.

sijis

think about something like this for the query:

$query = "Select * from Table, Table1 WHERE search = 'true' ";

if($show ==1){
$query .= "AND show_field LIKE '%$field_in_search_form%' ";
}

if(){
$query .= "AND reward_field LIKE '%$field_in_search_form%'";
}
........

mysql_query($query);

blr32

Oh - and regarding the loop of the query.

Not too sure what you mean: is this the query string you want to to end up with?:

select * from reality where (show = 1 OR channel = 1 OR etc.)

if this is the case then change the above solution to:

$where_str = '';
while (list($key,$checkboxName) = each($keyword)) {
if ($key != 0)
$where_str .= "OR ";
$where_str .= "$checkboxName = 1"
}

$query = "select * from reality where ($where_str)";

Hope this helped even more instead of confusing you... 🙂

cwilson

Thanks for your help 😃

The end result for the query string needs to look something like this:

if there are 2 or more check boxes checked then

$query = "Select * from reality where series = 1 AND $checkboxName = 1 OR $checkboxName =1 OR $checkboxName =1" etc

if there is only 1 checkbox checked then the query is just

$query = "Select * from reality where series = 1 AND $checkboxName "

Thanks for the tip on the checkbox array...Arrays confuse the heck out of me...do you have any advice or pointers where there are tutorials on arrays & loops? I really need practice on them!