php - 成员(member)和管理员的不同重定向

Question

希望一切都好!

我正在尝试对我的login.php进行编码，以便它重定向到成员(member)的consumerView.php和员工/管理员的admin.php。我已经编写了以下 php 代码，但即使登录信息的角色是针对员工，我仍然被重定向到consumerView.php。有人可以提供任何见解来使其正常工作吗？SQL查询有效，我在phpmyadmin中测试了它。免责声明:我是 php 新手。

// SELECT query
    $query1 = "SELECT u.id, u.email, u.pass password, r.name role
              FROM users u INNER JOIN role r ON r.id = u.ro_fk
              WHERE email = ? AND u.pass = ? ;";

  if(r.name == 'member'){
  header("Location: consumerView.php");}
  else
  {header("Location: admin.php");}
  die();
} else {
  //If the username/password doesn't matche a user in our database
  // Display an error message and the login form
  echo "Failed to login";
}
} else {
  echo "failed to prepare the SQL";
    }
 }

?>

Answer 1

您已在 $myrow 中得到结果。

$myrow = $result->fetch_assoc();
//Create a session variable that holds the user's id
$_SESSION['id'] = $myrow['id'];
//Redirect the browser to the profile editing page and kill this page.

if($myrow['name'] == 'member'){  // <- You need to change this line to check user is member or not.
header("Location: consumerView.php");
}
else{
header("Location: admin.php");
}