php - AJAX 调用过多

Question

我的代码太乱了。每次显示元素时，我都会创建 1 个 Ajax 调用。我的表有固定数量的 80 行。如何简化重复的 AJAX 调用。

HTML

<tr>
<td>
    <div class="form-group row mb-0" >
        <div class="col-12">
            <select class="form-control form-control-sm mySelect2 " name="111" id="111">
                <?php
                include ('server_side/connection.php');
                $sql = "SELECT * FROM tbl_subjects";
                $result=mysqli_query($conn, $sql);
                while ($row=mysqli_fetch_array($result)) { ?>
                <option value="<?php echo $row['subject_code'];?>"><?php echo $row['subject_code'];?></option>
                <?php } ?>
            </select>
        </div>
    </div>
</td>
<td><span id="description_111"></span></td>
<td><span id="prerequisite_111"></span></td>
<td><span id="unit_111"></span></td>

AJAX

$("#111").change(function(){
        var subject_code = $(this).val();
        $.ajax({
            type: "POST",
            url: "server_side/load_subjectdesc.php",
            data: {subject_code: subject_code},
            success: function(result){
            $("#description_111").html(result);
            }
        });
    });
    $("#111").change(function(){
        var subject_code = $(this).val();
        $.ajax({
            type: "POST",
            url: "server_side/load_subjectpreq.php",
            data: {subject_code: subject_code},
            success: function(result){
            $("#prerequisite_111").html(result);
            }
        });
    });
    $("#111").change(function(){
        var subject_code = $(this).val();
        $.ajax({
            type: "POST",
            url: "server_side/load_subjectunit.php",
            data: {subject_code: subject_code},
            success: function(result){
            $("#unit_111").html(result);
            }
        });
    });

每一项显示一个 Ajax 太多了。如何简化或删除如此多的 AJAX 调用？

Answer 1

您需要创建一个 php 页面，该页面将返回以下形式的 JSON:

{
    description: 'descriptionvalue',
    perequisite: 'perequisitevalue',
    unit: 'unitvalue'
}

然后您将向其发送 AJAX 请求，例如:

$("#111").change(function(){
    var subject_code = $(this).val();
    $.ajax({
        type: "POST",
        url: "server_side/yourpage.php",
        data: {subject_code: subject_code},
        success: function(result){
            for (var key in result) $("#" + key + "_111").html(result[key]);
        }
    });
});

您可以进一步完善它:

function myChange(idVal) {
    $("#" + idVal).change(function(){
        var subject_code = $(this).val();
        $.ajax({
            type: "POST",
            url: "server_side/yourpage.php",
            data: {subject_code: subject_code},
            success: function(result){
                for (var key in result) $("#" + key + "_" + idVal).html(result[key]);
            }
        });
    });
}