prepare("SELECT completed_date, COUNT(*) as count FROM completions WHERE completed_date BETWEEN ? AND ? GROUP BY completed_date");
$stmt->execute([$startDate, $endDate]);
$completions = $stmt->fetchAll(PDO::FETCH_KEY_PAIR);
$days = ['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'];
?>
0;
// Get champion for this day
$stmt = $db->prepare("SELECT * FROM champions WHERE day_index = ?");
$stmt->execute([$dayOfWeek]);
$dayChampion = $stmt->fetch();
?>
![<?php echo $dayChampion['name']; ?>](<?php echo getChampionImage($dayChampion['name'], 'card'); ?>)