PHP: Help restructuring JSON Array

Question

I have this simple json object:

$colours = '{"num":20,"status":"ok","colour0":"red","colour1":"green","colour2":"blue"}';

How can I turn into this with PHP:

$colours = '[{"colour":"red"},{"colour":"green"},{"colour":"blue"}]';

Do I need to json_decode() it first ?

I tried this with no luck:

$jsonArr = json_decode($similarsites, true);
$c1 = parse_url($jsonArr['c1']);

$ii = 0;
$resulti = array('color' => array());

while (isset($jsonArr['c' . $ii])) {
        $c = $jsonArr['c' . $ii];

        $resulti['color'][$ii] = $c;
        $ii++ ;
    }

print json_encode($resulti['color']);

But this gives me the list of all colours not as key/value

You would be better off just returning an array of colours, e.g. {"red","green","blue"} — Ryan
– Ryan, Commented Jan 15, 2014 at 8:59
@Ryan No, his edit solves the problem. Now he has an array of objects, not a single object. — Barmar
– Barmar, Commented Jan 15, 2014 at 9:00
@Barmar I see now, it updated then reverted for me so I saw his original post. It's now showing correctly. — Ryan
– Ryan, Commented Jan 15, 2014 at 9:01

Barmar · Accepted Answer · 2014-01-15 09:23:42Z

1

$ii = 0;
$resultArr = array();
while (isset($jsonArr['colour' . $ii])) {
    $resultArr[] = array('colour' => $jsonArr['colour' . $ii]);
    $ii++;
}

DEMO

edited Jan 15, 2014 at 9:23

answered Jan 15, 2014 at 9:03

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

9 Comments

ClydeM Over a year ago

sir this line gives me an error: $resultArr[] = array('colour' => $jsonArr['colour' + $ii]));

Barmar Over a year ago

Sorry, I had an extra parenthesis

ClydeM Over a year ago

Thank you. After if I use: print json_encode($resultArr); Ι just get two brackets: [] - or an empty json object

ClydeM Over a year ago

It seems that isset($jsonArr['colour' + $ii]) is false because right after that I am echo "empty"; with no result

Barmar Over a year ago

Fixed it. + should be . (too much switching between PHP and JS). And i++ should be $ii++.

|

Collectives™ on Stack Overflow

PHP: Help restructuring JSON Array

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related