我一直在一个登录页面上工作,我的代码一直没有工作,有人对我应该做什么有任何提示或想法吗?当我回显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'";