Converting stringified array into actual array

Question

The DB I am working with has an array of strings stored as a text value, such as:

"[\"Radio\/CD\",\"TV\",\"Weight Gauge\"]"

(no idea why stored like this)

Anyway, I need to convert it into a regular array, such as:

Array ( [0] => Weight Gauge [1] => TV [2] => Radio/CD )

Because of the way its stored I can't do a regular php explode, eg:

<?php
    $input  = '"[\"Radio\\\/CD\",\"TV\",\"Weight Gauge\"]"';
    echo "Input string:<br>" . $input . "<br><br>";
    $output = explode(",", stripslashes($input));
    print_r($output);
?>

The resulting array ( not how I want it ):

Array ( [0] => "["Radio/CD" [1] => "TV" [2] => "Weight Gauge"]" )

Thanks

gre_gor · Accepted Answer · 2015-10-29 23:45:56Z

2

Looks like it's double JSON encoded.

use json_decode

$input  = '"[\"Radio\\\/CD\",\"TV\",\"Weight Gauge\"]"';
$output = json_decode(json_decode($input));
print_r($output);

this outputs:

Array
(
    [0] => Radio/CD
    [1] => TV
    [2] => Weight Gauge
)

answered Oct 29, 2015 at 23:45

gre_gor

6,65612 gold badges104 silver badges105 bronze badges

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

1 Comment

Martin Over a year ago

Thanks, lol, I had tried a single json_decode...hadn't thought about doing a double.

Collectives™ on Stack Overflow

Converting stringified array into actual array

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related