如何根据用户的电子邮件获取主键?php和mysql

ql3eal8s  于 2021-06-24  发布在  Mysql
关注(0)|答案(3)|浏览(314)

这是用户登录时的代码:

  1. if (isset($_POST['login_user'])) {
  2. $email = mysqli_real_escape_string($db, $_POST['Email']);
  3. $password = mysqli_real_escape_string($db, $_POST['Password']);
  4. if (empty($email)) {
  5. array_push($errors, "email is required");
  6. }
  7. if (empty($password)) {
  8. array_push($errors, "Password is required");
  9. }
  10. if (count($errors) == 0) {
  11. $password = md5($password);
  12. $query = "SELECT * FROM organisers WHERE email='$email' AND password='$password'";
  13. $results = mysqli_query($db, $query);
  14. if (mysqli_num_rows($results) == 1) {
  15. $_SESSION['email'] = $email;
  16. $_SESSION['success'] = "You are now logged in";
  17. header('location: loggedInInterface/loggedIN.php');
  18. }else {
  19. array_push($errors, "Wrong email/password combination");
  20. }
  21. }
  22. }

别担心,我稍后会清理我的代码。如您所见,他们将使用电子邮件和密码登录。如何获取用户主键值?
注意:主键列名='OrganisRid'

3zwtqj6y

3zwtqj6y1#

$row=mysqli\u fetch\u row($result);echo$行[organiserid];

nkoocmlb

nkoocmlb2#

$row=mysqli\u fetch\u assoc($results)$primarykey=$行[OrganizerId];
出于某种原因,您必须使用“mysqli\u fetch\u assoc”而不是“mysqli\u fetch\u row”。

whlutmcx

whlutmcx3#

在“if”语句后包含此项,然后您可以访问它:

  1. $primaryKey = $row['nameOfPrimaryKeyColumn'];

相关问题