<?php
$arr = array(
array('date' => '09-04-2018','item' => 'player 1', 'score' => '1'),
array('date' => '09-04-2018','item' => 'player 2', 'score' => '2'),
array('date' => '10-04-2018','item' => 'player 1', 'score' => '1'),
array('date' => '10-04-2018','item' => 'player 2', 'score' => '2'),
array('date' => '16-04-2018','item' => 'player 1', 'score' => '3'),
array('date' => '16-04-2018','item' => 'player 2', 'score' => '4'),
array('date' => '17-04-2018','item' => 'player 1', 'score' => '3'),
array('date' => '17-04-2018','item' => 'player 2', 'score' => '4')
);
//Week example
Foreach($arr as $val){
$res[$val['item']][date("F", strtotime($val['date']))][] = (int)$val['score'];
}
Foreach($res as $player => $time){
Foreach($time as $timeperiod => $score){
Echo $player. " ". $timeperiod ." " . array_sum($score) ."\n";
}
}
//Var_dump($res);
- 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.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.25, 8.4.1 - 8.4.13
- player 1 April 8
player 2 April 12
preferences:
145 ms | 408 KiB | 5 Q