|
|
Posted by Klaus Brune on 10/21/06 02:08
In article <1161004574.285285.137230@f16g2000cwb.googlegroups.com>,
nurazije@gmail.com says...
>
> GustavoBrust wrote:
> > 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.
> >
> > Thanks.
> >
> > Gustavo.
> 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
> http://www.nurazije.co.nr
>
>
Depending on the type of query you're building, you might not even need
foreach() ... maybe something like this...
<body>
<form
action="<?php echo $_SERVER['PHP_SELF'] ?>"
method="post"
>
<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" />
</form>
<pre>
<?php
print_r($_POST);
if(isset($_POST['id']) {
$query =
"SELECT * FROM users WHERE id='" .
implode("' OR id='",$_POST['id']) .
"'" ;
}
// do your query processing
?>
</pre>
</body>
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.
Navigation:
[Reply to this message]
|