wordpress 子比主题 用户付费购买资源信息 在网站前端滚动播放代码

function get_purchased_users_and_resources() {
    global $wpdb;

    // 假设购买记录存储在自定义表 `wp_purchases` 中
    $query = "
        SELECT u.user_nicename, u.user_email, p.resource_name, p.purchase_date
        FROM {$wpdb->users} u
        INNER JOIN wp_purchases p ON u.ID = p.user_id
        ORDER BY p.purchase_date DESC
    ";

    $results = $wpdb->get_results($query, ARRAY_A); // 返回关联数组
    return $results;
}

<div class="scrolling-banner">
    <?php
    $purchases = get_purchased_users_and_resources();
    foreach ($purchases as $purchase) {
        echo '<div class="purchase-item">';
        echo '<p>用户：' . $purchase['user_nicename'] . '（' . $purchase['user_email'] . '）</p>';
        echo '<p>购买资源：' . $purchase['resource_name'] . '</p>';
        echo '<p>购买时间：' . $purchase['purchase_date'] . '</p>';
        echo '</div>';
    }
    ?>
</div>

.scrolling-banner {
    display: flex;
    overflow-x: hidden;
    scroll-behavior: smooth;
    white-space: nowrap;
    padding: 10px;
    background: #f8f8f8;
    border-radius: 8px;
    box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}

.purchase-item {
    display: inline-block;
    margin-right: 20px;
    padding: 10px;
    background: #ffffff;
    border-radius: 4px;
    box-shadow: 0 1px 2px rgba(0, 0, 0, 0.1);
}

@media (max-width: 768px) {
    .purchase-item {
        font-size: 12px;
    }
}

@keyframes scroll {
    0% { transform: translateX(0); }
    100% { transform: translateX(-100%); }
}

.scrolling-banner {
    animation: scroll 30s linear infinite;
}