jquery php mysql and json returning looped data

Question

I havent tried this before and my solution hasnt worked.

In mysql I would be able to write it using a while loop but im trying to pull the data through ajax.

Can someone help

var qString = 'country=' +country+'&continent='+continent;

$.post('/assets/inc/get-country.php', qString, function (data) {    
    $('#'+continent).append('<li>'+data[0].country+' '+data[0].company+'</li>');
}, "json");

The above returns in console.log's ajax response the following

[{
    "continent": "Europe",
    "country": "Spain",
    "company": "Universidade de Vigo CITI",
    "comments": "We are very satisfied with the disrupter. It's equipment is very easy to use and effective in breaking cells. I also would like to thank Constant System for for the assistance provided."
}, {
    "continent": "Europe",
    "country": "Spain",
    "company": "IPLA",
    "comments": "The Constant Systems cell disruptor has made extraction of membrane proteins from Gram positives a reproducible and efficient task in our lab."
}]

How can I get this to display as an li list on my page?

Thanks in advance

EDIT

$("#comments-tabs div.country a").click(function(e){
    e.preventDefault();
    var continent = $(this).parent().attr("id");
    var country = $(this).attr("name");
    console.log(continent+country);
var qString = 'country=' +country+'&continent='+continent;
    $.post('/assets/inc/get-country.php', qString, function (data) {    
        for(company_nr in data){
            $('#'+continent).append('<li>'+data[company_nr].country+' '+data[company_nr].company+'</li>')
        }
    }, "json");
});

Puggan Se · Accepted Answer · 2012-07-06 11:06:32Z

2

Just loop it in javascript:

function (data)
{
   for(company_nr in data)
   {
      $('#'+continent).append('<li>'+data[company_nr].country+' '+data[company_nr].company+'</li>')
   }
}

answered Jul 6, 2012 at 11:06

Puggan Se

5,8462 gold badges25 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

jquery php mysql and json returning looped data

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