Dynamic search with checkboxes

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Hello everyone.

I'm having a problem with a search I want to make.

It's like this:

The user can choose about 15 checkboxes to be his search pattern.
According to the combination of checkboxes checked, I must do a
different query.

Is it really necessary to make 15 if...else statements and type in a
query for every combination the user may choose?

If anyone knows any easier way to do it, please help me.



Re: Dynamic search with checkboxes

GustavoBrust wrote:
Quoted text here. Click to load it
You can post the checkboxes as one array from html, then in use foreach
with one if statement in it.
If you provide us the code it will be easier to determine ...
For php/ajax/javascript tutorials and tips, visit me on my blog at

Re: Dynamic search with checkboxes

nurazije@gmail.com says...
Quoted text here. Click to load it
Depending on the type of query you're building, you might not even need  
foreach() ... maybe something like this...

    action="<?php echo $_SERVER['PHP_SELF'] ?>"  
Quoted text here. Click to load it
<input type="checkbox" name="id[]" value="1" /><br />
<input type="checkbox" name="id[]" value="2" /><br />
<input type="checkbox" name="id[]" value="3" /><br />
<input type="checkbox" name="id[]" value="4" /><br />
<input type="submit" />
if(isset($_POST['id']) {
    $query =  
        "SELECT * FROM users WHERE id='" .  
        implode("' OR id='",$_POST['id']) .  
        "'" ;
// do your query processing

Of course you'd want to do a bit of validation first. And there are  
other issues, for example, escaping single quotes, depending on whether  
nor not Magic Quotes is enabled on your server.

Site Timeline