对于组织名称
$searcho=$_GET["term"];
$seachArray = explode(',',$searcho);
$q='';
foreach($seachArray as $term){
$q .=" title like '%".trim($searcho)."%' or ";
}
$q =substr($q,0 ,-3);
$query=mysql_query("SELECT * FROM sltdb_cddir_content where ($q) AND categories_id=80 ");
$json=array();
while($display=mysql_fetch_array($query)){
$json[]=array(
'label'=> $display['title'],
'value' => $display['title'],
);
}
在您发表评论后进行了编辑
$searcho=$_GET["term"];
$query=mysql_query("SELECT * FROM sltdb_cddir_content where title like '%".$searcho."%'AND categories_id=80 ");
$json=array();
while($display=mysql_fetch_array($query)){
$json[]=array(
'label'=> $display['title'],
'value' => $display['title'],
'address' =>$display['fulladdress'],
);
}
这会将地址包含到您的结果中。现在你必须在你的 js 中工作,如下所示。
jQuery("#searcho").autocomplete({
source:'<?php echo JURI::root().'modules/mod_jomdirectory_search/tmpl/gov.php'; ?>',
minLength:1
select: function (event, ui) {
var address = ui.item.address;
jQuery("#addresso").val(address);
}
});
Ref -- Jquery 在选择事件上自动完成 https://stackoverflow.com/questions/12722891/jquery-autocomplete-on-select-event