首页 > 解决方案 > 如何从数据库中获取数据并在 JavaScript、Ajax、MySQL 的 select2 下拉列表中显示?

问题描述

需要在数据库的 select2 下拉列表中显示数据。我想显示之前是否选择了多个时间间隔并输入数据库。因此,当我想更新特定数据时,如何在 select2 下拉列表中显示多个时间间隔。

下面是我使用 Ajax 从数据库中获取数据的脚本:

function getpincodedata(){
        var pincodeid = '<%=pid%>';
        var url = "../api/get/pincode";
        $.post(url, {
            pincodeid : pincodeid,
        }, function(data, status) {
            if (data.status == "OK") {
                if (data.statusCode == 1) {
                    if(data.response != null){
                        document.getElementById('edpincode').value = data.response.pincode;
                        document.getElementById('edcity').value = data.response.delivercityid.city;
                        document.getElementById('eddeliverycharge').value = data.response.deliverycharge;
                        document.getElementById('eddeliverytime').value = data.response.deliverytime; 
                        document.getElementById('midnightcharge').value = data.response.midnightcharge;
                        document.getElementById('morningcharge').value = data.response.earlymorningcharge;
                        document.getElementById('fixedcharge').value = data.response.fixedcharge;
                        document.getElementById('fixedtimeslot').value = data.response.fixedtimeslot;
                        var status = data.response.status;
                        if(status == '1'){
                            edactivestatus.checked = true;
                        }else{
                            edinactivestatus.checked = true;
                        }
                        var timeslot = data.response.timeslot;
                        if(timeslot == 'multi'){
                            edmultitime.checked = true;
                            if(edmultitime.checked == true){
                                document.getElementById('multidiv').style.display = 'contents';
                                document.getElementById('unidiv').style.display = 'none';
                            }
                        }else{
                            edunitime.checked = true;
                            if(edunitime.checked == true){
                                document.getElementById('unidiv').style.display = 'contents';
                                document.getElementById('multidiv').style.display = 'none';
                            }
                        }
                        var nightservice = data.response.nightservice;
                        if(nightservice == 'multi'){
                            multinightservice.checked = true;
                        }else{
                            uninightservice.checked = true;
                        }
                        var morningservice = data.response.morningservice;
                        if(morningservice == 'yes'){
                            activeservice.checked = true;
                        }else{
                            inactiveservice.checked = true;
                        }
                        var fixedtimeservice = data.response.fixedtimeservice;
                        if(fixedtimeservice == 'yes'){
                            afixedtimeservice.checked = true;
                        }else{
                            inacfixedtimeservice.checked = true;
                        }
                    }
                } else {
                    var error = data.responseMessage;
                    swal(error, "", "error");
                }
            } else {
                var error = data.responseMessage;
                swal(error, "", "error");
            }
        });
    }

请给我有用和宝贵的建议。

显示打印在控制台上的日志的屏幕截图 显示问题 UI 的屏幕截图

标签: javascriptjqueryajaxjspjquery-select2

解决方案


推荐阅读