我正在尝试创建一个与数据库通信的php登录页面。所以我创建了一个用户可以创建帐户的注册页面。现在我希望能够与用户一起登录并创建一个会话,所以这就是我尝试过的(包括php开放标签)。但是,这只会返回一个错误
include('connect.php');
if(isset($_POST['login'])){
$UserName = mysqli_real_escape_string($conn,$_POST['UserName']);
$Password = mysqli_real_escape_string($conn,$_POST['Password']);
$PasswordToCheck = password_hash($Password, PASSWORD_DEFAULT);
$pp = mysqli_real_escape_string($conn,$PasswordToCheck);
$sql = "SELECT UserID FROM users".
"WHERE UserName = '$UserName' AND Password = '$pp'";
$result = mysqli_query($conn->$sql);
echo $result;
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
$count = mysqli_num_rows($result);
echo $count;
if($count == 1){
session_register("LoggedIn");
$_SESSION['login_user'] = $UserName;
echo "Logged In";
}else{
echo "Error";
}
}
?>
任何帮助,将不胜感激。我认为这与我如何查询数据库有关,但我不确定。