Online PHP editor | refs for G8oQ8

<?php // Take your submitted output $jsonData = '{"msg":"OK","details":[{ "id":"1","score":"233","user_id":"4", "date":"2014-02-03 00:00:00"}, { "id":"2", "score":"1256","user_id":"5", "date":"2014-02-05 00:00:00"},{"id":"4", "score":"123", "user_id":"7", "date":"2014-03-04 00:00:00"},{ "id":"3", "score":"100", "user_id":"6", "date":"2014-03-08 00:00:00"},{ "id":"5", "score":"8", "user_id":"2", "date":"2014-03-13 00:00:00"}], "1st":"2014-02-03 00:00:00", "last":"2014-03-13 00:00:00"}'; // and convert it to an array $origArray=json_decode($jsonData); // We will want an array to hold data $weeklyDetails = array(); // Lets loop through each of your details foreach ($origArray->details as $detail){ // and get the week number $weekNo=date("W", strtotime($detail->date)); // and if we don't already have an array for that week if (! is_array($weeklyDetails["week $weekNo"]) ){ //create it $weeklyDetails["week $weekNo"] = array(); } // lets push the detail into that week array_push($weeklyDetails["week $weekNo"], $detail); } // Assign the new details $origArray->details = $weeklyDetails; // Convert back to json $jsonData = json_encode($origArray); // print it out. print($jsonData);