(int) $user['id']]; if ($q !== '') { $sql .= ' AND (first_name LIKE :q OR last_name LIKE :q OR nationality LIKE :q OR position_name LIKE :q)'; $params['q'] = '%' . $q . '%'; } if ($sport !== '') { $sql .= ' AND sport_name = :sport'; $params['sport'] = $sport; } if ($club !== '') { $sql .= ' AND club_name = :club'; $params['club'] = $club; } if ($status !== '') { $sql .= ' AND status = :status'; $params['status'] = $status; } $sql .= ' ORDER BY created_at DESC'; $stmt = db()->prepare($sql); $stmt->execute($params); $athletes = $stmt->fetchAll(); $sports = db()->prepare('SELECT DISTINCT sport_name FROM athletes WHERE user_id = :user_id ORDER BY sport_name ASC'); $sports->execute(['user_id' => (int) $user['id']]); $clubs = db()->prepare('SELECT DISTINCT club_name FROM athletes WHERE user_id = :user_id ORDER BY club_name ASC'); $clubs->execute(['user_id' => (int) $user['id']]); render_header('Liste des sportifs', ['description' => 'Filtrer, parcourir et consulter les fiches sportifs enregistrées.']); ?>

Registre principal

Liste des sportifs

Ajouter un sportif
Réinitialiser
Sportif Sport Club actuel Statut Stats
MJ · PTS · AST Voir la fiche

Aucun résultat

Aucune fiche ne correspond à vos filtres actuels.

Créer la première fiche