ansaurus

Question

Dynamically generating a dropdown using json data?

Answer 1

A:

One problem I see is that in your each loop, you're just assigning j.options to myarray instead of adding it to the array. Change to:

myarray.push(j.options);

mbrevoort 2010-10-21 19:57:48

Answer 2

A:

i'm not sure what your json data looks like, but maybe you need something like this:

function Preload() {
  $.getJSON("http://localhost/conn_mysql.php", function(jsonData){  
    $.each(jsonData, function(i,j){ 
      $('#ID-OF-YOUR-SELECT-ELEMENT').append(
        $('<option></option>').val(j.value).html(j.text)
      );
    }
  );
});}

j.value = the value of the option you want to add j.text = the name of the option you want to add (what the user sees)

LAX 2010-10-21 20:08:28

it looks like [{"options":"smart_exp"},{"options":"user_intf"},{"options":"blahblah"}]

XCeptable 2010-10-21 20:17:51

Answer 3

A:

First of all, .getJSON() uses a callback, meaning that the code executed as the second argument of .getJSON() won't necessarily have been called by the time your for loop runs. It runs once the server responds with your conn_mysql.php JSON data. Try nesting it:

function Preload() {
    $.getJSON("http://localhost/conn_mysql.php", function (jsonData) {
        $.each(jsonData, function (i, j) {
            document.form1.fruits.options[i] = new Option(j.options);
        });
    });
}

You should be aware of the structure of your jsonData. Here, this would only work if the structure were:

[
    { options: "item 1" },
    { options: "item 2" },
    { options: "item 3" },
]

It loops through the entire object, finding each element of the array, then looks for that element's options property. Is that what you're looking for?

clarkf 2010-10-21 20:18:48

Grate, u r grate ...... thanX a Lot. Its working now with ur code. One problem is it works only in IE so far, do not work in firefox. I think I need to make //$('document').ready(function() working that is commented now in my this code as I was not able to fix it. Can u see it, I think it has only bracees problem. Can u kindly tell me one more thing, can PURE i.e. a JS rendering engine be used in such case. Provided I have no info so far about JS rendering engines. thanX a thousand again clarkf :-) –

XCeptable 2010-10-21 20:37:14

@babar - I'm not sure what you're asking. If you're asking about the pure templating library (http://beebole.com/pure/), sure, it could be used here. You'd need to modify your JSON data a little in the PHP script (I think, I'm unfamiliar with pure). Check out the documentation?

clarkf 2010-10-21 20:43:47

ansaurus

tags:

views:

answers:

Dynamically generating a dropdown using json data?

related questions