Extract json data with php doesnt works

Question

I have json data like this:

{"result":{"total":19,"hits":[{"keyword":"sidney webb"},{"keyword":"dr webb"}]},"status_msg":"OK","status_code":200,"left_lines":1196851}

I need to extract from json only keywords. I try without success with code:

$json = '{"result":{"total":19,"hits":[{"keyword":"sidney webb"},{"keyword":"dr webb"}]},"status_msg":"OK","status_code":200,"left_lines":1196851}';

foreach ($json['result'] as $keywords)
{
    echo $keywords['result']['keyword'];
}

When you say "without success" could you edit your question to include what you do see? What is the output of this example? — DaveyDaveDave, May 04 '17 at 09:48

Philipp · Answer 1 · 2017-05-04T09:25:37.737

5

Seems, you forgot to decode the string with json_decode. In addition, your likely would to loop over [result][hits] and not just [result]

$json = '{"result":{"total":19,"hits":[{"keyword":"sidney webb"},{"keyword":"dr webb"}]},"status_msg":"OK","status_code":200,"left_lines":1196851}';
$json = json_decode($json, true);

foreach ($json['result']['hits'] as $hit)
{
    echo $hit['keyword'];
}

edited May 04 '17 at 09:25

answered May 04 '17 at 09:15

Philipp

15,377
4
35
52

Thank you very much, Philipp, works. – Eduard Dimitrov May 04 '17 at 09:43

safin chacko · Answer 2 · 2017-05-04T09:33:24.660

-1

TRY

    $json = '{"result":{"total":19,"hits":[{"keyword":"sidney webb"},{"keyword":"dr webb"}]},"status_msg":"OK","status_code":200,"left_lines":1196851}';
    $jsonp =json_decode($json,TRUE);

    foreach ($jsonp['result'] as $val)
    {
        if(is_array($val) ){
        foreach ($val as $k)
        {
            echo  $k['keyword'];

        }
        }

    }

edited May 04 '17 at 09:33

answered May 04 '17 at 09:27

safin chacko

1,345
1
11
18

Thanks, safin chacko, your code also works. – Eduard Dimitrov May 04 '17 at 11:04

Extract json data with php doesnt works

2 Answers2