写一个登陆页面,并能实现对接数据库,判断用户名与密码是否正确
test.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<h2>欢迎来到王者荣耀!</h2>
<p>请登录</p>
<form name="input" action="welcome.php" method="get">
用户名:<input type="text" name='user'>
密码:<input type="password" name='passwd'>
<input type="submit" value="登录">
welcome.php
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<?php
$uname=$_GET['user'];
$pwd=$_GET['passwd'];
if($uname==null or $pwd==null){ echo "用户名或密码不能为空,请重新输入!";}
else{
$con = mysqli_connect('127.0.0.1', 'root', '123','test');
if (!$con) {
die("连接失败: " . mysqli_connect_error());
}
echo "数据库连接成功";
$sql="select username,password from test.users where username='$uname' and password='$pwd'";
$result=mysqli_query($con,$sql);
$row= mysqli_fetch_assoc($result);
if($row){
echo "登录成功,欢迎".$uname."!";
}
else{
echo "登录失败!<a href='test.php'>重新登录";
}
}
?>
运行截图:
登录成功:
登录失败: