登录:
$_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);
还有其他方法可以做到这一点,但这会显示一般错误发生的位置。