实现PHP用户的注册与登录

最新推荐文章于 2026-04-28 12:49:56 发布

原创最新推荐文章于 2026-04-28 12:49:56 发布 · 3.5k 阅读

7 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#php #query #javascript #mysql #class

PHP 专栏收录该内容

7 篇文章

订阅专栏

这篇博客详细介绍了如何使用PHP实现用户注册与登录功能。包括创建`user`表，使用HTML和JavaScript进行前端表单验证，PHP处理注册和登录请求，以及通过MySQL数据库存储和验证用户信息。此外，还涉及到了会话管理和用户注销功能。

--
-- 表的结构 `user`
--

CREATE TABLE IF NOT EXISTS `user` (
`uid` mediumint(8) unsigned NOT NULL auto_increment,
`username` char(15) NOT NULL default '',
`password` char(32) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`regdate` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- 转存表中的数据 `user`
--

INSERT INTO `user` (`uid`, `username`, `password`, `email`, `regdate`) VALUES
(1, 'liberty', 'e10adc3949ba59abbe56e057f20f883e', 'aa630866233@126.com', 1323568622),
(2, 'root', 'e10adc3949ba59abbe56e057f20f883e', 'aa@126.com', 1323570910),
(3, 'nihao', 'e10adc3949ba59abbe56e057f20f883e', 'aa@23.com', 1323571726);

conn.php

<?php

/*****************************
*数据库连接
*****************************/
$conn = @mysql_connect("localhost","root","密码");
if (!$conn){
die("连接数据库失败：" . mysql_error());
}
mysql_select_db("test", $conn);
//字符转换，读库
mysql_query("set character set 'gbk'");
//写库
mysql_query("set names 'gbk'");

reg.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk" />
<title>用户注册</title>
<style type="text/css">
    html{font-size:12px;}
   fieldset{width:520px; margin: 0 auto;}
   legend{font-weight:bold; font-size:14px;}
   label{float:left; width:70px; margin-left:10px;}
   .left{margin-left:80px;}
   .input{width:150px;}
   span{color: #666666;}
</style>
<script language=JavaScript>

</script>
</head>
<div>
<fieldset>
<legend>用户注册</legend>
<form name="RegForm" method="post" action="reg.php" onSubmit="return InputCheck(this)">
<p>
<label for="username" class="label">用户名:</label>
<input id="username" name="username" type="text" class="input" />
<span>(必填，3-15字符长度，支持汉字、字母、数字及_)</span>
<p/>
<p>
<label for="password" class="label">密码:</label>
<input id="password" name="password" type="password" class="input" />
<span>(必填，不得少于6位)</span>
<p/>
<p>
<label for="repass" class="label">重复密码:</label>
<input id="repass" name="repass" type="password" class="input" />
<p/>
<p>
<label for="email" class="label">电子邮箱:</label>
<input id="email" name="email" type="text" class="input" />
<span>(必填)</span>
<p/>
<p>
<input type="submit" name="submit" value=" 提交注册 " class="left" />
</p>
</form>
</fieldset>
</div>
<body>
</body>
</html>

reg.php

<?php
if(!isset($_POST['submit'])){
   exit('非法访问!');
}
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
//注册信息判断
if(!preg_match('/^[\w\x80-\xff]{3,15}$/', $username)){
   exit('错误：用户名不符合规定。<a href="javascript:history.back(-1);">返回</a>');
}
if(strlen($password) < 6){
   exit('错误：密码长度不符合规定。<a href="javascript:history.back(-1);">返回</a>');
}
if(!preg_match('/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/', $email)){
   exit('错误：电子邮箱格式错误。<a href="javascript:history.back(-1);">返回</a>');
}
//包含数据库连接文件
include('conn.php');
//检测用户名是否已经存在
$check_query = mysql_query("select uid from user where username='$username' limit 1");
if(mysql_fetch_array($check_query)){
   echo '错误：用户名 ',$username,' 已存在。<a href="javascript:history.back(-1);">返回</a>';
   exit;
}
//写入数据
$password = MD5($password);
//date_default_timezone_set('PRC');
$regdate = time();
$sql = "INSERT INTO user(username,password,email,regdate)VALUES('$username','$password','$email',$regdate)";
if(mysql_query($sql,$conn)){
   exit('用户注册成功！点击此处 <a href="login.html">登录</a>');
} else {
   echo '抱歉！添加数据失败：',mysql_error(),'<br />';
   echo '点击此处 <a href="javascript:history.back(-1);">返回</a> 重试';
}
?>

login.html

login.php

<?php
session_start();

//注销登录
if($_GET['action'] == "logout"){
   unset($_SESSION['userid']);
   unset($_SESSION['username']);
   echo '注销登录成功！点击此处 <a href="login.html">登录</a>';
   exit;
}

//登录
if(!isset($_POST['submit'])){
   exit('非法访问!');
}
$username = htmlspecialchars($_POST['username']);
$password = MD5($_POST['password']);

//包含数据库连接文件
include('conn.php');
//检测用户名及密码是否正确
$check_query = mysql_query("select uid from user where username='$username' and password='$password' limit 1");
if($result = mysql_fetch_array($check_query)){
   //登录成功
   $_SESSION['username'] = $username;
   $_SESSION['userid'] = $result['uid'];
   echo $username,' 欢迎你！进入 <a href="my.php">用户中心</a><br />';
   echo '点击此处 <a href="login.php?action=logout">注销</a> 登录！<br />';
   exit;
} else {
   exit('登录失败！点击此处 <a href="javascript:history.back(-1);">返回</a> 重试');
}
?>

my.php

<?php
session_start();

//检测是否登录，若没登录则转向登录界面
if(!isset($_SESSION['userid'])){
header("Location:login.html");
exit();
}

//包含数据库连接文件
include('conn.php');
$userid = $_SESSION['userid'];
$username = $_SESSION['username'];
$user_query = mysql_query("select * from user where uid=$userid limit 1");
$row = mysql_fetch_array($user_query);
echo '用户信息：<br />';
echo '用户ID：',$userid,'<br />';
echo '用户名：',$username,'<br />';
echo '邮箱：',$row['email'],'<br />';
date_default_timezone_set('Asia/Shanghai');
echo '注册日期：',date("Y-m-d H:i:s", $row['regdate']),'<br />';
echo '<a href="login.php?action=logout">注销</a> 登录<br />';

//每页显示的留言数
$pagesize = 2;

//确定页数 p 参数
$p = $_GET['p']?$_GET['p']:1;

//数据指针
$offset = ($p-1)*$pagesize;

//查询本页显示的数据
$query_sql = "SELECT * FROM user ORDER BY uid DESC LIMIT $offset , $pagesize";
//echo $query_sql;
$result = mysql_query($query_sql);
//循环输出
while($gblist = mysql_fetch_array($result)){
    echo '用户:'.$gblist['username'];
    echo '邮箱：',$gblist['email'],'<br />';
    echo '用户注册时间：',date("Y-m-d H:i", $gblist['regdate']),'<br /><hr />';
}

//分页代码
//计算用户总数
$count_result = mysql_query("SELECT count(*) as count FROM user");
$count_array = mysql_fetch_array($count_result);

//计算总的页数
$pagenum=ceil($count_array['count']/$pagesize);
echo '共 ',$count_array['count'],' 条记录';

//循环输出各页数目及连接
if ($pagenum > 1) {
    for($i=1;$i<=$pagenum;$i++) {
        if($i==$p) {
            echo ' [',$i,']';
        } else {
            echo ' <a href="my.php?p=',$i,'">',$i,'</a>';
        }
    }
}