我有一个名为index.php的页面,在菜单中,我必须根据城市选择城市,我必须在自动suggetions.here中显示区域名,我要将下拉城市列表id存储如下:现在我的主题是必须将jquery值传递给autocomplete.php页面
index.php:
<select class="form-control" name="city" id="city">
<option value=''>Select city</option>
<?php while($row=mysql_fetch_array($result)) { ?>
<option value="value="<?php echo $row['CITY_ID']; ?>"><?echo $row['CITY_TITLE']?></option>
<?php } ?>
</select>
searchget.js(included in index.php):
$("#city").change(function() {
var city_id=$('#city').val();
alert(city_id);
$.ajax({
url: "autocompleteloc.php",
type: "POST",
data: { city_id1: city_id},
success: function (result) {
alert('success');
CallSearch();
}
});
});autocomplete.php:
这个页面有区域代码:现在我必须在这个页面中传递jquery变量中的城市id,
<?php
ini_set("display_errors",1);
include("config.php");
$q=$_POST['search'];
$cid=$_REQUEST['city1'];
$my_data=mysql_real_escape_string($q);
echo $sql="SELECT DISTINCT UNIT_AREA,CITY_ID FROM UNIT WHERE UNIT_AREA LIKE '%$my_data%' and CITY_ID='$cid'";
$result = mysql_query($sql) or die(mysql_error());
if($result)
{
while($row=mysql_fetch_array($result))
{
echo $row['UNIT_AREA']."\n";
}
}
?>发布于 2015-09-12 09:30:59
您可以在php中有值,这是在ajax参数中传递的
data: { CITY_ID1: CITY_ID},
因此,在php中,您可以获得以下值
$_POST['CITY_ID1']
您应该学习使用PHP的ajax post。
https://stackoverflow.com/questions/32537225
复制相似问题