dedecms 点击次数

// 假设有一个函数用于增加点击次数
function increaseClickCount($id) {
    // 连接数据库
    $conn = mysqli_connect("localhost", "username", "password", "database");
    
    // 使用事务处理
    mysqli_begin_transaction($conn);
    
    try {
        // 查询当前点击次数
        $sql = "SELECT click_count FROM content WHERE id = $id FOR UPDATE";
        $result = mysqli_query($conn, $sql);
        $row = mysqli_fetch_assoc($result);
        
        // 更新点击次数
        $newClickCount = $row['click_count'] + 1;
        $updateSql = "UPDATE content SET click_count = $newClickCount WHERE id = $id";
        mysqli_query($conn, $updateSql);
        
        // 提交事务
        mysqli_commit($conn);
    } catch (Exception $e) {
        // 回滚事务
        mysqli_rollback($conn);
        throw $e;
    }
    
    // 关闭数据库连接
    mysqli_close($conn);
}