php限制购买次数

<?php
// 假设我们有一个数据库表 user_purchase_limits 存储每个用户的购买次数限制
$db = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// 获取当前用户的ID
$user_id = $_SESSION['user_id'];

// 查询该用户的购买次数限制
$stmt = $db->prepare("SELECT purchase_limit FROM user_purchase_limits WHERE user_id = :user_id");
$stmt->execute(['user_id' => $user_id]);
$result = $stmt->fetch(PDO::FETCH_ASSOC);

if ($result) {
    $purchase_limit = $result['purchase_limit'];
    // 查询该用户的当前购买次数
    $stmt = $db->prepare("SELECT COUNT(*) AS purchase_count FROM orders WHERE user_id = :user_id");
    $stmt->execute(['user_id' => $user_id]);
    $purchase_count = $stmt->fetch(PDO::FETCH_ASSOC)['purchase_count'];

    if ($purchase_count >= $purchase_limit) {
        echo "您已经达到购买次数上限，无法继续购买。";
    } else {
        // 处理购买逻辑
        // ...
        echo "购买成功！";
    }
} else {
    echo "用户购买次数限制未设置。";
}
?>