php - 基于城市和地区的自动完成搜索

Question

您好，我一直在尝试根据选定的城市名称在数据库中创建公司或子类别的自动完整搜索，但它似乎对我不起作用。谁能帮我？下面是我的代码:

include( "dbconnect.php" );
$q = strtolower( $_GET['q'] );
$city = intval( $_GET['city_val'] );
if ( $city != "-1" )
{
    if ( !$q )
    {
    }
    else
    {
        $query = "SELECT DISTINCT concat(listing.company_name,' (',locality.locality,')') as name,listing.id as id,listing.type as type FROM listing,locality where listing.locality=locality.id AND listing.city='{$city}' AND LCASE(company_name) like '%".{$q}."%' UNION select DISTINCT sub_cat_name as name,subcategory.id as id,subcategory.type as type FROM subcategory where LCASE(sub_cat_name) like '%".{$q}."%' order by name";
    }
}
else
{
    if ( !$q )
    {
    }
    else

        $query = "SELECT DISTINCT concat(listing.company_name,'<br>(',locality.locality,' ',city.city,' ',state.statename,')') as name,listing.id as id,listing.type as type FROM listing,locality,city,state where listing.locality=locality.id AND listing.city=city.id AND listing.state=state.id AND LCASE(company_name) LIKE '%".{$q}."%' UNION select DISTINCT sub_cat_name as name,subcategory.id as id,subcategory.type as type FROM subcategory where LCASE(sub_cat_name) LIKE '%".{$q}."%' order by name";
   }
}
$results = mysql_query( $query );

while ( $result = mysql_fetch_array( $results ) )
{

    $array[] = array('name'=>$result['name'], 'id'=>$result['id'], 'type'=> $result['type']) ;
}   
echo json_encode($array);

您还可以在下面查看我的 jquery 代码:

<script>
  $(function() {
    $( "#companies" ).autocomplete({
      source: 'companies.php'
    });
  });
  </script>

Answer 1

自动完成方法将“term”作为默认键传递。所以如果你想得到结果你必须这样做:

$q = strtolower($_GET['term'] );

如果你想自定义它然后使用ajax。

看这个:

Can the default "Term" name passed in the "jquery UI autocomplete" feature be changed?