Getting specific element from JSON in PHP

Question

On executing elastic search and storing the result in JSON form

stdClass Object (
    [took] => 119
    [timed_out] => 
    [_shards] => stdClass Object (
        [total] => 5 
        [successful] => 5 
        [failed] => 0 
    )
    [hits] => stdClass Object (
        [total] => 3 
        [max_score] => 1 
        [hits] => Array ( 
            [0] => stdClass Object (
                [_index] => movies 
                [_type] => movie 
                [_id] => 3 
                [_score] => 1 
                [_source] => stdClass Object (
                    [title] => The MATRIX 
                    [year] => 1975
                )
            )
            [1] => stdClass Object (
                [_index] => movies
                [_type] => movie
                [_id] => 8
                [_score] => 1
                [_source] => stdClass Object (
                    [title] => The MATRIX
                    [year] => 1975
                )
            )
            [2] => stdClass Object (
                [_index] => movies
                [_type] => movie
                [_id] => 4
                [_score] => 1
                [_source] => stdClass Object (
                    [title] => The MATRIX
                    [year] => 1975
                )
            )
        )
    )
)

I want to get value of each movie and year in the above
I tried

foreach($result as $i)
{
    echo $i->title;
    echo $i->year;
}


Notice: Trying to get property of non-object in D:\xampp\htdocs\esearch\index.php on line 16

Notice: Trying to get property of non-object in D:\xampp\htdocs\esearch\index.php on line 17

How to get it?

Try to convert your json to associative array with passing true on second parameter json_decode($yourjson, true). — fian
– fian, Commented Mar 27, 2014 at 7:11
The problem isn't the getter, it's the fact that $i isn't an object (seeing how it's 119, then empty, and then an stdClass. — h2ooooooo
– h2ooooooo, Commented Mar 27, 2014 at 7:12

Hüseyin BABAL · Accepted Answer · 2014-03-27 07:11:41Z

2

You can use following;

foreach($result->hits->hits as $movie)
{
    echo $movie->_source->title;
    echo $movie->_source->year;
}

answered Mar 27, 2014 at 7:11

Hüseyin BABAL

15.6k5 gold badges53 silver badges74 bronze badges

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

Comments

sanjeev · Accepted Answer · 2014-03-27 07:14:53Z

1

Try this

    foreach($result->hits->hits as $i)
    {
        echo $i->_source->title;
        echo $i->_source->year;

    }

answered Mar 27, 2014 at 7:14

sanjeev

4,6512 gold badges22 silver badges28 bronze badges

Collectives™ on Stack Overflow

Getting specific element from JSON in PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related