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条)

报告相同问题?

悬赏问题

  • ¥30 YOLO检测微调结果p为1
  • ¥20 求快手直播间榜单匿名采集ID用户名简单能学会的
  • ¥15 DS18B20内部ADC模数转换器
  • ¥15 做个有关计算的小程序
  • ¥15 MPI读取tif文件无法正常给各进程分配路径
  • ¥15 如何用MATLAB实现以下三个公式(有相互嵌套)
  • ¥30 关于#算法#的问题:运用EViews第九版本进行一系列计量经济学的时间数列数据回归分析预测问题 求各位帮我解答一下
  • ¥15 setInterval 页面闪烁,怎么解决
  • ¥15 如何让企业微信机器人实现消息汇总整合
  • ¥50 关于#ui#的问题:做yolov8的ui界面出现的问题