php - 如何使用 ajax 和 json 返回多个数据

Question

我正在尝试从数据库返回多个数据，然后我将使用 ajax 和 json 将其传递给 jquery，但问题是它无法正常工作。任何人都可以帮我解决它吗？这是我的代码。

Jquery

$('.highlight').click(function() {  
        var y = $(this).find("td").eq(0).find('input[type="hidden"]').val();
        var x = $(this).find("td").eq(1).text();
        var z = $(this).find("td").eq(2).text();
         //$('#ClassModal').modal('show');
        $("#spanclass").text(x);
        $("#spanclass2").text(z);
        $('#ClassModal').modal('show');     
        $.ajax({ 
              type:"GET",
              url: 'db_loadStud.php', 
              data: 'year='+x+'&subject='+z, 
              dataType: 'json', 
              success: function(data){
                for(var x=0;x<data.length; x++){
                    $(".studname").find("span").text(data[0]+", "+data[1]);
                }
              }
        });
        return false;       
    });

PHP

<?php

session_start();
include("db_conf.php");
$fid = $_SESSION['fid'];
$year = $_GET['year'];
$sub = $_GET['subject'];
$sql = "SELECT si_lname, si_fname, si_mname,si_studentno FROM `student_info` a";
$sql .= " INNER JOIN (SELECT * FROM student_enrolled WHERE se_active='True') b ON a.si_studentno=b.se_id";
$sql .= " INNER JOIN tblcourses c ON b.se_level=c.c_level WHERE c_level='$year' AND c_subject='$sub' AND c_teacher = '$fid'";
$result = mysql_query($sql);
$arr;
    while($array = mysql_fetch_row($result)){

        echo json_encode($array);

    }


?>

HTML

<div class="modal fade" id="ClassModal" style="margin-left:-400px;margin-right:auto;" tabindex="-1" role="dialog" aria-labelledby="ClassModal" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content"  style="width:1000px;">
            <div class="modal-header" style="background-color:#0a4595;color:#fff">
            <h4 class="modal-title" id="myModalLabel"><center>Landstand of Knowledge Learning School, Inc. [ <span id="spanclass"></span> - <span id="spanclass2"></span> ]</center></h4>
            </div>
            <div class="modal-body" style="height:470px;">              
                <div style="float:left;border:1px solid #0a4595;width:200px;height:435px;"> 
                    <div style="width:100%;height:30px;border-bottom:1px solid #0a4595;background-color:#0a4595;padding:5px;font-size:12;color:#fff">
                        <center>STUDENTS</center>
                    </div>
                    <div class="studname" style="width:100%;height:30px;border-bottom:1px solid #0a4595;padding:5px;font-size:12;">
                                <span id="studname"></span>
                    </div>

                </div>    
            </div>
            <div class="modal-footer" >
                <button type="button" class="btn btn-primary" data-dismiss="modal">Close</button>
        </div>
    </div>
  </div>
</div>  

提前谢谢你

Answer 1

在 for 循环中，您总是覆盖 span 的内容而不是向现有内容添加内容，因此只有数组中的最后一项可见

$(".studname").empty();
for (var x = 0; x < data.length; x++) {
    $(".studname").find("span").append(data[x][0] + ", " + data[x][1]+'<br />');
}