current community

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

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
share|improve this question
add comment

3 Answers

up vote 0 down vote accepted

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/

share|improve this answer
add comment
up vote 1 down vote

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));
share|improve this answer
 
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 –  DaveyBoy Apr 4 '12 at 9:23
 
yes im doing a cross domain call. –  sm21guy Apr 4 '12 at 9:23
add comment
up vote 0 down vote 
$.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>");
  });
});
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.