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:
Recommended for you: Get network issues from WhatsUp Gold. Not end users.
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