doukan4039 2015-03-23 16:08
浏览 77
已采纳

JSON无法使用OnChange事件

I originally coded this piece to bring back a single data point. I realized I needed more fields returned with an onchange event (drop down select) and changed it to use JSON. It is not returning any data. The drop down is built dynamically through PHP when the page is first loaded. I'm new to this, so any help would be much appreciated.

Dropdown Code:

<p id="dropdown"   style="DISPLAY: none" >
        <?php
            $query = "call test.spsMSTR_AllCatListBuild";
            $stmt = $conn->query( $query );

            $dropdown = "<select id='catlist' name='catlist' onchange='getval(this);'>";
                $dropdown .= "
<option value= 'NA'>Select Category</option>";
                foreach ($stmt as $row) {
                  $dropdown .= "
<option value='{$row['ID']}'>{$row['RPT_NAME']}</option>";
                }

                $dropdown .= "
</select>";
                echo $dropdown;
                $conn = null;
        ?>
    </p>

Ajax/JSON code:

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script> 
<script id="source" language="javascript" type="text/javascript">

       $(document).ready(function(){
            $("#catlist").change(function(){
            var vid = document.getElementById("catlist").value;

            $.getjson("ajax.php",
            {catid:vid},
            function(result){
                alert(result); }
                .error(function(xhr) {
                    alert(xhr)
                })
                ; )
        })})

  </script>

PHP Code:

<?php include('./DBConfig.php'); ?>
<?php

    $vid = $_GET["catid"];
    $query =  "SELECT RPT_NAME, ACTIVE FROM test.MSTR_REPORT_MASTER WHERE ID = $vid" ;
    $stmt = $conn->query( $query );
    //$result = $stmt->fetchColumn();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    echo json_encode($result);
?>
  • 写回答

2条回答 默认 最新

  • dongsutao8921 2015-03-23 16:24
    关注

    So, I have corrected your errors and you should have the below for it to work with no errors, unless there is something else that is causing errors.

    <select id='catlist' name='catlist'>
        <option value='NA'>Select Category</option>
        <option value='id1'>val1</option>
        <option value='id2'>val2</option>
        <option value='id3'>val3</option>
    </select>
    
    $(function(){
        $("#catlist").change(function() {
            var sVal = $(this).val();
            if (sVal !== "NA") { // I am assuming you don't want to make an ajax call when the value is 'NA'!
                $.getJSON("ajax.php", {catid: $(this).val()}, function(result) {
                    alert(result); 
                });
                //by the way $(this).val() = id1|id2|id3
            }
        });
    });
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!
  • ¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像,如何解决?
  • ¥15 求daily translation(DT)偏差订正方法的代码
  • ¥15 js调用html页面需要隐藏某个按钮
  • ¥15 ads仿真结果在圆图上是怎么读数的
  • ¥20 Cotex M3的调试和程序执行方式是什么样的?
  • ¥20 java项目连接sqlserver时报ssl相关错误
  • ¥15 一道python难题3
  • ¥15 牛顿斯科特系数表表示