dongwuwei0718
2017-02-02 09:31
浏览 69
已采纳

使用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

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dongtan7639 2017-02-02 09:36
    已采纳

    Use a string to store your option, and then append it to the select tag. Then, please check that 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);
    });
    
    评论
    解决 无用
    打赏 举报
查看更多回答(1条)

相关推荐 更多相似问题