CODEWITHSUNDEEP
phpjson
Kim
Kim

Reputation: 1148

Get value from JSON array in PHP

I'm trying to get the value from this following JSON array in a PHP variable.

This is a var_dump of the array:

array(3) {
  ["id"]=>
  string(2) "14"
  ["css"]=>
  string(400) ""
  ["json"]=>
  string(4086) "
            {
                "Canvas": [
                    {
                        "MainObjects": {
                            "After Participation": {
                                "afterParticipationHeader": "Thank you!"
                            },
                            "Invite Friends": {
                                "InviteHeadline": "",
                                "InviteMsg": "",
                                "InviteImg": ""
                            }
                        },
                        "QuizModule": {
                            "Questions": [],
                            "Submit_Fields": [
                                {
                                    "label": "Name",
                                    "name": "txtName",
                                    "value": true
                                }
                            ]
                        }
                    }
                ]
            }"
        }

I am able to get the values for ["json"] in PHP like: 

$json = $data[0]['json'];

But how do I get the value from from the array inside "json", like "AfterParticipationHeader". And "Submit_Fields" ?

Upvotes: 5

Views: 57065

Answers (4)

NDM
NDM

Reputation: 6840

you can convert a valid JSON string to a PHP variable with json_decode(). Note the second parameter to get an assoc array instead of the less usefull stdClass.

$jsonData = json_decode($data[0]['json'], true);
$header = $jsonData['Canvas']['MainObjects']['After Participation']['afterParticipationHeader'];

Upvotes: 4

dan
dan

Reputation: 136

It looks like you need to decode it. Try using: $json = json_decode($data[0]['json']);

Let me know if this helps.

Upvotes: 1

som
som

Reputation: 4656

First you have to decode your json data

$json = json_decode($data[0]['json']);

Then you can access your AfterParticipationHeader 

$json->Canvas[0]->MainObjects->{"After Participation"}->afterParticipationHeader

Upvotes: 12

Maxime Lorant
Maxime Lorant

Reputation: 36181

You can decode the JSON via the json_decode function: 

$json = json_decode($data[0]['json']);

Then, you'll have arrays (in the same structure) with your data.

Upvotes: 2

Related Questions