Online PHP editor | output for 5fRfJ

@ 2018-03-27T07:46:33Z

<?php
$resultset = [
    ["id" => "1", "cityId" => "1", "cityName" => "Bengaluru", "runId" => "2", "distance" => "10k", "status" => "1"],
    ["id" => "2", "cityId" => "1", "cityName" => "Bengaluru", "runId" => "1", "distance" => "5k", "status" => "1"],
    ["id" => "3", "cityId" => "1", "cityName" => "Bengaluru", "runId" => "5", "distance" => "3k", "status" => "0"],
    ["id" => "4", "cityId" => "2", "cityName" => "Chennai", "runId" => "1", "distance" => "5k", "status" => "1"],
    ["id" => "5", "cityId" => "2", "cityName" => "Chennai", "runId" => "2", "distance" => "10k", "status" => "1"],
    ["id" => "6", "cityId" => "2", "cityName" => "Chennai", "runId" => "4", "distance" => "15k", "status" => "1"]
];

foreach ($resultset as $row) {
    if (!isset($result[$row["cityId"]])) {
        $result[$row["cityId"]] = array("cityId" => $row["cityId"], $row["cityName"] => array(array("id" => $row["id"])+array_slice($row,-3)));
    } else {
        $result[$row['cityId']][$row["cityName"]][] = array("id" => $row["id"])+array_slice($row,-3);
    }
}
$result = array("status" => true, "runsBasedOnCity" => array_values($result));

var_export(json_encode($result, JSON_PRETTY_PRINT));

Output for 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.34, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.4, 8.3.6 - 8.3.7: '{ "status": true, "runsBasedOnCity": [ { "cityId": "1", "Bengaluru": [ { "id": "1", "runId": "2", "distance": "10k", "status": "1" }, { "id": "2", "runId": "1", "distance": "5k", "status": "1" }, { "id": "3", "runId": "5", "distance": "3k", "status": "0" } ] }, { "cityId": "2", "Chennai": [ { "id": "4", "runId": "1", "distance": "5k", "status": "1" }, { "id": "5", "runId": "2", "distance": "10k", "status": "1" }, { "id": "6", "runId": "4", "distance": "15k", "status": "1" } ] } ] }'
Output for 8.3.5: Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 '{ "status": true, "runsBasedOnCity": [ { "cityId": "1", "Bengaluru": [ { "id": "1", "runId": "2", "distance": "10k", "status": "1" }, { "id": "2", "runId": "1", "distance": "5k", "status": "1" }, { "id": "3", "runId": "5", "distance": "3k", "status": "0" } ] }, { "cityId": "2", "Chennai": [ { "id": "4", "runId": "1", "distance": "5k", "status": "1" }, { "id": "5", "runId": "2", "distance": "10k", "status": "1" }, { "id": "6", "runId": "4", "distance": "15k", "status": "1" } ] } ] }'

preferences:dark modelive preview