phpcms调用会员昵称

<?php
// 假设已经连接到数据库
$userId = 123; // 需要查询的用户ID

// SQL 查询语句
$sql = "SELECT nickname FROM user WHERE id = :userId";

// 使用 PDO 进行数据库查询
try {
    $pdo = new PDO('mysql:host=localhost;dbname=phpcms', 'username', 'password');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(':userId', $userId, PDO::PARAM_INT);
    $stmt->execute();
    
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if ($result) {
        $nickname = $result['nickname'];
        echo "会员昵称: " . htmlspecialchars($nickname);
    } else {
        echo "用户不存在";
    }
} catch (PDOException $e) {
    echo "数据库错误: " . $e->getMessage();
}
?>