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
– helle, Commented Jun 18, 2010 at 21:37

webbiedave · Accepted Answer · 2010-06-18 21:39:20Z

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!

Mark Rotteveel · Accepted Answer · 2014-06-10 18:27:20Z

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, 2014 at 18:27

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered Jul 12, 2012 at 8:38

Salman

1,3807 gold badges26 silver badges41 bronze badges

1 Comment

Adam Knowles Over a year ago

That's what I needed.

helle · Accepted Answer · 2010-06-18 21:44:26Z

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, 2010 at 21:44

answered Jun 18, 2010 at 21:34

helle

11.8k9 gold badges58 silver badges86 bronze badges

1 Comment

OdinX Over a year ago

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)

Collectives™ on Stack Overflow

JSON to PHP Associative array

3 Answers 3

1 Comment

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Linked

Related