jquery更改函数传递值使用ajax数据库文件。但只工作第一次
问题描述:
Jquery On Change函数只工作,当我传递值使用ajax jquery函数数据库文件使用select box.but只工作第一次第二次当我更改所选框的值。不工作为什么请帮助代码在下面给出。jquery更改函数传递值使用ajax数据库文件。但只工作第一次
if(isset($package_sort) && !empty($package_sort))
{
switch ($package_sort) {
case "1000":
$sql = "SELECT * FROM package WHERE package_city='goa' AND package_price ORDER BY package_price ASC";
break;
case "160000":
$sql = "SELECT * FROM package WHERE package_city='goa' AND package_price <=".$_GET['package_sort']." ORDER BY package_price DESC";
break;
default:
echo "Your favorite color is neither red, blue, nor green!";
}
<script>
$(function(){
$(document).on('change', '#package_sort', function(){
var package_sort = $(this).val();
$.ajax({
url:"package-search.php",
method:"GET",
data:{package_sort:package_sort},
success:function(data){
$("#package_loading").fadeIn(500).html(data);
}
});
});
});
</script>
<div class="select-wrapper"><select name="package_sort1" id="package_sort" class="custom-select selectbox">
<option value="" disabled="disabled" selected="selected" hidden="hidden">Sort By</option>
<option value="1000" name="package_sort">Low to Height</option>
<option value="160000" name="package_sort">Height to Low</option>
</select></div>
答
您还没有定义的变量$package_sort
。你也需要检查$_GET
设置或不
if(isset($_GET['package_sort']) && !empty($_GET['package_sort'])){
$package_sort = $_GET['package_sort'];
switch ($package_sort) {
case "1000":
$sql = "SELECT * FROM package WHERE package_city='goa' AND package_price ORDER BY package_price ASC";
break;
case "160000":
$sql = "SELECT * FROM package WHERE package_city='goa' AND package_price <=".$_GET['package_sort']." ORDER BY package_price DESC";
break;
default:
echo "Your favorite color is neither red, blue, nor green!";
}
}
试试这个'$(文件)。就绪(函数(){ $( “#package_sort”)。变化(函数(){ 警报(”改变“); }); });'检查警报。 – webpic