如何使用 jQuery 提取作为 AJAX 响应接收的 JSON 数据并将其添加到 HTML 选择下拉列表中

How to extract and add the JSON data received as a AJAX response to the HTML select drop down using jQuery?

本文关键字:数据 添加 下拉列表 选择 HTML JSON 提取 jQuery 何使用 AJAX 响应      更新时间:2023-09-26

我有以下HTML代码:

<select id="student" name="student" class="form-control"></select>

我为将选项添加到上述HTML选择控件而编写的jQuery-AJAX函数如下:

var mod_url = $('#mod_url').val(); 
$.ajax({
      url : mod_url,
      cache: false,
      dataType: "json",
      type: "GET",
      async: false,
      data: {
        'request_type':'ajax',         
      },
      success: function(result, success) { 
        $('#student').html(result);
      },
      error: function() {
        alert("Error is occured");
      }
    });

从PHP文件中,我收到了一个编码为JSON格式的大数组(即来自jQuery-AJAX函数的结果变量(。供您参考,我在下面仅显示该数组中的前四条记录。在HTML选择控件中,实际上我想显示此数组中的所有元素。

[{"id":2,"stud_name":"John Dpalma","stud_address1":"277 Eisenhower Pkwy","stud_address2":"","stud_city":"Edison","stud_state":"New Jersey","stud_country":"USA","stud_zipcode":"07039","stud_email":"abc@gmail.com","created_at":1409739580,"updated_at":1410253832},
{"id":3,"stud_name":"Anthony Gonsalvis","stud_address1":"520 Division St","stud_address2":"","stud_city":"Piscataway","stud_state":"NJ","stud_country":"USA","stud_zipcode":"07201","stud_email":"pqr@gmail.com","created_at":1409740530,"updated_at":1410255590},
{"id":4,"stud_name":"James Bond","stud_address1":"6 Harrison Street, 6th Floor","stud_address2":"Ste-2324","stud_city":"New York","stud_state":"NY","stud_country":"USA","stud_zipcode":"10013","stud_email":"xyz@gmail.com","created_at":1409757637,"updated_at":1412263107},
{"id":9,"stud_name":"Mary Jane","stud_address1":"2112 Zeno Place","stud_address2":"CA","stud_city":"Venice","stud_state":"CA","stud_country":"","stud_zipcode":"90291","stud_email":"utp@gmail.com","created_at":1409908569,"updated_at":1410254282}]

在HTML选择控件中,我想通过以下方式设置值(考虑上面数组中的前两条记录(

<select id="student" name="student" class="form-control">
  <option value="">Select Store</option>
  <option value="2">John Dpalma, 277 Eisenhower Pkwy, Edison</option>
  <option value="3">Anthony Gonsalvis, 520 Division St, Piscataway</option>
</select>

您可能已经从上面的预期输出中观察到,我想将选项的值设置为数组中的id,并且我要显示的文本包含stud_name+stud_address1+stud_city

我应该如何为代码中 JSON 数据中的所有元素管理它?

另外,请指导我将加载选项显示在选择控件中,直到PHP的响应到来。

请给我一些帮助。

success: function(result, success) { 
    var $select = $('#student');
    $.each(result, function (i, option) {
        var txt = [option.stud_name, option.stud_address1, option.stud_city];
        if (option.stud_address2)
            txt.splice(2, 0, option.stud_address2);
        $('<option>', {
            value: option.id,
            text: txt.join(', ')
        }).appendTo($select);
    });
},

或使用$.map(效率稍高(:

success: function(result, success) { 
    var options = $.map(result, function (option) {
        var txt = [option.stud_name, option.stud_address1, option.stud_city];
        if (option.stud_address2)
            txt.splice(2, 0, option.stud_address2);
        return $('<option>', {
            value: option.id,
            text: txt.join(', ')
        });
    });
    $('#student').append(options);
},

在 PHP 文件中循环回显以下内容:

echo '<option value="">'.$stud_name.', '.$stud_address1.', '.$stud_address2.', '.$stud_city.', '.$stud_state.', '.$stud_country.'</option>';

然后通过 ajax 成功将此结果附加到使用 jQuery 的选择下拉列表中。

这是我

的解决方案。这将检查地址 2 并将其相应地添加到选项中。

JS代码:

for(var i=0;i<result.length;i++){
    if(result[i]["stud_address2"]==""){
        $('#student').append('<option value="' + result[i]["id"] + '">' + result[i]["stud_name"] + ', ' + result[i]["stud_address1"]+ ', ' +result[i]["stud_city"] +'</option>');}
    else{
     $('#student').append('<option value="' + result[i]["id"] + '">' + result[i]["stud_name"] + ', ' + result[i]["stud_address1"]+ ', '+ result[i]["stud_address2"]+ ', ' +result[i]["stud_city"] +'</option>');
    }
}

这是一个有效的演示

这正是您所需要的!

$(document).ready(function(){
   var mod_url = $('#mod_url').val(); 
   $.ajax({
         url : mod_url,
         cache: false,
         dataType: "json",
         type: "GET",
         async: false,
         data: {
            'request_type':'ajax',         
         },
         success: function(result, success) { 
           $.each(result,function(index,item){ 
             $label = item.stud_name +', ' + item.stud_address1 +', ' + item.stud_city;
             $('#student').append('<option value="'+ item.id +'">'+ $label +'</option>');  
           });
         },
         error: function() {
           alert("Error is occured");
         }
   });
});
这是遍

历从服务器接收的 JSON,为每个记录创建选项标记,然后将它们附加到 select 元素的问题:

var response = [{"id":2,"stud_name":"John Dpalma" ... }]
$.each(response, function (index, record) {
  if (!record.stud_address2){
    var stud_address2 = "";
  } else {
    var stud_address2 = record.stud_address2;
  }
  $('<option>', {
    value: record.id,
    text: record.stud_name + ", " + record.stud_address1 + ", " + record.stud_city + ", " + stud_address2
  }).appendTo("#student");
});

演示

     <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.18/jquery-ui.min.js"></script>
   <script>
 function __highlight(s, t) {
        var matcher = new RegExp("(" + $.ui.autocomplete.escapeRegex(t) + ")", "ig");
         return s.replace(matcher, "<strong>$1</strong>");
               }
    $(document).ready(
              function() {
                 $("#suggest").autocomplete(
                  {
                    source : function(request, response) 
                {
                    $.ajax({
                            url : 'URL',
                            dataType : 'json',
                            data : { term : request.term },
                            success : function(data) 
                                        {
                                            //alert(data[0].title);
                                            response($.map(data, function(item) {
                                                        //alert(item);
                             return {                                                           
                    label : __highlight(item.title, request.term),
                   value : item.title
                        };
                                                                                }));
                                        }
                        });
                },
        minLength : 3,
        select : function(event, ui) 
                {
                    if(ui.item){
                        $(event.target).val(ui.item.value);
                        }
                        //submit the form
                    $(event.target.form).submit();
                }
        }).keydown(function(e) {
                                    if (e.keyCode === 13) 
                                    {
                                        $("#search_form").trigger('submit');
                                    }
                                }).data("autocomplete")._renderItem = function(ul, item) 
                                                                    {
                            return $("<li></li>").data("item.autocomplete", item).append(
                            $("<a></a>").html(item.label)).appendTo(ul);
                                                                    };
        });
               </script>