Getting value of an item in json

Question

I want to get value of option key from an json, eg: the array below should return 12 I have tried the following code but I always get 'Undefined array key 0'

    {{ $question->options[0]['option'] }}

the data is stored in a json column of mysql database, the laravel model is Question and column is options I can get the column but i am not able to get the value of option key after getting the data in the column, i don't want to use php foreach

{
    "1": {
        "option": "12",
        "correct": "1"
    }
}


Array ( [1] => Array ( [option] => 12 [correct] => 1 ) ) 1

The key in your example is "1", not "0" – IMSoP Oct 06 '21 at 15:43 — IMSoP, Oct 06 '21 at 15:43
Even {{ $question->options[1]['option'] }} doesn't work – Brian Mutiso Oct 06 '21 at 15:44 — Brian Mutiso, Oct 06 '21 at 15:44

score 0 · Accepted Answer · answered Oct 06 '21 at 16:26

0

I got, I was able to do it this way after thorough trial

array_values($question->options)[0]['option']

answered Oct 06 '21 at 16:26

Brian Mutiso

299
6
10

score 0 · Answer 2 · answered Oct 06 '21 at 16:44

first you must parse data with json_decode

$question ='{
            "1": {
                "option": "12",
                "correct": "1"
            }
        }';
        $toArray = json_decode($question);
        print_r($toArray->{1}->option); // Accessing invalid object properties
    }

Getting value of an item in json

2 Answers2