一言: 代码高大上,但不接帝国cms
<?php // 假设你已经有一个有效的用户ID,这里用$userid表示 $userid = $_SESSION['userid']; // 或者从其他有效的会话变量中获取
// 数据库连接信息(根据你的实际情况调整) $dbhost = 'localhost'; $dbname = 'your_database_name'; $dbuser = 'your_database_user'; $dbpass = 'your_database_password'; $dbcharset = 'utf8';
// 创建数据库连接 $dsn = "mysql:host=$dbhost;dbname=$dbname;charset=$dbcharset"; $options = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ];
try { $pdo = new PDO($dsn, $dbuser, $dbpass, $options); } catch (\PDOException $e) { throw new \PDOException($e->getMessage(), (int)$e->getCode()); }
// 查询用户等级ID $sql = "SELECT usergroup FROM ecms_member WHERE userid = ?"; $stmt = $pdo->prepare($sql); $stmt->execute([$userid]); $user = $stmt->fetch();
if ($user) { $usergroup_id = $user['usergroup']; // 这就是用户的等级ID echo "用户等级ID: " . $usergroup_id; } else { echo "用户未找到或未登录。"; } ?>
|