<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>注册登录</title>
<link rel="stylesheet" type="text/css" href="https://www.layuicdn.com/layui/css/layui.css" rel="external nofollow" />
<script src="https://www.layuicdn.com/layui/layui.js" charset="utf-8"></script>
</head>
<body>
<!--注册页面-->
<legend>注册登录演示</legend>
<h2>注册</h2>
<form action="register.php" method="post" onsubmit="return checkForm(this)" lay-filter="example">
<lebla>输入框</lebla>
<input type="text" name="username" placeholder="请输入账号"/>
<label>密码框</label>
<input type="password" name="password" placeholder="请输入密码"/>
<input type="submit" name="" value="立即注册"/>
</form>
<script type="text/javascript">
//验证输入不为空的脚本代码
function checkForm(form){
if(form.username.value == ""){
alert("用户名不能为空");
form.username.focus();
return false;
}
if(form.password.value == ""){
alert("密码不能为空");
form.password.focus();
return false;
}
return true;
}
</script>
</body>
</html>
<?php
header("content-type:text/html;charset=utf-8");
//连接数据库,密码为空
$db=mysqli_connect("localhost", "root", "", "demo");
if(!$db){
die("数据库连接失败".mysqli_error($db));
}
//接收$_POST用户名和密码
$username=$_POST['username'];
$password=$_POST['password'];
//查看表user用户名是否存在或为空
$sql_select = "SELECT * FROM user2 WHERE username = '$username'";
//数据库查询
$select = mysqli_query($db,$sql_select);
//函数返回结果集中行的数量
$num = mysqli_num_rows($select);
//判断用户名或者密码是否为空
if($username == "" || $password == "")
{
echo "请确认信息完整性";
}else if($num){
echo "用户名已存在";//已存在账户名输出错误
}else{
$sql="insert into user2(username,password) values('$username','$password')";
//打印sql语句
$result=mysqli_query($db,$sql);
//判断是否注册后显示内容
if(!$result)
{
echo "注册不成功!"."<br>";//输出错误
echo "<a href='index.php'>返回</a>";//超链接到首页
}
else
{
echo "注册成功!"."<br/>";//输出成功
}
}
?>