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> 
+0

试试这个'$(文件)。就绪(函数(){ $( “#package_sort”)。变化(函数(){ 警报(”改变“); }); });'检查警报。 – webpic

您还没有定义的变量$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!"; 
    } 
} 
+0

我也是保存价值$ _GET [ 'package_sort']在$ package_sort –

+0

ü可以发布您的完整代码.. – MSA

+0

jQuery代码 - –