尝试显示用户 ID - 显示为 0


Trying to show user id - showing as 0

登录:

$_SESSION['username'] = $username;
$id = mysql_query("SELECT  `id`  FROM  `users` WHERE `username`='" . $username . "'");
$_SESSION['logged_in'] = 1;
$_SESSION['id'] = $id;

索引(尝试在此处显示它)

Welcome, <?= $username ?><br> ((works))
ID: <?= $id ?>

id 仅显示为 0,而实际上它是 1。

mysql_query()返回资源 ID,而不是查询结果。您需要使用mysql_fetch_assoc()mysql_result()来获取您的值:

$res = mysql_query("SELECT  `id`  FROM  `users` WHERE `username`='" . $username . "'");
$result = mysql_fetch_assoc($res);
$id = $result['id'];

$res = mysql_query("SELECT  `id`  FROM  `users` WHERE `username`='" . $username . "'");
$id = mysql_result($result, 0);

还有其他方法可以做到这一点,但这会显示一般错误发生的位置。