prepare(" INSERT INTO push_badge_counters (compte_id, msg_unread, rdv_unread, updated_at) VALUES (:cid, 0, 0, NOW()) ON DUPLICATE KEY UPDATE rdv_unread = 0, updated_at = NOW() ")->execute([':cid' => (int) $_SESSION['compte_id']]); $client_id = $_SESSION['reference_id']; $stmt = $pdo->prepare(" SELECT rv.*, p.nom AS nom_praticien, p.prenom AS prenom_praticien, p.email AS email_praticien, p.adresse AS p_adresse, p.ville AS p_ville, p.code_postal AS p_cp FROM rendez_vous rv JOIN praticien p ON rv.praticien_id = p.id WHERE rv.client_id = ? AND rv.date_rdv >= NOW() ORDER BY rv.date_rdv ASC "); $stmt->execute([$client_id]); $rdvs = $stmt->fetchAll(PDO::FETCH_ASSOC); $PAGE_TITLE = $translations['mes_rdv_title'] ?? 'Mes rendez-vous'; $HEAD_EXTRA = << HTML; require_once '../includes/header.php'; ?>