How to get keys from JSON

Question

I'm using Laravel. I have JSON returned from Database. I would like to get key names like "id / name / email / revision" from following JSON.

{
    "id": "000",
    "records": [
        {
            "id": 23,
            "name": "hoge",
            "email": "Hoge@alk.jp",
            "revision": 0
        },
        {
            "id": 24,
            "name": "zaku",
            "email": "zaku@alk.jp",
            "revision": 0
        },
    ]
}

Please let me know how to get key names. Thank you.

use `json_decode($json)`, then like a regular php array get values. — Serghei Leonenco, Dec 17 '20 at 02:50

score 2 · Accepted Answer · answered Dec 17 '20 at 02:50

2

You should get the keys with collection get key by code following:

collect($data->records)->keys();

This will return

id
name
email
revision

More detail you can check here: https://laravel.com/docs/8.x/collections#method-keys

answered Dec 17 '20 at 02:50

Sok Chanty

1,678
2
12
22

N. Bien · Answer 2 · 2020-12-17T05:02:16.537

1

Use json_decode to convert it to an array:

$array = josn_decode($jsonVariable, true);

Then use foreach:

foreach($array['records'][0] as $key => $value){
    $keys[] = $key;
}

or array_keys:

array_keys($array['records']);

or collect to get keys:

$keys = collect($array['records'])->keys();

edited Dec 17 '20 at 05:02

answered Dec 17 '20 at 02:59

N. Bien

19
4

2

No need to `foreach`--PHP has `array_keys` method – JAAulde Dec 17 '20 at 03:39

How to get keys from JSON

2 Answers2