PHP登录代码不正常工作任何建议


PHP Login Code not working properly any suggestions?

我一直在一个登录页面上工作,我的代码一直没有工作,有人对我应该做什么有任何提示或想法吗?当我回显num_rows时,它显示的是0,而不是数据库中的实际行数。

        $Email = mysqli_real_escape_string($dbc, trim($_POST['Email']));
        $Password = mysqli_real_escape_string($dbc, trim($_POST['Password']));

        //Look up the email and password in the database
        $query = "SELECT * FROM Users WHERE Email = '$Email' AND Password = MD5('$Password')";
        $data = mysqli_query($dbc, $query);
        $count = mysqli_num_rows($data);
        echo "Num of Rows: " . $count . "<br/>";

将您的密码语句和查询更改为如下。这会解决问题的

$Password = md5($_POST['Password']);

$query = "SELECT * FROM Users WHERE Email = '$Email' AND Password = '$Password'";

相关文章: