如何从数据库中选择多个数据并将其分配到会话中？

Question

我想从数据库中选择数据并将其分配到会话中。后来我想调用它并使用它..

$sql = "SELECT * FROM users WHERE email = '$email' AND password = 

  '$password'";

  $query = mysqli_query($mysqli, $sql) or die ("Error: " . 

  mysqli_error($mysqli));

  $row = mysqli_num_rows($query);

  if($row == 0)

  {

     echo "Invalid Username/Password. Click here to <a href = 

     'login.html'>Login</a>";

  }

  else

  {

     $sql = "SELECT accname FROM account WHERE email = '$email'";

     $result=mysqli_query($mysqli,$sql);

     $row=mysqli_fetch_all($result,MYSQLI_BOTH);

     $_SESSION['accname']= array_column($rows, 'accname');

     $r = mysqli_fetch_assoc($query);

     $_SESSION['fname'] = $r['fname'];

     $_SESSION['lname'] = $r['lname'];

     $_SESSION['email'] = $r['email'];

     header("Location: dashboard.php");

   }

Answer 1

如果用户可以有多个accname与其电子邮件地址关联的值，那么您可以使用array_column从结果数据中提取所有这些值：$sql = "SELECT accname FROM account WHERE email = '$email'";$result=mysqli_query($mysqli,$sql);$rows=mysqli_fetch_all($result,MYSQLI_BOTH);$_SESSION['accname']= array_column($rows, 'accname');如果只能有一个accname，您可以简单地将调用更改mysqli_fetch_all为mysqli_fetch_assoc：$sql = "SELECT accname FROM account WHERE email = '$email'";$result=mysqli_query($mysqli,$sql);$row=mysqli_fetch_assoc($result);$_SESSION['accname']= $row['accname'];