JSON Encoded data not accessible

Question

I queried the data from database using a Model.

echo $user = User::whereRaw('username = ? and password = ?', array($username,$password))->get();

The output is in JSON format

[{"id":1,"name":"Abhijith","username":"abhi","created_at":"2014-07-31 20:07:35","updated_at":"2014-07-31 20:07:35"}]

But when I try to echo a single field, I get an index not found error.

echo $user->id; //Gives an error saying the index is not found

are you getting an actual string of json data? If so you would need to json_decode it to turn it into a php object that you can access or else it is just a string. — Jonathan Kuhn
– Jonathan Kuhn, Commented Jul 31, 2014 at 21:35
You have to decode the json object like here with json_decode — Ko2r
– Ko2r, Commented Jul 31, 2014 at 21:35
echo $user[0]->id; Look at the object, it makes sense. Taking away this superfluous up-vote. — Ryan
– Ryan, Commented Jul 31, 2014 at 21:42

AbraCadaver · Accepted Answer · 2014-07-31 21:41:07Z

2

You need to get in the habit of looking at the structure and not assuming. Also, you need to json_decode the string. Then use print_r to see the structure:

$result = json_decode($user);
echo $result[0]->id;

Or (PHP >= 5.4.0 I think):

echo json_decode($user)[0]->id;

edited Jul 31, 2014 at 21:41

answered Jul 31, 2014 at 21:35

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

3 Comments

Abhijith Over a year ago

Got it. Thank you. All I had to do was echo $result[0]->id;

Someguy123 Over a year ago

Note: you didn't need to json_decode it. It's only JSON because it was echo'd (it has a magic method for when it is used as a string), its actually an object that can naturally be accessed with $user[0]->id

AbraCadaver Over a year ago

@Someguy123: Good to know. I'm not a laravel guy.

Collectives™ on Stack Overflow

JSON Encoded data not accessible

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related