Jquery json parsing for select

Question

Hallo,

I have this json:

{
    "ROWCOUNT":5,
    "COLUMNS":["ID","REGIONE"],
    "DATA":{
    "ID":[1,2,4,3,5],
    "REGIONE":["Abruzzo","Campania","Emilia","Molise","Toscana"]
}

I want retrieve value from ID and REGIONE with jquery, to fill a select. I have tried this one:

for(var COLUMNS in data) {
    jQuery.each(data[COLUMNS], function(i, row) {
        alert(row)          
    });
}

but I don't know how to combine one ID with the REGIONE, to obtain <option value="#ID#">#REGIONE#</option>.

Thank you.

What exactly are you trying to do?

SLaks
– SLaks

2009-12-31 18:56:44 +00:00
Commented Dec 31, 2009 at 18:56 — SLaks
– SLaks, Commented Dec 31, 2009 at 18:56

Tatu Ulmanen · Accepted Answer · 2009-12-31 18:56:52Z

1

If I understood your question correctly, you're looking for something like this:

var options = [];
for(var i in data.ID) {
    var option = $('<option />');
    option.val(data.ID[i]).html(data.REGIONE[i]);
    options.push(option);
}
$('select').html(options);

answered Dec 31, 2009 at 18:56

Tatu Ulmanen

125k34 gold badges190 silver badges185 bronze badges

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

Comments

SLaks · Accepted Answer · 2009-12-31 19:13:53Z

0

You can do it like this:

for(var i = 0; i < data.ID.length; i++) {
    var option = $('<option></option').attr('value', data.ID[i]).text(data.REGIONE[i]);
    //Do something with option
}

edited Dec 31, 2009 at 19:13

answered Dec 31, 2009 at 18:58

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

1 Comment

Tatu Ulmanen Over a year ago

data.ID[i] is the value, not id.

David Hellsing · Accepted Answer · 2009-12-31 19:23:51Z

0

Your JSON looks slightly incorrect, but if we assume you have this:

"DATA": {
    "ID":[1,2,4,3,5],
    "REGIONE":["Abruzzo","Campania","Emilia","Molise","Toscana"]
}

You can try this:

var sel = $('<select>');
$.each(DATA.ID, function(i, id) {
    sel.append( $('<option>').val(id).text( DATA.REGIONE[i] ) );
})

answered Dec 31, 2009 at 19:23

David Hellsing

109k44 gold badges181 silver badges214 bronze badges

Comments

klokop · Accepted Answer · 2009-12-31 19:28:24Z

0

Will 'COLUMNS' always contain those two values ('ID' and 'REGIONE'), and will those two correspond to the two values in 'DATA'? If so you could do:

var s = $('<select />');
$(x.DATA.ID).each(function(i, id){
  console.log(id, x.DATA.REGIONE[i])
  $(s).append($('<option />').val(id).text(x.DATA.REGIONE[i]))
});

answered Dec 31, 2009 at 19:28

klokop

2,4102 gold badges19 silver badges22 bronze badges

Collectives™ on Stack Overflow

Jquery json parsing for select

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related