query("SELECT COUNT(*) FROM utilisateurs")->fetchColumn();
$countPosts = $pdo->query("SELECT COUNT(*) FROM posts")->fetchColumn();
$postsPerUser = $pdo->query("
SELECT u.username, COUNT(p.id) AS total
FROM utilisateurs u
LEFT JOIN posts p ON p.user_id = u.id
GROUP BY u.id
")->fetchAll(PDO::FETCH_ASSOC);
$users = $pdo->query("SELECT id, username, role FROM utilisateurs ORDER BY id")->fetchAll();
$posts = $pdo->query("SELECT p.id, p.title, u.username FROM posts p JOIN utilisateurs u ON p.user_id = u.id ORDER BY p.date_creation DESC")->fetchAll();
$msg = '';
if (isset($_GET['delete_user'])) {
$id = (int)$_GET['delete_user'];
if ($id !== (int)$_SESSION['user']['id']) {
$pdo->prepare("DELETE FROM utilisateurs WHERE id = ?")->execute([$id]);
$msg = "Utilisateur supprimé ✅";
}
}
if (isset($_GET['delete_post'])) {
$pdo->prepare("DELETE FROM posts WHERE id = ?")->execute([(int)$_GET['delete_post']]);
$msg = "Article supprimé ✅";
}
?>
Dashboard - Admin
🌸 Tableau de bord administrateur
👥 Gestion des utilisateurs
📝 Gestion des articles