<?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);
Warning: Undefined array key "week 06" in /in/G8oQ8 on line 17
Warning: Undefined array key "week 10" in /in/G8oQ8 on line 17
Warning: Undefined array key "week 11" in /in/G8oQ8 on line 17
{"msg":"OK","details":{"week 06":[{"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"}],"week 10":[{"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"}],"week 11":[{"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"}
Notice: Undefined index: week 06 in /in/G8oQ8 on line 17
Notice: Undefined index: week 10 in /in/G8oQ8 on line 17
Notice: Undefined index: week 11 in /in/G8oQ8 on line 17
{"msg":"OK","details":{"week 06":[{"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"}],"week 10":[{"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"}],"week 11":[{"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"}
Notice: Undefined index: week 06 in /in/G8oQ8 on line 17
Notice: Undefined index: week 10 in /in/G8oQ8 on line 17
Notice: Undefined index: week 11 in /in/G8oQ8 on line 17
{"msg":"OK","details":{"week 06":[{"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"}],"week 10":[{"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"}],"week 11":[{"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"}
Output for 5.0.0 - 5.0.5, 5.1.0 - 5.1.6
Fatal error: Call to undefined function json_decode() in /in/G8oQ8 on line 6
Process exited with code 255.
Output for 4.4.5 - 4.4.9
Fatal error: Call to undefined function: json_decode() in /in/G8oQ8 on line 6
Process exited with code 255.
Output for 4.3.2 - 4.3.11, 4.4.0 - 4.4.4
Fatal error: Call to undefined function: json_decode() in /in/G8oQ8 on line 6
Process exited with code 255.
Output for 4.3.0 - 4.3.1
Fatal error: Call to undefined function: json_decode() in /in/G8oQ8 on line 6