prepare("UPDATE users SET status = ? WHERE id = ?");
$stmt->bind_param("si", $status, $user_id);
if ($stmt->execute()) {
$success = 'User status updated successfully!';
} else {
$error = 'Failed to update user status';
}
}
// Delete user
if (isset($_GET['delete'])) {
$user_id = (int)$_GET['delete'];
$conn->query("DELETE FROM users WHERE id = $user_id AND role = 'user'");
$success = 'User deleted successfully!';
}
// Pagination
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$per_page = 20;
$offset = ($page - 1) * $per_page;
// Search
$search = isset($_GET['search']) ? sanitize($_GET['search']) : '';
$where = "WHERE role = 'user'";
if ($search) {
$where .= " AND (username LIKE '%$search%' OR email LIKE '%$search%' OR full_name LIKE '%$search%')";
}
// Get total users
$total_users = $conn->query("SELECT COUNT(*) as count FROM users $where")->fetch_assoc()['count'];
$total_pages = ceil($total_users / $per_page);
// Get users
$users = $conn->query("SELECT * FROM users $where ORDER BY created_at DESC LIMIT $per_page OFFSET $offset");
include '../includes/header.php';
?>