query("SELECT * FROM users WHERE deleted_at IS NULL ORDER BY role, full_name")->fetchAll(); // Handle deletion if (isset($_GET['delete'])) { $id = (int)$_GET['delete']; if ($id === (int)$_SESSION['user_id']) { $_SESSION['error'] = "You cannot delete your own account."; } else { $stmt = db()->prepare("UPDATE users SET deleted_at = NOW() WHERE id = ?"); $stmt->execute([$id]); $_SESSION['success'] = "User deleted successfully."; } header("Location: users.php"); exit; } ?>