access json object in array after PDO fetch data

Question

I have database values as JSON. I want to get values assigned to key like "name". How can I get those in PHP?.

<?php

include('db.class.php');

$sql = "select * from users where 1";

$obj = new db();
$stmt = $obj->conn->prepare($sql);
$stmt->execute();

$res = $stmt->fetchAll(PDO::FETCH_ASSOC);

$json = json_encode($res,true);

echo $big = $json->name; // ??? ERROR

my output is

[
    {"id":"1",
    "name":"test1",
    "username":"abc",
    "email":"[email protected]",
    "phone":"333"
    },
    {"id":"2",
    "name":"test2",
    "username":"def",
    "email":"[email protected]",
    "phone":"23232"}
]

$json is a string, not an object. And there's more than one row in the results, which one are you expecting $json->name to return? — Barmar
– Barmar, Commented Jul 13, 2017 at 9:47
Can you post the output of echo '<pre>' . print_r($res, true) . '</pre>'; so we can see what exactly is the structure of returned result — codtex
– codtex, Commented Jul 13, 2017 at 9:47
Take a quick dip into The PHP manual for json_encode() and see if parameter 2 has a TRUE option in there! Then you might like to swim over to json_decode() just to say hello — RiggsFolly
– RiggsFolly, Commented Jul 13, 2017 at 9:52

Barmar · Accepted Answer · 2017-07-13 09:50:04Z

2

You don't need to use json_encode(). $res is an array of the results, you can access the names from that.

echo $res[0]['name'];

Note that the elements of $res are associative arrays, not objects, because you use PDO::FETCH_ASSOC.

answered Jul 13, 2017 at 9:50

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

1 Comment

RiggsFolly Over a year ago

Finally some one agree's with me

Bilal Ahmed · Accepted Answer · 2017-07-13 09:49:20Z

0

First you decode jason array then fetch the result

$data= json_decode($json);

echo $data[0]->name;

if you need more information about jason_decode then read manual

edited Jul 13, 2017 at 9:49

answered Jul 13, 2017 at 9:47

Bilal Ahmed

4,0663 gold badges25 silver badges42 bronze badges

2 Comments

Barmar Over a year ago

$data[0]->name

RiggsFolly Over a year ago

Would it not be simpler to do $res[0]['name'] and cut out all this unnecesary dancing with JSON

Collectives™ on Stack Overflow

access json object in array after PDO fetch data

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related