php登陆页面一直密码账号错误

Question

<?php

$link = mysqli_connect("localhost", "root", "", "test") or die(mysqli_error);
$name = $_POST["user"];
$pw = $_POST["password"];

if($name == "" || $pw =="")
{
echo "输入账号和密码";
}
else
{
$sql = "select * from user where logoin name == $name and pw = $pw ";
$qurey = mysqli_query($link,$sql);
$num = mysqli_num_rows($qurey);
if($num)
{
$row = mysqli_fetch_array($query); //将数据以索引方式储存在数组中
echo $row[0]." 欢迎！";
}
else
{
echo "<script>alert('用户名或密码不正确！');history.go(-1);</script>";
}
}

?>
这是代码求大神看看哪里错了

Answer 1

我觉得你的sql可能有问题。试着改一下sql:12//$sql&nbsp;=&nbsp;"select&nbsp;*&nbsp;from&nbsp;user&nbsp;where&nbsp;logoin&nbsp;name&nbsp;==&nbsp;$name&nbsp;and&nbsp;pw&nbsp;=&nbsp;$pw&nbsp;";$sql&nbsp;=&nbsp;"select&nbsp;*&nbsp;from&nbsp;user&nbsp;where&nbsp;logoin&nbsp;name&nbsp;=&nbsp;'$name'&nbsp;and&nbsp;pw&nbsp;=&nbsp;'$pw'&nbsp;";

Answer 2

if判断的类型是什么。查查if($num>0）试试追问是应该sql的问题追答全等和等于 或者是sql没有权限去请求查询数据库的权限。就这，sql放在数据库执行。追问把$name改成数据库里面的值。数据库执行这一条语句可以成功查询