PHP Complex String Parse, JSON'able?

Question

So I have the following PHP string:

$output = {"playerId":1178,"percentChange":0.1,"averageDraftPosition":260,"percentOwned":0.1,"mostRecentNews":{"news":"Accardo was called up from Columbus on Monday, the Indians' official Twitter feed reports.","spin":"He'll replace Dan Wheeler on the active roster after carrying a 2.76 ERA over 13 appearances with the Clippers to start the season.","date":"Mon May 14"},"fullName":"Jeremy Accardo"}

What I need is: "Accardo was called up from Columbus on Monday, the Indians' official Twitter feed reports." and "He'll replace Dan Wheeler on the active roster after carrying a 2.76 ERA over 13 appearances with the Clippers to start the season." as substrings. But I can't seem to figure out the best and most elegant way to do that. I tried to JSON_decode the string but I get nothing returned. Any ideas? (I am using PHP)

can you give us a snippet of the code you are using to parse it? also, notice that json_decode has a second variable that lets you choose if it's an array or an object. — Odinn
– Odinn, Commented May 17, 2012 at 6:28
@sfgiants2010 your json data contains many unescaped single quote, i have fixed it, check my answer. — Ibrahim Azhar Armar
– Ibrahim Azhar Armar, Commented May 17, 2012 at 6:36

Vytautas · Accepted Answer · 2012-05-17 06:34:50Z

2

That's not a string. Try like this:

$output = '{"playerId":1178,"percentChange":0.1,"averageDraftPosition":260,"percentOwned":0.1,"mostRecentNews":{"news":"Accardo was called up from Columbus on Monday, the Indians\' official Twitter feed reports.","spin":"He\'ll replace Dan Wheeler on the active roster after carrying a 2.76 ERA over 13 appearances with the Clippers to start the season.","date":"Mon May 14"},"fullName":"Jeremy Accardo"}';

$object = json_decode($output);
$array = json_decode($output, true);
$string = json_encode($array);

answered May 17, 2012 at 6:34

Vytautas

3,5391 gold badge30 silver badges43 bronze badges

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

Comments

Ibrahim Azhar Armar · Accepted Answer · 2012-05-17 06:35:02Z

1

you have few unescaped string, that is causing the error. a simple formatting could have saved you the time.

$output = '{
    "playerId":1178,
    "percentChange":0.1,
    "averageDraftPosition":260,
    "percentOwned":0.1,
    "mostRecentNews": {
        "news":"Accardo was called up from Columbus on Monday, the Indians official Twitter feed reports",
        "spin":"Hell replace Dan Wheeler on the active roster after carrying a 2.76 ERA over 13 appearances with the Clippers to start the season.",
        "date":"Mon May 14"
    },
    "fullName":"Jeremy Accardo"
}';
$json = json_decode($output);

answered May 17, 2012 at 6:35

Ibrahim Azhar Armar

25.8k36 gold badges136 silver badges213 bronze badges

Comments

Lucas · Accepted Answer · 2012-05-17 06:32:31Z

0

Did you try this?

$output = '{"playerId":1178,"percentChange":0.1,"averageDraftPosition":260,"percentOwned":0.1,"mostRecentNews":{"news":"Accardo was called up from Columbus on Monday, the Indians\' official Twitter feed reports.","spin":"He\'ll replace Dan Wheeler on the active roster after carrying a 2.76 ERA over 13 appearances with the Clippers to start the season.","date":"Mon May 14"},"fullName":"Jeremy Accardo"}';

$array = json_decode($output, true);

echo $array['mostRecentNews']['news'];
echo $array['mostRecentNews']['spin'];

answered May 17, 2012 at 6:32

Lucas

10.7k7 gold badges42 silver badges40 bronze badges

Comments

sdemirkeser · Accepted Answer · 2012-05-17 06:40:56Z

0

json_encode with with only UTF8. are you using allthings with utf8? and you hava synstax error. if you define json variable manually it could be like this;

<?php
$output=<<<JSONSTR
{"playerId":1178,"percentChange":0.1,"averageDraftPosition":260,"percentOwned":0.1,"mostRecentNews":{"news":"Accardo was called up from Columbus on Monday, the Indians' official Twitter feed reports.","spin":"He'll replace Dan Wheeler on the active roster after carrying a 2.76 ERA over 13 appearances with the Clippers to start the season.","date":"Mon May 14"},"fullName":"Jeremy Accardo"}
JSONSTR;
$variable = json_decode($output);
var_dump($variable);
?>

answered May 17, 2012 at 6:40

sdemirkeser

4402 gold badges7 silver badges10 bronze badges

Collectives™ on Stack Overflow

PHP Complex String Parse, JSON'able?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related