Couldn't convert string to JSON. String to Valid JSON and parse the JSON in PHP

Question

I am having the following JSON(invalid) as a string. I need to parse it and get the inner value. I tried a lot but didn't get the result.

    $sJson = '{"Place":"MyStore","PurchaseID":"IND.1234-5678-9012-34567","details":"{\"json\":\"{\\\"PurchaseID\\\":\\\"IND.1234-5678-9012-34567\\\",\\\"categoryname\\\":\\\"smartpack\\\",\\\"productname\\\":\\\"bitcoinpack1\\\",\\\"purchaseTime\\\":1504256011148,\\\"purchaseState\\\":\\\"Success\\\",\\\"UniqueToken\\\":\\\"jbbefjifdkpdpajfkomckoof.AO-J1OzEdsZX17M5pAvedDh1Ep_WwlOKamMQN_3O89bRbAPX-uoqPpTJf8EdNcjMhCK1dptGaWReUCSS9JGCJuh6GlAT0l11mkUddo_uJ4YOe8ezYxlmDQ8\\\"}\",\"currentvalue\":\"S270U2J3XF\\/+XnC1ocPp0d\\/Kwf\\/4B\\/\\/tT7urbDn6F+\\/D8j7VD1t8qqwevtKDnAafAtvocPg4Eevkf\\/GZKl1YOgUYyuY63nyekz7GRDuIKVXAZ+iZtPAbwCuwZplUQHaVA\\/EBMjYpPQM0EFtp2WuX\\/Tx9nTnFCtU+gAK4Rg0zLvQNKSJx5WfqhK7wf0wHTTYviTkB\\/pETnkV22oQDIZH9\\/Fy1FXltC7FXHXoMcxtGvkgPSEFOnms4HumjUQ5PtQUbxh\\/oirQeROCAhkO+WKX9WO3bCKjru1uuxspTLCNGJEKAezi2GEBcpFGjq4iS5N7SfO5BOF76\\/joLe3B7OemJNw==\"}"}';

    $sJson = json_encode($sJson,JSON_UNESCAPED_SLASHES);
    $json_array = (array) json_decode($sJson,true);
    $newjson=preg_replace('/.+?({.+}).+/','$1',$json_array);
    var_dump($newjson);
    exit;

The Result $newjson is not return as JSON Object, it gives as only string.

I need JSON object not a string.

In the given JSON, json value is a string(inside valid JSON) which starts with ".

I need to remove this.

Why do you json_encode() something that is already encode? Don't you mean json_decode()? And I would use different variable names for the argument and result of this function. — KIKO Software
– KIKO Software, Commented Sep 1, 2017 at 11:24
It seems to be valid json at jslint.com and jsonlint.com, so you should be able to decode it. — aynber
– aynber, Commented Sep 1, 2017 at 11:28

Quentin · Accepted Answer · 2017-09-01 11:24:01Z

2

json_encode takes a PHP data structure and turns it into a string of JSON.

You need json_decode to go the other way.

answered Sep 1, 2017 at 11:24

community wiki

Quentin

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

1 Comment

Gunaseelan Over a year ago

Given string is not a valid. Kindly check with online json editors.

aynber · Accepted Answer · 2017-09-01 11:36:47Z

1

The string is mostly valid json, you just need to tweak a few things:

First, replace all of the \\" with ". (I had to run this twice)

$string = str_replace('\\"', '"', $string);

Then some of the braces are quoted:

$string = str_replace('"{', '{', $string);
$string = str_replace('}"', '}', $string);

Once that was done, I was able to successfully decode your json. This could possibly be done faster with preg_replace, but I suck at regexes.

answered Sep 1, 2017 at 11:36

aynber

23.2k9 gold badges57 silver badges69 bronze badges

1 Comment

aynber Over a year ago

It worked for me sandbox.onlinephpfunctions.com/code/…

Collectives™ on Stack Overflow

Couldn't convert string to JSON. String to Valid JSON and parse the JSON in PHP

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related