getMessage()); } // Stats $stats_sql = "SELECT client_name, COUNT(*) as total FROM sms_logs GROUP BY client_name ORDER BY total DESC"; $stats = $pdo->query($stats_sql)->fetchAll(PDO::FETCH_ASSOC); // Logs $logs_sql = "SELECT * FROM sms_logs ORDER BY sent_at DESC LIMIT 100"; $logs = $pdo->query($logs_sql)->fetchAll(PDO::FETCH_ASSOC); ?>
Base de données PostgreSQL
| Date | Client | Message | Statut |
|---|---|---|---|
| OK ERR |