NoGodButAllah NoGodButAllah - 4 years ago 121
Javascript Question

populate dropdown list from database use jquery

enter image description hereI want to populate dropdown list from database use jQuery but it come always empty 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>

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