How to display data from a JSON array using jQuery

Question

How can I get the array data from a JSON sent back by my php script?

PHP code:

<?php
//connects to database
include 'connect.php';
$callback = $_GET['callback'];

$query = mysql_query("SELECT * FROM users");
$rows = array();
while($r = mysql_fetch_assoc($query)) {
   $rows[] = $r;
}

$out_string = json_encode($rows);

print $callback.'('.$out_string.');';
?>

The php code above puts all of user table's rows into an array and JSONencodes it. It is then sent back to this script:

$.getJSON(domain_path + 'generate.php?table=' +  tbname + '&callback=?', function(data) {
});

How can I display each row from the JSON array sent back?

For example the data will be sent back is:

([{"name":"user1","link":"google.com","approve":"true"},{"name":"user2","link":"yahoo.com","approve":"true"},{"name":"user3","link":"wikipedia.com","approve":"true"}]);

How would I use javascript (jQuery) to display it out like this:

Name: User1 , Link: google.com , Approve:True
Name: User2 , Link: yahoo.com , Approve:True
Name: User3 , Link: wikipedia.com , Approve:True

Alex Amiryan · Accepted Answer · 2012-04-04 09:20:23Z

1

When you done print $callback.'('.$out_string.');'; you've ruined JSON formatted string. Send back in array instead then loop on through your rows and display data.

$out_string = json_encode(array('callback' => $callback, 'rows' => $rows));

answered Apr 4, 2012 at 9:20

Alex Amiryan

1,3921 gold badge18 silver badges31 bronze badges

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

1 Comment

DaveyBoy Over a year ago

If the OP is using JSONP for a cross-domain AJAX call vi jQuery, his original print line was correct. I had to use exactly the same formatting yesterday to achieve a cross domain call

Nicola Peluchetti · Accepted Answer · 2012-04-04 09:16:53Z

0

You should do

function(data) {
    $.each(data, function(){
        $('#result').append('<p>Name:'+this.name+' Link:'+this.link+' Approve'+this.approve+'</p>');
    });
}

fiddle here http://jsfiddle.net/hUkWK/

answered Apr 4, 2012 at 9:16

Nicola Peluchetti

77k32 gold badges150 silver badges197 bronze badges

Comments

Hampus Brynolf · Accepted Answer · 2012-04-04 09:19:49Z

0

$.getJSON(domain_path + 'generate.php?table=' +  tbname + '&callback=?', function(data) {
  $.each(data, function(i, item) {
    $("#mycontainer").append("<p>Name: " + item.name + "</p>");
    $("#mycontainer").append("<p>Link: " + item.link + "</p>");
  });
});

answered Apr 4, 2012 at 9:19

Hampus Brynolf

1,33611 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to display data from a JSON array using jQuery

3 Answers 3

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Related