我希望在成功登录后自动打开Home.php
页面。
我的数据库名称是relieffoundation
,它是在WampServer LoCoalhost中创建的。表名是admin
它直接显示它的其他部分是uername和密码不匹配
<div id="user_login_div_input">
<?php
if (isset($_POST['Username'])) {
$user = $_POST['Username'];
$pass = md5($_POST['Password']);
$con = mysqli_connect("localhost", "root", "");
if (!$con) {
die('Could not connect to the database!' . mysqli_errno());
}
$selectdb = mysqli_select_db($con, 'relieffoundation') or die("Could not select DataBase");
$query = "SELECT *FROM admin where username = '$user' AND password= '$pass'";
if (mysqli_num_rows(mysqli_query($con, $query))) {
echo "Login successfull";
header("location : Home.php");
} else {
echo "Uername and Password not match!";
}
mysqli_close($con);
}
?>
LOG IN
<form id="myForm" name="myForm" method="post">
<input class="input" type="text" id="Username" name="Username" placeholder="Username" required="">
<input class="input" type="password" id="Password" name="Password" placeholder="Password" required="">
<button id="login" type="submit" > Log In</button>
</form>
你有
$query = "SELECT *FROM admin where username = '$user' AND password= '$pass'";
您需要在 * 和 FROM 之间留一个空格
$query = "SELECT * FROM admin where username = '$user' AND password= '$pass'";
尝试在查询中删除' $query = "SELECT *FROM admin where username = $user AND password= $pass";
或尝试串联 $query = "SELECT *FROM admin where username ='". $user."' AND password='". $pass.'";