Online PHP editor | refs for dBl1b

<?php $langs = [ 5 => "english", 10 => "french", 12 => "german" ]; $posts = [ [ "date" => "13-07-2022", "lang_id" => 5, "amount" => 90, ], [ "date" => "13-07-2022", "lang_id" => 10, "amount" => 34, ], [ "date" => "14-07-2022", "lang_id" => 5, "amount" => 7, ], ]; $defaults = array_fill_keys($langs, 0); $result = []; foreach ($posts as $row) { extract($row); if (!isset($ref[$date])) { $ref[$date] = ['date' => $date] + $defaults; $result[] = &$ref[$date]; } $ref[$date][$langs[$lang_id]] += $amount; } var_export($result);