收藏文章 楼主

登陆注册-php

版块:php   类型:普通   作者:小绿叶技术博客   查看:1869   回复:2   获赞:3   时间:2020-07-27 17:18:47

########## index.html #######


<!DOCTYPE html>

<html>

<head>

<meta charset="utf-8" />

<title>主界面</title>

</head>

<body>

<center>

<div>

<form action="login.php" method="POST">

用户名:<input type="text" name="username" /><br /><br />

密  码:<input type="password" name="password" /><br /><br />

<input type="submit" value="登录"><br /><br />

</form>

<div>还没有账号?<a href="register.html">马上注册</a></div>

</div>

</center>

</body>

</html>



########## login.php  #######

<?php

$user = $_POST['username'];

$psw = $_POST['password'];

$conn = mysqli_connect('127.0.0.1', 'root', 'password', 'database');

$sql = "select username from userinfo where username='$user' and password='$psw'";

$request  = mysqli_query($conn, $sql);

if(mysqli_fetch_row($request)){

echo "<script>alert('登陆成功'); history.go(-1);</script>";

}

else{

echo "<script>alert('登陆失败'); history.go(-1);</script>";

}

?>


########## register.html  #######


<!DOCTYPE html>

<html>

<head>

<meta charset="utf-8">

<title>注册</title>

</head>

<body>

<center>

<form action="register.php" method="POST">

用户名:<input type="text" name="username" /><br /><br />

密  码:<input type="password" name="password"><br /><br />

确认密码:<input type="password" name="repassword"><br /><br />

<input type="submit" value="注册"><br /><br />

</form>

已有账号,<a href="index.html">马上登录</a>

</center>

</body>

</html>


########## rregister.php  #######

<?php

$user = $_POST['username'];

$psw = $_POST['password'];

$rpsw = $_POST['repassword'];

$conn = mysqli_connect('127.0.0.1', 'root', 'password', 'database');

$sql = "select * from userinfo where username='$user'";

$result = mysqli_query($conn, $sql);

if(!mysqli_fetch_row($result)){

if ($psw==$rpsw) {

$sql = "insert into userinfo(username,password) values('$user','$psw')";

$request = mysqli_query($conn, $sql);

if($request){

echo "<script>alert('注册成功'); top.location='index.html';</script>";

}

}

else{

echo "<script>alert('两次密码不一致'); history.go(-1);</script>";

}

}

else{

echo "<script>alert('用户名已存在'); history.go(-1);</script>";

}

?>




########################   创建数据库表   #########################

# 登录数据库

create table userinfo(username varchar(20),password varchar(20));



提供企业建站服务,免费网防系统,提交信息登录 http://yundun.ddoss.cn 邮箱: proposal@ddoss.cn 
回复列表
默认   热门   正序   倒序

回复:登陆注册-php

头像

用户名:

粉丝数:

签名:

资料 关注 好友 消息