首先在test1数据库创建一个admin表
create table admin(username varchar(255),password varchar(255));
insert into admin value('admin','admin'); #先插入一个账户
HTML文件:
后台管理
<form action='1.php' method='POST'>
用户名<input type='text' name='username' /><br />
密码<input type='password' name='password' /><br />
<input type='submit' value="提交" />
</form>
PHP文件:
<meta charset='utf-8'>
<?php
$username = $_POST['username']; #用户名
$password = $_POST['password']; #密码
$conn = mysqli_connect('localhost','root','root','fuli');
$sql = "select * from admin where username='$username' and password='$password'"; #必须使用双引号,解析变量
$result = mysqli_query($conn,$sql);
if(mysqli_fetch_array($result)['username'] == $username){
echo '登录成功';
}
else{
echo '登录失败';
}
?>