Populating a <select> with data from ajax via javascript

Question

although I found similar questions the solutions mentioned there wont seem to work for me.

What I'm trying to do:

Fetch all the table names of my database with Ajax
Fill the Table Names as options with respective values into a select field

How far I've come:

My fetch_devices php script echoes:

["test1","test2","test3"]

function FetchDevices(){
alert("Fetching");
$.ajax({
    url: 'php/sql/fetch_devices.php',
    success: function(devices) {
        var elements = Object.keys(devices).length;
        var select = document.getElementById("devices");
        var option = document.createElement("option");
        var i = 0;
        while(i < elements)
        {
            option.text= devices[i];
            option.value= devices[i];
            select.appendChild(option);
            i++;
        }

    },
    cache: false
});

}

But in the end I only see the last option "test3".....

Why is that happening?

Thanks in advance!

Best Regards,

If you are using happily jQuery to make development easy, why use Javascript in between? — Pratik Joshi
– Pratik Joshi, Commented May 25, 2015 at 17:09
var option = document.createElement("option"); should be in while loop — A. Wolff
– A. Wolff, Commented May 25, 2015 at 17:10

Zee · Accepted Answer · 2015-05-25 17:09:44Z

1

You are overriding the same option. Aslo make use of add(). Change it to

 while(i < elements)
    {
        var option = document.createElement("option");
        option.text= devices[i];
        option.value= devices[i];
        select.add(option);
        i++;
    }

answered May 25, 2015 at 17:09

Zee

8,4805 gold badges39 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Populating a <select> with data from ajax via javascript

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related