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: