how to parse json into php

Question

i have a json data retrieved from data base i.e

$result=array();
$query="SELECT * FROM fish";
$result1 = mysql_query($query, $conn);
while ($table = mysql_fetch_array($result1, MYSQL_ASSOC)){
   $result[]=$table;
}
   echo json_encode($result);

and this give me the result

[{"fish_id":"1","name":"first fish update","info":"this is my first fish update","image":"http:\/\/www.localhost\/cafe\/pics\/logout (1).gif"}]

but from another page when i call this json data i.e

$input = file_get_contents("http://localhost/fish/fish-json.php");
$json=json_decode($input);
echo $json->fish_id;

it give me the error

Notice: Trying to get property of non-object in /var/www/fish/json-to-php.php on line 13 Call Stack: 0.0005 318764 1. {main}() /var/www/fish/json-to-php.php:0

Does $input contain any result when you echo it?

Sarfraz
– Sarfraz

2010-12-21 13:06:40 +00:00
Commented Dec 21, 2010 at 13:06 — Sarfraz
– Sarfraz, Commented Dec 21, 2010 at 13:06
print_r() or var_dump() is your friend :))

thedom
– thedom

2010-12-21 13:12:07 +00:00
Commented Dec 21, 2010 at 13:12 — thedom
– thedom, Commented Dec 21, 2010 at 13:12

ajreal · Accepted Answer · 2010-12-21 13:21:15Z

5

Is an array of object, so

echo $json[0]->fish_id;

To loop

if (!is_array($json)) die('...');
foreach ($json as $key=>$fish)
{
  echo $fish->fish_id;
}

edited Dec 21, 2010 at 13:21

answered Dec 21, 2010 at 13:10

ajreal

47.4k11 gold badges98 silver badges119 bronze badges

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

1 Comment

hunter Over a year ago

hay thanks,it works but if there are more than one records then how could i iterate to this

Codler · Accepted Answer · 2010-12-21 13:07:55Z

0

Try

$input = file_get_contents("http://localhost/fish/fish-json.php");
$json=json_decode($input);
echo $json['fish_id'];

answered Dec 21, 2010 at 13:07

Codler

11.3k6 gold badges55 silver badges66 bronze badges

Comments

Breezer · Accepted Answer · 2010-12-21 13:08:18Z

0

try echo $json['fish_id']; i might suspect it convert it to an array

answered Dec 21, 2010 at 13:08

Breezer

10.5k6 gold badges32 silver badges51 bronze badges

Comments

Van Coding · Accepted Answer · 2010-12-21 13:11:34Z

0

try this first:

echo $json;

to check if you got valid json. Eventually, the php in fish-json.php was not executed.

answered Dec 21, 2010 at 13:11

Van Coding

24.6k25 gold badges94 silver badges138 bronze badges

Comments

Kir · Accepted Answer · 2010-12-21 13:13:43Z

0

By default json_decode returns an stdClass object. You have to give a second parameter for this function TRUE.

$json=json_decode($input, TRUE);
echo $json[0]['fish_id'];

answered Dec 21, 2010 at 13:13

Kir

8,15114 gold badges55 silver badges69 bronze badges

Collectives™ on Stack Overflow

how to parse json into php

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related