带有双下拉列表的 PHP 搜索框

这是更新的代码。

分类广告表

ID | title | 描述 | state_id | city_id |

1 福特 | 福特出售| 1 | 1

2 福特 | 福特探索者| 2 | 1

状态表

ID | 姓名 |

1 德克萨斯州2 亚利桑那州

城市表

---

ID | name | state_id

1

阿灵顿 12 地球仪 2

执行搜索和打印结果的代码都在这里：

所以这个文件叫做搜索.php

enter  <?php
   $conn = mysql_connect('localhost', 'root','');
  $db = mysql_select_db('files',$conn);
  $input = $_GET['query'];
  $state = $_POST['state'];
 $city = $_POST['city'];
 if (isset($input) && $input != "" ) {
 $select = "SELECT * FROM classifieds";
 $where = " WHERE (title like '%" . $input . "%'  OR description like '%" . $input .   
 "%')";
if (!empty($city)) {
$select .= " LEFT JOIN city ON classifieds.city_id=city.id";
$where .= " AND city.name = '" . $city . "'";
}
if (!empty($state)) {        
$select .= " LEFT JOIN state ON classifieds.state_id=state.id";
$where .= " AND state.name = '" . $state . "'";
}    
$q = $select . $where . ' ORDER BY date DESC';
$r = mysql_query($q);
$rows = mysql_num_rows($r);
}
echo $rows; ?> Search Results For: <?PHP echo $input; 
if ($rows > 0) {
while ($row = mysql_fetch_array($r, MYSQL_ASSOC)) {
$description = $row['description'];
echo "  <tr  >
<td ><a href='classified-" . $row['adid'] . ".htm' >" . $row['title'] . "</a><br />
 <span><em><a href='category-" . $cat . ".php'>" . $catname . "</a></em><br/>" .    
$description . "...</span></td>
 </tr>
  ";
  }
   }
  ?>
   <form action="search.php" method="get">
   <input type="text" name="query" />
  <input type="submit" name="Submit" value="Search" />
   <select name="state" >
<option value="null"></option>
<?php
//POPULATE DROP DOWN MENU WITH STATES FROM A GIVEN REGION, COUNTRY
$sql = "SELECT id, statename FROM state";
$states = mysql_query($sql,$conn);
while($row = mysql_fetch_array($states))
{
    echo ("<option value=".$row[id]." >$row[statename]</option>");
}
?>
</select>
<select name="city" >
<option value="null"></option>
<?php
$sql = "SELECT id, city FROM city  ";
$cities = mysql_query($sql,$conn);
while($row = mysql_fetch_array($cities))
{
    echo ("<option value=".$row[id].">$row[city]</option>");
}
?>  here

$select = "SELECT * FROM classifieds";
$where = " WHERE (title like '%" . $input . "%'  OR description like '%" . $input . "%')";
if (!empty($city)) {
    $select .= " LEFT JOIN city ON classifieds.city_id=city.id";
    $where .= " AND city.name = '" . $city . "'";
}
if (!empty($state)) {        
    $select .= " LEFT JOIN state ON classifieds.state_id=state.id";
    $where .= " AND state.name = '" . $state . "'";
}    
$q = $select . $where . ' ORDER BY date DESC';

  $select = "SELECT * FROM classifieds";
      $where = " WHERE (title like '%" . $input . "%'   OR description like '%" .  
       $input . "%' )";
          if (!empty($state)) {        
        $where .= " AND state_id = '" . $state . "'";
        }
       if (!empty($city)) {
        $where .= " AND city_id = '" . $city . "'";
       } 
     $query = $select . $where . ' ORDER BY date DESC';