使用jquery和ajax用数据库值加载select

Question

我使用jquery为select选项添加div。

var div_secretary = div_secretary + '<div>Secretary:';
var div_secretary = div_secretary + '<select style="margin-left:5px;" id="select_reviewer_secretary" >';
var div_secretary = div_secretary + '<option>-select-</option>';
var div_secretary = div_secretary + '</select></div>

我用于获取数据库值的jquery函数是

$(function() {
    var items = "";
    $.getJSON("GetSecretaries.php", function(data) {

        $.each(data, function(index, item) {
            items += "<option value='" + item.CODE + "'>" + item.SUBCODE + "</option>";
        });
        $("#select_reviewer_secretary").html(items);
    });
});

获取数据库的php代码是

$tac_Secretaries = array();

while ($result = oci_fetch_assoc($parse_Reviewer_test)) {
    $tac_Secretaries[] = $result;
}

echo json_encode(array('value' => $tac_Secretaries));

当我加载页面时，我得到json值如下

{"value":[{"CODE":"3621","SUBCODE":"4"},{"CODE":"1561","SUBCODE":"1"}]}

在这里，如何将这些值加载到select选项中。提前感谢

Answer 1

更改PHP代码或jQuery代码，

我建议修改PHP代码，将最后一行更改为：

echo json_encode($tac_Secretaries);