dedecms 数字递增

// 示例代码：使用事务实现数字递增
try {
    $db->beginTransaction();
    $sql = "UPDATE `table_name` SET `counter` = `counter` + 1 WHERE `id` = ?";
    $stmt = $db->prepare($sql);
    $stmt->execute([$id]);
    $db->commit();
} catch (Exception $e) {
    $db->rollBack();
    throw $e;
}

// 示例代码：使用缓存实现数字递增
$cacheKey = 'counter_key';
$counter = $cache->get($cacheKey);
if ($counter === false) {
    $sql = "SELECT `counter` FROM `table_name` WHERE `id` = ?";
    $stmt = $db->prepare($sql);
    $stmt->execute([$id]);
    $row = $stmt->fetch();
    $counter = $row['counter'] ?? 0;
    $cache->set($cacheKey, $counter, 3600); // 缓存1小时
}
$counter++;
$cache->set($cacheKey, $counter, 3600); // 更新缓存