query($sql); $play = array(array()); while($row = $result->fetch_array(MYSQLI_BOTH)) { $team[number_format($row[0])][number_format($row[1])] = trim($row[6]); $play[number_format($row[0])][number_format($row[1])] = number_format($row[2]); $wins[number_format($row[0])][number_format($row[1])] = number_format($row[3]); $draw[number_format($row[0])][number_format($row[1])] = number_format($row[4]); $loss[number_format($row[0])][number_format($row[1])] = number_format($row[5]); } echo "
"; echo "
"; for ($d = 0; $d <= 31; $d++) { if ($d == 0) { echo "
"; echo "  "; echo "
"; } else { echo "
"; echo " " . $d . " "; echo "
"; } } echo "
"; echo "
"; for ($d = 0; $d <= 31; $d++) { echo "
"; for ($mm = 1; $mm <= 12; $mm++) { $bord = ""; if ($mm == 1) { $bord = " border-start"; } if ($d == 0) { $bord = $bord . " border-top"; } if ($calord <> "a2j") { $m = $mm; } else { $m = $mm + 7; if ($m > 12) { $m = $m - 12; } } if ((date("m") == $m) && (date("d") == $d)) { $hl = "hl-"; $ani = "progress-bar-animated"; $bld = true; } else { $hl = ""; $ani = ""; $bld = false; } echo "
"; $dateObj = DateTime::createFromFormat('!m', $m); $monthName = $dateObj->format('M'); if ($d == 0 ) { echo "" . $monthName . ""; } else { if ((($m == 2 || $m == 4 || $m == 6 || $m == 9 || $m == 11) && ($d > 30)) || ($m ==2 && $d > 29)) { echo "
 
"; } else { $pl = $play[number_format($m)][number_format($d)]; if ($pl > 0) { if ($team[number_format($m)][number_format($d)] <> "") { $tn = "progress-bar-striped"; $ttn = "
22/23: " . $team[number_format($m)][number_format($d)] . ""; } else { $tn = ""; $ttn = ""; } $wi = $wins[number_format($m)][number_format($d)]; $dr = $draw[number_format($m)][number_format($d)]; $lo = $loss[number_format($m)][number_format($d)]; $winslenpc = ($wi / $pl) * 100; $drawlenpc = ($dr / $pl) * 100; $losslenpc = ($lo / $pl) * 100; $tt = "
" . sprintf('%02d', $d) . " " .$monthName . "
P$pl-W$wi-D$dr-L$lo". $ttn . "
"; $lnk = "\"" . sprintf('%02d', $d) . " " .$monthName . "\""; if ($bld==true) { echo ""; } else { echo ""; } echo ""; } else { echo "
 
"; } } } echo "
"; } echo "
"; } echo "
"; echo "
"; ?>