PHP PDO按用户名获取信息 [英] PHP PDO GET INFORMATION BY USERNAME

问题描述

好的，我以管理员"身份登录，管理员拥有信息-money，xp. 我有代码:

Okay, i'm logged in as "Admin", the admin have information - money, xp. I have the code:

$query = dbConnect()->prepare("SELECT * FROM players");
$query->execute();

foreach ($query->fetchAll(PDO::FETCH_ASSOC) as $row) {
    echo 'Name: '. $row['Name'] . '<br>Money: '.$row['Money'] . '<br>XP: '.$row['XP'];
}

我在mysql中有2个用户.登录的人如何接收该信息?

And i have 2 users in mysql. How to do that information is received by the logged in person?

推荐答案

只需使用当前登录的用户选择特定的行(用户凭据).

Just select the specific row (user credentials) using the currently logged in user.

假设您正在使用会话:

session_start();
$username = $_SESSION['username'];

$connection = dbConnect();
$query = $connection->prepare('SELECT * FROM players WHERE username = ?');
$query->execute(array($username));

$result = $query->fetch(PDO::FETCH_ASSOC);
if(!empty($result)) {
    // echo credentials
    // echo $result['Money']; // etc
}

或使用->bindValue和您的命名占位符:

Or with ->bindValue with your named placeholder:

session_start();
$username = $_SESSION['username'];

$connection = dbConnect();
$query = $connection->prepare('SELECT * FROM players WHERE username = :username');
$query->bindValue(':username', $username);
$query->execute();

$result = $query->fetch(PDO::FETCH_ASSOC);
if(!empty($result)) {
    // echo credentials
    // echo $result['username']; // etc
}

这篇关于PHP PDO按用户名获取信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！