dsfdsfsdf45489 2016-10-10 14:12
浏览 13
已采纳

结合两个下拉选择来检索一个结果ajax / php

I got two dropdowns and i need to get both values to get data from my database.

$(document).ready(function(){

    $('.fabric').on('change',function(){
        var fabricID = $(this).val();
        console.log("fabric id_price is " + fabricID); //debugging
        if(fabricID){
           $.ajax({
                type:'GET',
                url:'cart_functions.php', 
                dataType: 'json',
                data: {
                  fabric_id: fabricID
                },
                success:function(html){   
                $('.icms' + id).text(data.val);                                                       


                }
            }); 
      //closing tags


    $('.size').on('change',function(){
        var sizeID = $(this).val();
        if(sizeID){
            $.ajax({
                type:'GET',
                url:'cart_functions.php',
                 dataType: 'json',
                data:{
                  size_id: sizeID
                },
                success:function(html){
                    $('.icms' + id).text(data.val);
                }
            }); 

//closing tags

i'm sending these both values to my calculate.php

<?php header('Content-Type: application/json');

 include_once '../incluedes/conn_cms.php'; 
 if(isset($_GET["size_id"],$_GET["fabric_id"])){
    $size_id=$_GET["size_id"] ;
    $fabric_id=$_GET["fabric_id"] ;

 $query3 =" SELECT * FROM valores_almofadas 
            WHERE size='$size_id'
            AND   price_id ='$fabric_id'";

        $result = mysqli_query($conn,$query3);
        while($rows = mysqli_fetch_assoc($result)){

            if($_SESSION['estado'] == 'SP'){
              $ICMS = $rows['icms_7'];
             }else{
              $ICMS = $rows['icms_12'];
             }
             $_SESSION['icms']=$ICMS;

        } echo json_encode($_SESSION['icms']);

} 

?> 

So i select a fabric and then a size fabric value is my id and size is 50 or 45.

fabricid= 1 and size = 50 <-- i am sending this to my calculate.php So i want to get back the value into a session. and the result must be on a td..

<td class="icms'.$id.'">R$:'.$_SESSION['icms'] .'</td>

But its not working, i'm not good at ajax, can you tell me whats wrong and how can i fix these mess?

  • 写回答

2条回答 默认 最新

  • dongpo1846 2016-10-10 14:35
    关注

    Make sure both values are always sent with the request

    $(document).ready(function() {
        $('.fabric, .size').on('change', sendData);
    
        function sendData() {
            var fabricID = $('.fabric').val();
            var sizeID   = $('.size').val();
    
            if ( fabricID !== "" && sizeID !== "") {
                $.ajax({
                    type     : 'GET',
                    url      : 'cart_functions.php',
                    dataType : 'json',
                    data     : {
                        fabric_id: fabricID,
                        size_id: sizeID
                    }
                }).done(function(html) {
                    $('.icms' + this.id).text(data.val);
                });
            }
        }
    });
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
  • ¥20 怎么在stm32门禁成品上增加查询记录功能
  • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面