PHP/MySQL登录问题 [英] PHP/MySQL Login issue

问题描述

在为我的网站创建登录并将其连接到数据库时，我需要帮助.

I need help with creating the log in for my website and connecting it to the database.

这是php代码

<?php
 session_start();
 include("dbconnect.php");
 $numrows=0;
 $member=$_GET['Membership_Number'];
 $password=$_GET['Password'];
 $query="select First_name, Last_name, Membership_Number from members where (Membership_Number='$member' && Password='$password')";
 $link = mysql_query($query);
 if (!$link) {
  die('login error');
 }
 $numrows=mysql_num_rows($link);
 if ($numrows>0){  // authentication is successfull
  $row = mysql_fetch_array($link, MYSQL_ASSOC);
  $_SESSION['user']['first_name']=$row['fname'];
  $_SESSION['user']['last_name']=$row['lname'];
  $_SESSION['user']['email']=$row['email'];
  header("location:index.php");
 } else {
  header("location:../invalid.php");  // authentication was unsuccessfull
 }
?>

这是HTML代码

<form id="jjjj" method="post" action="Send_log_details.php" class="register">
        <ul>
            <li>
            Membership Number:<br>
            <input type="text" id="Membership_Number" name="Membership_Number">
            </li>
            <li>
            Password:<br>
            <input type="password"  id="Password" name="Password" value="Login">
            </li>
            <li>

            <input type="submit" name="register" value="Login" onclick="logMeIn()">             
            </li>
        </ul>
        </form>

有人可以解释为什么此代码不起作用

Could someone please explain why this code does not work

谢谢

推荐答案

1. 您具有使用method=post的表单，并且在php中使用的是$_GET.
2. 您的查询不正确.

1. You have form with method=post and in php you are using $_GET.
2. Your Query isn't correct.

@njk也发表了评论，

As @njk also commented,

请不要在新代码中使用mysql_ *函数.他们不再 维护并已正式弃用.

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated.

这篇关于PHP/MySQL登录问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！