form with multiple options to query mysql

[laugharne]

I have a form with several check boxes. I am trying to retreive the 'model' that has the checked features form the database 'cashreg' . I am getting the following error messages

"Fatal error: Call to a member function quote() on a non-object in c:\wamp\www\compstore\handle_cashreg3.php on line 14"

Form is as follows:
<form action="../handle_cashreg3.php" method="get">
<p>
<input name="item[]" type="checkbox" id="network" value="yes">
Networkable
<input name="item[]" type="checkbox" id="touchscreen" value="yes">
Touch Screen
<input name="item[]" type="checkbox" id="printrec" value="Yes">
Print Receipts
<input name="item[]" type="checkbox" id="scanner" value="yes">
Scanner

<p>&nbsp;</p>
</body>
</html><?php

?>
<p>
<input type="hidden" name="submitted" value="yes" />
<input type="submit" value="submit" />

and the form processor is:

<?php require_once('Connections/dbcompstore.php'); 
<?PHP
// get multiple records
foreach ($_GET['item'] as $s) {
 $item[] = strtr($dbh->quote($s),array ('_' =>'\_','%' => '\%'));
 }

 $parts = join(',', $item);
 // select the model of till that has the features clicked yes
 $dbh->query("SELECT * FROM cashreg WHERE model IN ($parts)");


//print list of models
echo '<table align="center" 
cellspacing="2" cellpadding="2"> 
<tr><td align="left"><b>Model</b></td></tr> 
'; 


while ($row=mysql_fetch_array($dbh)) 
echo "<tr><td align=\"left\">" .stripslashes($row[0]). "</td><td align=\"left\">$row[1]</td></tr>\n";


echo '</table>'; 




echo '<p> there are no records</p>';


mysql_close();
?>

Help much appreciated

Thanks

Charles

[Roger_Ramjet]

Can't make head nor tail of your code, but I can tell you how to do it in sql. You are after all records that match the features selected, Yes? So, assuming your database is set up with fields for each feature, and values true or false for each model/feature, then a simple query will do it, and none of your complex pre-processing through arrays etc to build the query.

SELECT * FROM cashreg WHERE network = $GET['network'] AND touchscreen = $GET['touchscreen'] AND printrec = $GET['printrec'] AND scanner = $GET['scanner']

This query will return all models with features that match the form input, whether it be true or false for any given field.

[laugharne]

Thanks Roger,

I got code from PHP Cookbook for what it's worth.

The added complexity is that I actually have 20 checkboxes and 8 select boxes- so hence Iwas trying to create array.

Charles

[Roger_Ramjet]

Hm! 28 parameters seems like a lot, but it is just a lot of typeing. If you really want to avoid that, then itterate through the GET array and add to the query for each value present. Faster to type but slower to process. (Personally, I always use POST and only use GET when it is a hot-link not a form)

I expect that, with 28 parameters, what you will end up needing is nested queries.