I am trying to create a dropdown box where it has from 10 - 90, I want each value to stand for the numbers in between (so 10 will hold 11, 12, 13, 14.. and so on and so forth). So if a user clicks on 10 it will display any entries in a database that range from 10 - 19, not just entries with "10" in it.
Is it possible to add multiple values within an option tag? Here is what I have attempted so far.
HTML:
<body>
<form action="form3.php" method="post">
<label for ="description">Description:</label>
<input type="text" name="descrip" /><br />
<label for="trayheight">Height: </label>
<select name="trayheight">
<option value="">All</option>
<option value="10">10</option>
<option value="[20:21:22:23:24:25:26:27:28:29]">20</option>
<option value="30">30</option>
<option value="40">40</option>
<option value="50">50</option>
<option value="60">60</option>
<option value="70">70</option>
<option value="80">10</option>
<option value="90">90</option>
</select><br />
<label for="trayrange">Trayrange: </label>
<select name="trayrange">
<option value="">All</option>
<option value="BBQ">BBQ</option>
<option value="Dessert">Dessert</option>
<option value="Display">Display</option>
<option value="Meat">Meat</option>
<option value="Microwave">Microwave</option>
<option value="Party">Party</option>
<option value="Salad/Wet Pasta">Salad/Wet Pasta</option>
<option value="Snacks">Snacks</option>
<option value="Standard">Standard</option>
</select><br />
<label for ="traytype">Traytype: </label>
<select name="traytype">
<option value="">All</option>
<option value="Open">Open</option>
<option value="Cavitised">Cavitised</option>
<option value="Lid">Lid</option>
<option value="Tray">Tray</option>
<option value="Coallition">Coallition</option>
<option value="Bowl">Bowl</option>
<option value="Hinge pack">Hinge pack</option>
<option value="Pot">Pot</option>
<option value="Base & Lid">Base and Lid</option>
<option value="Rectangular">Rectangular</option>
<option value="Specalist">Specialist</option>
</select><br />
<label for="trayshape">Trayshape: </label>
<select name="trayshape">
<option value="">All</option>
<option value="Rectangular">Rectangular</option>
<option value="Oval">Oval</option>
<option value="Square">Square</option>
<option value="Insert">Insert</option>
<option value="Round">Round</option>
<option value="Open">Open</option>
</select><br />
<input type="submit" value="Submit" />
</form>
</body>
PHP:
<body>
<?php
$con = mysql_connect ("localhost", "root", "");
mysql_select_db ("delyn_db", $con);
if (!$con)
{
die ("Could not connect: " . mysql_error());
}
$descrip = mysql_real_escape_string($_POST['descrip']);
$width = mysql_real_escape_string($_POST['width']);
$depth = mysql_real_escape_string($_POST['depth']);
$varHeight= mysql_real_escape_string($_POST['trayheight']);
$varRange = mysql_real_escape_string($_POST['trayrange']);
$varType = mysql_real_escape_string($_POST['traytype']);
$varShape = mysql_real_escape_string($_POST['trayshape']);
$varImage = mysql_real_escape_string($_POST['imagename']);
$sql = "SELECT * FROM delyn WHERE
description LIKE '%".$descrip."%'
AND trayheight LIKE '%".$varHeight."%'
AND trayrange LIKE '%".$varRange."%'
AND traytype LIKE '%".$varType."%'
AND trayshape LIKE '%".$varShape."%'";
$r_query = mysql_query($sql);
while ($row = mysql_fetch_array($r_query))
{
echo '<br /> <img src=" '. $row['imagename'] . '" width="180" length="100">';
echo '<br /> Tool Code: '. $row['toolcode'];
echo '<br /> Description: '. $row['description'];
echo '<br /> Tray range: '. $row['trayrange'];
echo '<br /> Tray type: '. $row['traytype'];
echo '<br /> Tray size: '. $row['traysize'];
echo '<br /> Tray shape: '. $row['trayshape'] . '<br />' . '<br />';
}
if (mysql_num_rows($r_query) <= 0){
echo 'No results match your search, please try again';
}
?>
</body>
Thanks in advance anyone who can help :)
Simple answer: you cannot store multiple values in one option tag value.
The simplest and safest solution would be to store one value in the option value (e.g. 10) and then treat this as a range from the value set to the next multiple of 10:
'AND col >= '.$value.' AND col < '.$value+10
A second solution would be to set the value to be a range like 10-19 and then on the server side:
list($min,$max) = explode('-',$value);
... 'AND col >= '.$min.' AND col <= '.$max ...
Another solution would be to store a JSON encoding of an array containing the values you wish to encapsulate in the one option and then decode the value on the server side:
'AND col IN ('.implode(',',json_decode($value)).')'
I personally would avoid the JSON approach as it is overkill for this kind of problem.
I am assuming you are retrieving this integers from the PHP source code. In that case, just store this logic somewhere in your database, php file or some sort of a config file in order to keep this logic server-sided. It is not possible to store multiple values in one option, that's the idea of an option. Or you would have to store it as a json_encode string, but I am not sure if that is what you want.
It would safer as well to put this on your server-side, I am not sure what you are creating, but safety is always a pre.
The value of an <option> can be any string; it's up to your server-side code to interpret that string appropriately.
Rather than always using the string-match operator LIKE in your SQL, you need to choose appropriate conditions for each of your columns.
For instance, set your value to be a range specified by min and max: <option value="11-20">foo</option> and then use <= and >= in your SQL (beware of "fence-post errors"!)
list($min,$max) = explode('-', $_POST['trayheight']);
$sql .= 'And trayheight >= ' . intval($min) . ' And trayheight <= ' . intval($max);