How to parse wordpress options json

Question

I have the data saved using a plugin in this format:

a:7:{s:6:'Sunday ';a:3:{s:6:'active ';s:3:'yes ';s:5:'start ';s:5:'08: 00 ';s:3:'end ';s:5:'13: 00 ';}
    s:6:'Monday ';a:3:{s:6:'active ';s:3:'yes ';s:5:'start ';s:5:'08: 00 ';s:3:' end ';s:5:'17: 00 ';}
    s:7:'Tuesday ';a:3:{s:6:' active ';s:3:'yes ';s:5:'start ';s:5:'08: 00 ';s:3:'end ';s:5:'17: 00 ';}
    s:9:'Wednesday ';a:3:{s:6:'active ';s:3:'yes ';s:5:'start ';s:5:'08: 00 ';s:3:'end ';s:5:'17: 00 ';}
    s:8:'Thursday ';a:3:{s:6:'active ';s:3:'yes ';s:5:'start ';s:5:'08: 00 ';s:3:'end ';s:5:'17: 00 ';}
    s:6:'Friday ';a:3:{s:6:'active ';s:3:'yes ';s:5:'start ';s:5:'08: 00 ';s:3:'end ';s:5:'17: 00 ';}
    s:8:'Saturday ';a:3:{s:6:'active ';s:3:'yes ';s:5:'start ';s:5:'08: 00 ';s:3:'end ';s:5:'13: 00 ';}}

How can I extract this data using php or any WordPress functions? I have already tried unserialize(), maybe_unserialize() json_decode . But all I get is null in the end.

Answer 1

The comments and answers are correct, it is no JSON but indeed a serialized array. The reason you're having trouble unserializing it is because of the quotes inside the serialized data. David Walsh wrote a neat article about this. The problem is that you can't simply go into the database and remove these single quotes because the serialized value keeps track of the number of characters in the string (s:6) so you would also need to update that.

Here's what David Walsh suggests to get around this issue in the future:

//to safely serialize
$safe_string_to_store = base64_encode( serialize( $multidimensional_array ) );

//to unserialize...
$array_restored_from_db = unserialize( base64_decode( $encoded_serialized_string ) );