23 lines
903 B
PHP
23 lines
903 B
PHP
<?php
|
|
require_once 'db/config.php';
|
|
|
|
try {
|
|
$pdo = db();
|
|
$stmt = $pdo->query('SELECT title, description, start_date FROM competitions ORDER BY start_date ASC');
|
|
$competitions = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
foreach ($competitions as $competition) {
|
|
echo '<div class="col-md-4 mb-4">';
|
|
echo '<div class="card h-100">';
|
|
echo '<div class="card-body">';
|
|
echo '<h5 class="card-title">' . htmlspecialchars($competition['title']) . '</h5>';
|
|
echo '<p class="card-text">' . htmlspecialchars($competition['description']) . '</p>';
|
|
echo '<p class="card-text"><small class="text-muted">Starts on: ' . date("F j, Y", strtotime($competition['start_date'])) . '</small></p>';
|
|
echo '</div>';
|
|
echo '</div>';
|
|
echo '</div>';
|
|
}
|
|
} catch (PDOException $e) {
|
|
echo '<p class="text-danger">Failed to load competitions.</p>';
|
|
}
|