JSON to PHP Associative array

Question

would any of you know a good way to put this into an associative array . I have tried json_decode but found it to not be much help.

This is the data i need to put into an associative array:

{
  "data": [
    {
      "name": "Joe Bloggs",
      "id": "203403465"
    },
    {
      "name": "Fred Bloggs",
      "id": "254706567"
    },
    {
      "name": "Barny Rubble",
      "id": "453363843"
    },
    {
      "name": "Homer Simpson",
      "id": "263508546"
    }
  ]
}

EDIT:

After I accepted the answer, I remembered why I thought that the json_decode wasn't working.

Instead of having an associative array like this:

[0] => Array
(
    [name] => Joe Bloggs
    [id] => 203403465
)

I wanted one like this:

Array
(
    [Joe Bloggs] => 45203340465
    [Fred Bloggs] => 65034033446
)

Unfortunately, I had forgotten this at the time.. but I have resolved my issue now anyway.

Thanks for all of your help!

just in case ... it's not allowed to store facebook-user data except the uid longer than 24 hours ... — helle, Jun 18 '10 at 21:37

score 9 · Answer 1 · answered Jun 18 '10 at 21:39

json_decode works for me on your data:

print_r(json_decode('{
       "data": [
          {
             "name": "Joe Bloggs",
             "id": "203403465"
          },
          {
             "name": "Fred Bloggs",
             "id": "254706567"
          },
          {
             "name": "Barny Rubble",
             "id": "453363843"
          },
          {
             "name": "Homer Simpson",
             "id": "263508546"
          }
       ]
    }
', true));

Output:

Array
(
    [data] => Array
        (
            [0] => Array
                (
                    [name] => Joe Bloggs
                    [id] => 203403465
                )

            [1] => Array
                (
                    [name] => Fred Bloggs
                    [id] => 254706567
                )

            [2] => Array
                (
                    [name] => Barny Rubble
                    [id] => 453363843
                )

            [3] => Array
                (
                    [name] => Homer Simpson
                    [id] => 263508546
                )

        )

)

Setting the second argument to true returns an associative array.

Thanks for your answer webbiedave, if you view my last comment on helle's comment you'll see what I did. +1 for the response I was looking for! — vimist, Jun 18 '10 at 21:44

score 3 · Answer 2 · edited Jun 10 '14 at 18:27

3

You have to make a new array

$json_array = json_decode($_POST['json'], true);
$assoc_array = array();

for($i = 0; $i < sizeof($json_array); $i++)
{
     $key = $json_array[$i]['name'];
     $assoc_array[$key] = $json_array[$i]['value'];
}

you will get your associative array in $assoc_array and you can now directly access using indexes.

edited Jun 10 '14 at 18:27

Mark Rotteveel

90,369
161
124
175

answered Jul 12 '12 at 08:38

AndroidLearner

1,360
7
24
40

1

That's what I needed. – Adam Knowles May 07 '18 at 11:54

helle · Accepted Answer · 2010-06-18T21:44:26.627

2

i asume your json comes via ajax.... (otherwise the code works with json_decode) so be sure the js json stringifys your object and

you'll need to stripslashes before json_decode ;-) in php

edited Jun 18 '10 at 21:44

answered Jun 18 '10 at 21:34

helle

10,634
9
55
82

It doesn't come via AJAX but for some reason, now when I use json_decode it works as i initally expected it to. Very strange because when I remove stripslashes, it also works... maybe I messed something up when I previously tried it. Many Thanks helle for nudging me back on track :o) – vimist Jun 18 '10 at 21:42

JSON to PHP Associative array

3 Answers3

Linked