php - 使用电子邮件从数据库中提取用户 ID，并将用户 ID 存储在 session 中

Question

这是我的网站登录页面的代码，我希望它在用户登录时从数据库中提取用户 ID 并将其存储在 session 数据中。我将在另一个页面中使用它从不同的表中提取值。

<?php
session_start();
//Connect to DB
include_once 'db_connect.php';

// escape variables for security
$Email = mysqli_real_escape_string($mysqli, $_POST['email']);
$Password = mysqli_real_escape_string($mysqli, $_POST['password']);
//password hashing
$Password = hash("sha256", $Password);

$sqli="SELECT * FROM users WHERE Email='$Email' and Password='$Password'";
$result=mysqli_query($mysqli, $sqli);

//Mysql_num_row is counting table row
$count=mysqli_num_rows($result);



// If result matched $Email and $Password, table row must be 1 row
if($count==1){

//redirect to file "menu.html"

header("location:menu.html");
}
//If all else fails they shall not pass!
else {
echo "Wrong Email or Password. YOU SHALL NOT PASS!";
}
?>

Answer 1

要从数据库表中获取 ID，请使用 mysqli_fetch_array 或 mysqli_fetch_assoc

将此插入到您的$结果下方

while($row = mysqli_fetch_array($result)): //fetching the row from database

   $id = $row['id']; //the id column in your table
   $_SESSION['id'] = $id; //the id is now saved in your session for future use

endwhile;

在另一个页面中，不要忘记session_start();访问$_SESSION['id']，以便您可以从数据库的表中访问与该id相关的不同信息。