phpcms调用会员

// 示例代码：检查数据库连接
$mysqli = new mysqli("localhost", "username", "password", "database");
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

// 示例代码：会员登录验证
$username = $_POST['username'];
$password = $_POST['password'];
$sql = "SELECT * FROM `user` WHERE `username` = '$username' AND `password` = '$password'";
$result = $mysqli->query($sql);
if ($result->num_rows > 0) {
    $_SESSION['user_id'] = $result->fetch_assoc()['id'];
    echo "Login successful!";
} else {
    echo "Login failed!";
}

// 示例代码：权限验证
$user_id = $_SESSION['user_id'];
$sql = "SELECT `role` FROM `user` WHERE `id` = $user_id";
$result = $mysqli->query($sql);
$row = $result->fetch_assoc();
if ($row['role'] == 'admin') {
    echo "Access granted!";
} else {
    echo "Access denied!";
}