6 min to read
php7实现简单注册登录系统
创建用户信息表
连接mysql，创建用户信息表。
create database register;
use register;
create table register(
id INT NOT NULL AUTO_INCREMENT,
username VARCHAR(100) NOT NULL,
password VARCHAR(40) NOT NULL,
PRIMARY KEY ( id )
);
实现简单注册登录系统
下面创建的文件均放在F:\amp\Apache24\htdocs文件夹内。
创建login.html
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>登录界面</title>
</head>
<body>
<form method="post" action="login.php">
账号：
<input type="text" name="usernamel"><br/><br/>
密码：
<input type="password" name="passwordl">
<input type="submit" value="登录" name="subl">
<a href="http://127.0.0.1:8080/register.html">没有账号，注册</a>
</form>
</body>
</html>
创建register.html
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>会员注册</title>
</head>
<body>
<form method="post" action="register.php">
账 户：
<input type="text" name="username"><br/><br/>
密 码：
<input type="password" name="password"><br/><br/>
密码确认：
<input type="password" name="password2">
<input type="submit" value="注册" name="sub">
</form>
</body>
</html>
创建success.html
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>登陆成功</title>
</head>
<body>
登陆成功！
</body>
</html>
创建return.html
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>无标题文档</title>
</head>
<body>
注册成功！<br/>
5秒后返回登录界面<br/>
你也可以直接点击回到<a href="http://127.0.0.1:8080/login.html">登录页面</a>
<script type="text/javascript">
setTimeout("ren()",5000);
function ren()
{
window.location="http://127.0.0.1:8080/login.html";
}
</script>
</body>
</html>
创建login.php
<?php
header("Content-type:text/html;charset=utf-8");
$link=mysqli_connect("localhost:3306","root","LLte6628","login");
if($link)
{
if(isset($_POST["subl"]))
{
$name=$_POST["usernamel"];
$password=$_POST["passwordl"];
if($name==""||$password=="")//判断是否为空
{
echo"<script type="."\""."text/javascript"."\"".">"."window.alert"."("."\""."请填写正确的信息！"."\"".")".";"."</script>";
echo"<script type="."\""."text/javascript"."\"".">"."window.location="."\""."http://127.0.0.1:8080/login.html"."\""."</script>";
exit;
}
$str="select password from register where username='$name'";
$link->query('SET NAMES UTF8');
$result=$link->query($str);
$pass=mysqli_fetch_assoc($result);
$password=$pass[0];
if($pa==$password)//判断密码与注册时密码是否一致
{
echo"登录成功！";
echo"<script type="."\""."text/javascript"."\"".">"."window.location="."\""."http://127.0.0.1:8080/success.html"."\""."</script>";
}
else
{
echo"<script type="."\""."text/javascript"."\"".">"."window.alert"."("."\""."登录失败！"."\"".")".";"."</script>";
echo"<script type="."\""."text/javascript"."\"".">"."window.location="."\""."http://127.0.0.1:8080/login.html"."\""."</script>";
}
}
}
?>
创建register.php
<?php
$link=mysqli_connect("localhost:3306","root","LLte6628","login");
header("Content-type:text/html;charset=utf-8");
if($link)
{
//echo"选择数据库成功！";
if(isset($_POST["sub"]))
{
$name=$_POST["username"];
$password1=$_POST["password"];
$password2=$_POST["password2"];
if($name==""||$password1=="")
{
echo"<script type="."\""."text/javascript"."\"".">"."window.alert"."("."\""."请填写完成！"."\"".")".";"."</script>";
echo"<script type="."\""."text/javascript"."\"".">"."window.location="."\""."http://127.0.0.1:8080/register.html"."\""."</script>";
exit;
}
if($password1==$password2)
{
$str="select count(*) from register where username="."'"."$name"."'";
$link->query('set names utf8;');
$result=$link->query($str);
$pass=mysqli_fetch_assoc($result);
$pa=$pass[0];
if($pa==1)
{
echo"<script type="."\""."text/javascript"."\"".">"."window.alert"."("."\""."该用户名已被注册"."\"".")".";"."</script>";
echo"<script type="."\""."text/javascript"."\"".">"."window.location="."\""."http://127.0.0.1:8080/register.html"."\""."</script>";
exit;
}
$sql="insert into register (username,password) VALUES ('$name','$password1')";
//echo"$sql";
$link->query('SET NAMES UTF8');
$link->query($sql);
$close=mysqli_close($link);
if($close)
{
//echo"数据库关闭";
//echo"注册成功！";
echo"<script type="."\""."text/javascript"."\"".">"."window.location="."\""."http://127.0.0.1:8080/return.html"."\""."</script>";
}
}
else
{
echo"<script type="."\""."text/javascript"."\"".">"."window.alert"."("."\""."密码不一致！"."\"".")".";"."</script>";
echo"<script type="."\""."text/javascript"."\"".">"."window.location="."\""."http://127.0.0.1:8080/register.html"."\""."</script>";
}
}
}
?>
验证
在浏览器中输入localhost:8080/login.html。
参考资料
[1]. PHP实现简单注册登录系统
Comments