NoGodButAllah NoGodButAllah - 4 years ago 103
Javascript Question

Populate dropdown list from database using jQuery

I want to populate the dropdown list from database using jQuery. But when i tried, i am getting empty response. see below code I didn't see any error.

PHP code to get data:

if ($dat=="driver") {
$q = "select * from drivers";
$sql = mysql_query($q);
$data = array();
while($row = mysql_fetch_array($sql, true)){
$data[] = $row;
};
echo json_encode($data);
}


jQuery code:

$.getJSON("get-data.php?dat=driver",function(data){
$.each(data,function(key,val) {
$("#night_Shift_text").append(
$("<option></option>").val(value.id).html(value.id)
);
});
});


HTML:

<select id='night_Shift_text'><option></option></select>


Debug console:

enter image description here

Answer Source

Use a string to store you option and then append it to select tag and please check data is there in the val.

$.getJSON("get-data.php?dat=driver",function(data){
    var stringToAppend = "";
    $.each(data,function(key,val) {

       stringToAppend += "<option value='" + val.id + "'>" + val.id + "</option>";

    });

    $("#night_Shift_text").html(stringToAppend);
});
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download