Hi,

I am currently trying to do a search on google and php-editors to check if there're any existing threads regarding about creating a search query with 2 search values pass by POST method instead of one.

Anyone has any idea what is it called?

I am trying to post 2 queries where user will type the relevant data in the search box and using the drop down list available to search in the database.

Can i do a search query like this:

Thanks.

Is it possible to do a search where user can either search by 1 value or search by 2 values in a single POST command?
in case my sentence is not clear, below is an example.

[HTML]
device search:
site search :


User can either search by device or by site and
can do a search by both entry.
[/HTML]

Can this be done?? if so, are there any examples available to have a look?

Thanks Xnuiem,

I am working on the code with a pagination script you altered for me few weeks ago.


How/Where do i include the $_GET['search'] for both values.

Previously:
[PHP]
$val_d = '';
if ($_POST['devicesearch']){ $val_d = $_POST['devicesearch']; }
else if ($_GET['search']){ $val_d = urldecode($_GET['search']); }

if ($val_d != '')
{
$sql = "SELECT *
FROM device
WHERE device_num LIKE '%$val_d%'";
.
.
.

echo "

[align=center]Page $pagenum of $last

"; // This shows the user what page they are on, and the total number of pages
if($pagenum>1)
{
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1&search=" . urlencode($val_d) . "'>First</a> ";
$previous = $pagenum-1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous&search=" . urlencode($val_d) . "'><<</a>  ";
}
//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
if ($pagenum == $last)
{
}
else
{
$next = $pagenum+1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next&search=" . urlencode($val_d) . "'>>></a> ";
echo " ";
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last&search=" . urlencode($val_d) . "'>Last</a> ";
[/PHP]

I had tried to do it in a similar way but it doesnt seem to work well.
NOW: [PHP]$val_d = '';
$val_sub='';
if ($_POST['device_search']){ $val_d = $_POST['device_search'];}
else if ($_GET['search']){ $val_d = urldecode($_GET['search']); }

if ($_POST['subconsite']){ $val_sub = $_POST['subconsite'];}
else if ($_GET['search']){ $val_sub = urldecode($_GET['search']); }

if (trim($val_d) != '' && trim($val_sub) != ''){
$sql = "select * from device";
if (trim($val_d) != ''){
$sql .= " where device_num like '%" . trim($val_d) . "%' ";
$where = true;
}
if (trim($val_sub) != ''){
if (!$where){
$sql .= " where subcon_site like '%" . trim($val_sub) . "%' ";
}
else {
$sql = str_replace("where ", "where (", $sql);
$sql .= " and subcon_site like '%" . trim($val_sub) . "%') or (device_num like '%" . trim($val_d . "%' or subcon_site like '%" . trim($val_sub) . "%')";
}
}
else {
die("NO SEARCH TERMS");
}

.
.
.
.

echo "

[align=center]Page $pagenum of $last

"; // This shows the user what page they are on, and the total number of pages
if($pagenum>1)
{
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1&search=" . urlencode($val_d) . " + " . urlencode($val_sub) . "'>First</a> ";
$previous = $pagenum-1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous&search=" . urlencode($val_d) . " + " . urlencode($val_sub) . "'><<</a>  ";
}
//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
if ($pagenum == $last)
{
}
else
{
$next = $pagenum+1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next&search=" . urlencode($val_d) . " + " . urlencode($val_sub) . "'>>></a> ";
echo " ";
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last&search=" . urlencode($val_d) . " + " . urlencode($val_sub) . "'>Last</a> ";

[/PHP]
I know something has to be changed here in order to view the search of both values. But i just cant figure out how to. can you assist me? Thanks

Form is:
[PHP]<form action="searchprocess.php" method="post">
<table border=0 cellspacing=1 cellpadding=3 bgcolor;"#353535"
align="center">
<tr>
<td bgcolor="#eeeeff" width="50%">
Device Number
</td>
<td bgcolor="#eeeeff" width="50%">
<INPUT type = "TEXT" name = "device_search">
</td>
</tr>
<td bgcolor="#eeeeff">
Subcon Release Site
</td>
<td bgcolor="#eeeeff">
<SELECT name="subconsite">
<option value=" "SELECTED></option>
<option value="A">A</option>
<option value="B">B</option>
<option value="B1">B1</option>
<option value="B2">B2</option>
<option value="C">C</option>
<option value="C1">C1</option>
<option value="D">D</option>
<option value="E">E</option>
</SELECT>
</td>
<tr>
<td bgcolor ="eeeeff" colspan=2 align="center">
<INPUT Type="SUBMIT" name="submit" value="Device Search">
</td>
</tr>
</table>
</form>[/PHP]

Hi Xnuiem,

is this form ok?