php实现注册功能,在实现修改密码时,要检查用户是否存在,如果存在,可以修改。效果图如下:
注册页面代码
`<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>register</title>
<link type="text/css" rel="stylesheet" href="css/注册.css"/>
</head>
<body>
<div id="loginDiv">
<form action="#" method="post">
<h1 style="text-align: center;color: aliceblue;">REGESTER</h1>
<p>用户名:<input id="username" name="username" type="text"><label id="name_trip"></label></p>
<p>密码: <input id="password1" name="password1" type="password"><label id="password_trip"></label></p>
<p>确认密码:<input id="password2" name="password2" type="password" required><label id="surePassword_trip"></label></p>
<div style="text-align: center;margin-top: 30px;">
<input type="submit" class="button" value="login up" onClick="return chkname(foundname)">
<input type="reset" class="button" value="reset">
</div>
</form>
</div>
<?php
//声明变量
$name = isset($_POST['username'])?$_POST['username']:"";
$pwd1 = isset($_POST['password1'])?$_POST['password1']:"";
$pwd2 = isset($_POST['password2'])?$_POST['password2']:"";
// $pwd2 = isset($_POST['password'])?$_POST['password']:"";
if(!empty($name)&&!empty($pwd1)&&!empty($pwd2)) {
$mysql_server_name = "127.0.0.1:3306"; //衔接数据库端口
$mysql_username = "root"; //用户名
$mysql_password = "123456"; //暗码
$mysql_database = "php"; //数据库称号
$conn = new mysqli($mysql_server_name, $mysql_username, $mysql_password, $mysql_database); //组织函数mysql
//$sql = $conn->query("select * from login where name ='{$name}' and pwd = '{$pwd}'"); //查询数据库中的用户名和暗码 并返回鸠合
// $row = mysqli_fetch_array($sql);
//判断用户名或密码是否正确
$sql = $conn->query("select * from login where name ='{$name}'");
$row = mysqli_fetch_assoc($sql); //取其中一行
if($row > 0){
echo "<script language=\"JavaScript\">\r\n";
echo " alert(\"用户名已存在\");\r\n";
echo " history.back();\r\n";
echo "</script>";
exit;
}else if($pwd1!=$pwd2){
echo "<script language=\"JavaScript\">\r\n";
echo " alert(\"两次密码不一致\");\r\n";
echo " history.back();\r\n";
echo "</script>";
exit;
}else{
$sql1 ="insert into login(name,pwd) values('".$name."','".$pwd1."')";
$result=mysqli_query($conn,$sql1);
session_start();/*打开会话,将用户名和昵称存起来*/
$_SESSION['username']=$name;
$_SESSION['password1']=$pwd1;
if($result){
echo "<script language=\"JavaScript\">\r\n";
echo " alert(\"添加成功\");\r\n";
echo " location.replace(\"登录.php\");\r\n"; // 自己修改网址
echo "</script>";
exit;
}else{
echo "<script language=\"JavaScript\">\r\n";
echo " alert(\"添加失败\");\r\n";
echo " history.back();\r\n";
echo "</script>";
exit;
}
}
}
?>
</body>
</html>
注册.css
* {
margin: 0;
padding: 0;
}
html {
height: 100%;
width: 100%;
overflow: hidden;
margin: 0;
padding: 0;
background: url(../image/3.jpeg) no-repeat 0px 0px;
background-repeat: no-repeat;
background-size: 100% 100%;
-moz-background-size: 100% 100%;
}
body {
display: flex;
align-items: center;
justify-content: center;
height: 100%;
}
#loginDiv {
width: 37%;
display: flex;
justify-content: center;
align-items: center;
height: 300px;
background-color: rgba(75, 81, 95, 0.3);
box-shadow: 7px 7px 17px rgba(52, 56, 66, 0.5);
border-radius: 5px;
}
#name_trip {
margin-left: 50px;
color: red;
}
p {
margin-top: 30px;
margin-left: 20px;
color: azure;
}
input {
margin-left: 15px;
border-radius: 5px;
border-style: hidden;
height: 30px;
width: 140px;
background-color: rgba(216, 191, 216, 0.5);
outline: none;
color: #f0edf3;
padding-left: 10px;
}
.button {
border-color: cornsilk;
background-color: rgba(100, 149, 237, .7);
color: aliceblue;
border-style: hidden;
border-radius: 5px;
width: 100px;
height: 31px;
font-size: 16px;
}
注册成功跳到登录页面
修改密码代码:
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>无标题文档</title>
</head>
<style>
* {
margin: 0;
padding: 0;
}
html {
height: 100%;
width: 100%;
overflow: hidden;
margin: 0;
padding: 0;
background: url(image/alter.jpg) no-repeat 0px 0px;
background-repeat: no-repeat;
background-size: 100% 100%;
-moz-background-size: 100% 100%;
}
body {
display: flex;
align-items: center;/*属性定义flex子项在flex容器的当前行的侧轴(纵轴)方向上的对齐方式*/
justify-content: center;/*所有元素的被空格包裹起来*/
height: 100%;
}
#loginDiv {
width: 37%;
display: flex;
justify-content: center;
align-items: center;
height: 300px;
background-color: rgba(75, 81, 95, 0.3);
box-shadow: 7px 7px 17px rgba(52, 56, 66, 0.5);
border-radius: 5px;
}
#name_trip {
margin-left: 50px;
color: red;
}
p {
margin-top: 30px;
margin-left: 20px;
color: azure;
}
input,a {
margin-left: 15px;
border-radius: 5px;
border-style: hidden;
height: 30px;
width: 140px;
background-color: rgba(216, 191, 216, 0.5);
outline: none;
color: #f0edf3;
padding-left: 10px;
}
.button {
border-color: cornsilk;
background-color: rgba(100, 149, 237, .7);
color: aliceblue;
border-style: hidden;
border-radius: 5px;
width: 140px;
height: 30px;
font-size: 16px;
padding: 1px;
}
a{
text-decoration: none;
}
</style>
<body>
<div id="loginDiv">
<form id="foundname" name="found" method="get" action="#">
<p style="text-align:center">
<tr>
<td height="25" colspan="2" align="center" valign="middle" class="first"> 修改密码</td>
</tr>
</p>
<tr>
<td height="25" colspan="2" align="center" valign="middle" class="first"> </td>
</tr>
<p>
<tr>
<td width="113" height="25" align="right" valign="middle" class="left">会员名称:</td>
<td width="187" align="left" valign="middle" class="right"><input id="user" name="user" type="text" class="txt"></td>
</tr>
</p>
<tr>
<td height="25" colspan="2" align="center" valign="middle" class="first"> </td>
</tr>
<p>
<tr>
<td width="113" height="25" align="right" valign="middle" class="left">修改密码:</td>
<td width="187" align="left" valign="middle" class="right"><input id="password" name="password" type="text" class="txt"></td>
</tr>
</p>
<tr>
<td height="25" colspan="2" align="center" valign="middle" class="first"> </td>
</tr>
<p>
<tr>
<td height="25" colspan="2" align="center" valign="middle"><input type="submit" id="login" name="login" value="下一步" class="button" onClick="return chkname(foundname)"></td>
</tr>
</p>
</form>
</div>
<script language="javascript">
function chkname(form) {
var user = form.user.value;
var password=form.password.value;
if(user == ''){
alert('请输入用户名');
form.user.focus();
return false;
}else if(password==''){
alert('请输入密码');
form.password.focus();
return false;
}else{
<?php
$username = $_GET["user"]; //猎取输入用户名
$password = $_GET["password"]; //猎取输入暗码
$mysql_server_name = "127.0.0.1:3306"; //衔接数据库端口
$mysql_username = "root"; //用户名
$mysql_password = "123456"; //暗码
$mysql_database = "php"; //数据库称号
$conn = new mysqli($mysql_server_name, $mysql_username, $mysql_password, $mysql_database); //组织函数mysql
// $sql = $conn->query("select username from user where username ='{$username}' and password = '{$password}'"); //查询数据库中的用户名和暗码 并返回鸠合
$sql = $conn->query("select name from login where name ='{$username}'");
$row = mysqli_fetch_assoc($sql); //取其中一行
if ($row > 0) { //推断是不是存在
//echo "{$username}用户存在";
$sqlstr = "update login set pwd='$password' where name='$username'";
$result = mysqli_query($conn,$sqlstr);//执行更新语句
header("Location:登录.php");
} else {
echo "{$username}用户不存在";
}
?>
}
}
</script>
</body>
</html>
修改成功跳到登录页面