用json填充下拉列表 [英] Fill dropdown list with json

问题描述

我有带有列id和名称的SQLite表。我从autocomplete.php页面返回像json这样的行的数组。如何使用jquery和JavaScript使用此json填充选项（下拉列表）？我是JavaScript和JQuery的新手，我用谷歌搜索但没有找到。在ASP.NET中这很容易，但在这里我不知道。有人会帮忙吗？

I have SQLite table with columns id and name. I return array of those rows like json from autocomplete.php page. How to fill select with options ( drop down list ) with this json using jquery and JavaScript ? I am new to JavaScript and JQuery, I googled but didn't find how. In ASP.NET this is easy but here I don't know. Would somebody help ?

这是我的JSON的例子，可以更长。

This is example of my JSON, can be much longer.

[
    {
        "id": "1",
        "name": "test"
    },
    {
        "id": "1",
        "name": "test"
    }
]

推荐答案

HTML：

<select id="sel">

</select>

JavaScript：

JavaScript:

$(function() {
    var data = [
        {
        "id": "1",
        "name": "test1"},
    {
        "id": "2",
        "name": "test2"}
    ];
    $.each(data, function(i, option) {
        $('#sel').append($('<option/>').attr("value", option.id).text(option.name));
    });
})

这是一个有效的例子。 http://jsfiddle.net/ms2Ma/

Here's a working example. http://jsfiddle.net/ms2Ma/

这篇关于用json填充下拉列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！