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:

$.each(data,function(key,val) {


<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.

    var stringToAppend = "";
    $.each(data,function(key,val) {

       stringToAppend += "<option value='" + + "'>" + + "</option>";


Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download