Retrieving JSON in jquery from a php script

Question

I have this php script which when run outputs this. I cannot seem to fathom out how to access this in jquery I have tried varous methods from tutorials but no avail.

{"name":"photo1.jpg","id":"1"}{"name":"photo2.jpg","id":"2"}
{"name":"photo3.jpg","id":"3"}{"name":"photo4.jpg","id":"4"}

<?php

mysql_select_db('news') or die(mysql_error());
//echo "Connected to Database";<?php 

$result = mysql_query("SELECT * FROM photos") 
or die(mysql_error());  

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_assoc( $result )) {    
    echo json_encode($row);
} 
?>

Jquery

$(document).ready(function() {                      
$.getJSON('photo_get.php', function(data){

alert("Data" + data.name);

});
});

This outputs nothing.

Thanks for any help.

rsp · Accepted Answer · 2011-03-09 16:53:38Z

2

This is not valid JSON:

{"name":"photo1.jpg","id":"1"}{"name":"photo2.jpg","id":"2"}

It should look like this:

[{"name":"photo1.jpg","id":"1"},{"name":"photo2.jpg","id":"2"}]

What you should do is to push every row to some array and then serialize the entire array to JSON.

Eg. use something like this in the loop:

$array[] = $row;

and then serialize the whole thing outside of the loop:

echo json_encode($array);

answered Mar 9, 2011 at 16:53

rsp

112k31 gold badges210 silver badges185 bronze badges

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

Comments

n00b · Accepted Answer · 2011-03-09 16:47:23Z

1

i think it should be

<?php
$rows=array();
mysql_select_db('news') or die(mysql_error());
//echo "Connected to Database";<?php 

$result = mysql_query("SELECT * FROM photos") 
or die(mysql_error());  

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_assoc( $result )) {    
    $rows[]=$row;
} 
echo json_encode($rows);
?>

$(document).ready(function() {                      
$.getJSON('photo_get.php', function(data){
$.each(data, function(key, val) {
alert("Data" + val.name);
});
});
});

as its an array

answered Mar 9, 2011 at 16:47

n00b

5,7322 gold badges32 silver badges50 bronze badges

1 Comment

user640707 Over a year ago

The php file now outputs [{"name":"photo1.jpg","id":"1"},{"name":"photo2.jpg","id":"2"},{"name":"photo3.jpg","id":"3"},{"name":"photo4.jpg","id":"4"}] But still no Alertbox

alega · Accepted Answer · 2011-03-09 16:55:25Z

0

you can push your response to array:

ArrayData = [];

ArrayData = data;

and then loop it:

for (var i; i < ArrayData.length; i++) {
   alert(ArrayData[i]['name'])
}

answered Mar 9, 2011 at 16:55

alega

971 silver badge4 bronze badges

1 Comment

n00b Over a year ago

isint that what $.each(data does ?

Collectives™ on Stack Overflow

Retrieving JSON in jquery from a php script

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related