convert JSON from string with array value included

Question

As the following string, use json_decode to convert it into an array. However, after conversion, the value of TbManager:userAccesses[] is still a string.

TbManager:userAccesses[] could be converted to array by calling json_decode again for it, json_decode($json['TbManager:userAccesses[]']), but how to convert it in the first json_decode call?

$json = '{
"TbUser:username":"admin",
"TbManager:userAccesses[]":"[\"1\",\"8\"]"
}'

// converted to JSON with 'TbManager:userAccesses[]':string
// how to conver TbManager:userAccesses[] as array type
$json = json_decode($json)

Hanky Panky · Accepted Answer · 2016-03-03 07:58:51Z

2

"TbManager:userAccesses[]":"[\"1\",\"8\"]"

Over there this is a single value "[\"1\",\"8\"]" it is not an array according to JSON syntax, hence the output you see.

Array would be when the value is like

$json = '{
"TbUser:username":"admin",
"TbManager:userAccesses":[1,8]
}';

answered Mar 3, 2016 at 7:58

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

panda Over a year ago

the output of TbManager:userAccesses[] after json_decode is ["1", "8"], and also, if 1, 8 are in string, how to declare TbManager:userAccesses[] in string? by using single quote?

panda Over a year ago

I see, it is because of the quotation of [ ], since there is an quotation the processor use it as a string

pes502 · Accepted Answer · 2016-03-03 07:59:06Z

1

It's because your JSON data have bad format. The right format of your JSON data:

{"TbUser:username":"admin","TbManager:userAccesses[]":[1,8]}

in your code it will be:

$json = '{
"TbUser:username":"admin",
"TbManager:userAccesses[]":[1,8]
}';

And then:

var_dump($json);

will output:

object(stdClass)#1 (2) {
  ["TbUser:username"] => string(5) "admin"
  ["TbManager:userAccesses[]"] => array(2) {
    [0] => int(1)
    [1] => int(8)
  }
}

answered Mar 3, 2016 at 7:59

pes502

1,5973 gold badges17 silver badges33 bronze badges

2 Comments

Hanky Panky Over a year ago

Bad or not fit for the purpose Format?

pes502 Over a year ago

not fit for the purpose sounds better :/

alexander.polomodov · Accepted Answer · 2016-03-03 08:00:24Z

1

Your $json should look like

{"TbUser:username":"admin","TbManager:userAccesses[]":[1,8]}"

In this case 'TbManager:userAccesses[]' will be array after json_decode

answered Mar 3, 2016 at 8:00

alexander.polomodov

5,54414 gold badges44 silver badges48 bronze badges

Comments

Remo · Accepted Answer · 2016-03-03 08:27:12Z

0

As mentioned above, it's not a valid json string, but if that's what you get, here's a snippet that would convert those values to array:

$json = '{
    "TbUser:username":"admin",
    "TbManager:userAccesses[]":"[\"1\",\"8\"]"
}';

$json = json_decode($json);

array_walk_recursive($json, function (&$item, $key)
{
    if (substr($key, -2) == '[]') {
        $item = json_decode($item);  
    }
});

print_r($json);

answered Mar 3, 2016 at 8:27

Remo

4,4172 gold badges13 silver badges14 bronze badges

Collectives™ on Stack Overflow

convert JSON from string with array value included

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related