dedecms文章页调用浏览次数

// 假设文章ID为$article_id
$article_id = $_GET['id'];

// 连接数据库
$db = new PDO('mysql:host=localhost;dbname=dedecms', 'username', 'password');

// 更新浏览次数
$sql = "UPDATE `dede_archives` SET `click` = `click` + 1 WHERE `id` = :article_id";
$stmt = $db->prepare($sql);
$stmt->bindParam(':article_id', $article_id);
$stmt->execute();

// 获取更新后的浏览次数
$sql = "SELECT `click` FROM `dede_archives` WHERE `id` = :article_id";
$stmt = $db->prepare($sql);
$stmt->bindParam(':article_id', $article_id);
$stmt->execute();
$result = $stmt->fetch(PDO::FETCH_ASSOC);

echo "浏览次数: " . $result['click'];

// 开启事务
$db->beginTransaction();

try {
    // 更新浏览次数
    $sql = "UPDATE `dede_archives` SET `click` = `click` + 1 WHERE `id` = :article_id";
    $stmt = $db->prepare($sql);
    $stmt->bindParam(':article_id', $article_id);
    $stmt->execute();

    // 获取更新后的浏览次数
    $sql = "SELECT `click` FROM `dede_archives` WHERE `id` = :article_id";
    $stmt = $db->prepare($sql);
    $stmt->bindParam(':article_id', $article_id);
    $stmt->execute();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);

    echo "浏览次数: " . $result['click'];

    // 提交事务
    $db->commit();
} catch (Exception $e) {
    // 回滚事务
    $db->rollBack();
    echo "更新失败: " . $e->getMessage();
}