我有以下代码 -
<?php
$con=mysqli_connect("localhost","root","","my_db");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysql_select_db("my_db");
$myusername=mysql_real_escape_string($_POST['myusername']);
$mypassword=mysql_real_escape_string($_POST['mypassword']);
echo $myusername . " " . $mypassword;
$sql="SELECT id FROM EMPLOYEE WHERE username='" . $myusername . "' and password='" . $mypassword . "'";
$result=mysqli_query($con, $sql);
// If result matched $myusername and $mypassword, table row must be 1 row
if (mysql_num_rows($result) > 0) {
// Register $myusername, $mypassword and redirect to file "login_success.php"
$_SESSION["username"] = $myusername;
$_SESSION["password"] = $mypassword;
header("location:login_success.php");
} else {
echo "Wrong Username or Password";
}
mysqli_close($con);
?>
"雇员"表包含1 个管理员通行证作为ID用户名和密码
如果我将其输入表单并点击提交,它会打开此代码,该代码check_login.php我已经回显了用户名和密码以检查其输入是否正确。它在屏幕上显示管理员通行证。因此,可以肯定的是正确输入用户名和密码。
现在唯一的问题是员工表中的"检查用户名和密码"。它不起作用。
请帮忙。
你来了:
<?php
$con=mysqli_connect("127.0.0.1", "root", "", "my_db");
if (mysqli_connect_errno($con))
{
echo "MySql Error: " . mysqli_connect_error();
}
$query=mysqli_query($con,"SELECT * FROM employee WHERE username='$_POST[myusername]' && password='$_POST[mypassword]'");
$count=mysqli_num_rows($query);
$row=mysqli_fetch_array($query);
if ($count==1)
{
session_start();
$_SESSION['username'] = $_POST['myusername'];
$_SESSION['password'] = $_POST['mypassword'];
header("location: login_success.php");
}
else
{
echo "Invalid username or password";
}
mysqli_close($con);
?>