<?php $data = [ ['month' => 'Jan', 'year' => 2022, 'data' => ['Jan' => 1563, 'Mar' => 6]], ['month' => 'Feb', 'year' => 2022, 'data' => ['Feb' => 345, 'Mar' => 76, 'May' => 8]], ]; for($row = 1; $row <= 12; $row++){ $monthNameLong = date('F', mktime(0, 0, 0, $row, 1, date('Y'))); $monthNameShort = date('M', strtotime("2022-$row-01")); echo '<tr>'; printf('<td>%1$s</td>', $monthNameLong); if(($data[$row - 1]['month'] ?? null) === $monthNameShort && isset($data[$row - 1]['data'][$monthNameShort])){ $total = $data[$row - 1]['data'][$monthNameShort]; } else { $total = ''; } printf('<td>%1$s</td>', $total); for($col = 1; $col <= 12; $col++){ $colMonthNameShort = date('M', strtotime("2022-$col-01")); printf('<td>%1$s</td>', $data[$row - 1]['data'][$colMonthNameShort] ?? 0); } echo '</tr>'; echo PHP_EOL; }
You have javascript disabled. You will not be able to edit any code.