用户注册与登录完整代码
login.html
"/TR/xhtml1/DTD/xhtml1-transitional.dtd">
conn.php
/*****************************
*数据库连接
*****************************/
$conn = @mysql_connect("localhost","root","root123");
if (!$conn){
die("连接数据库失败：" . mysql_error());
}
mysql_select_db("test", $conn);
//字符转换，读库
mysql_query("set character set 'gbk'");
//写库
mysql_query("set names 'gbk'");
?>
reg.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('错误：用户名不符合规定。返回');
}
if(strlen($password) < 6){
exit('错误：密码长度不符合规定。返回');
}
if(!preg_match('/^w+([-+.]w+)*@w+([-.]w+)*.w+([-.]w+)*$/', $email)){
exit('错误：电子邮箱格式错误。返回');
}
//包含数据库连接文件
include('conn.php');
//检测用户名是否已经存在
$check_query = mysql_query("select uid from user where username='$username' limit 1");
if(mysql_fetch_array($check_query)){
echo '错误：用户名 ',$username,' 已存在。返回';
exit;
}
//写入数据
$password = MD5($password);
$regdate = time();
$sql = "INSERT INTO us
er(username,password,email,regdate)VALUES('$username','$password','$email',
$regdate)";
if(mysql_query($sql,$conn)){
exit('用户注册成功！点击此处 登录');
} else {
echo '抱歉！添加数据失败：',mysql_error(),'
';
echo '点击此处 返回 重试';
}
?>
login.html
"/TR/xhtml1/DTD/xhtml1-transitional.dtd">
login.php
session_start();
//注销登录
if($_GET['action'] == "logout"){
unset($_SESSION['userid']);
unset($_SESSION['username']);
echo '注销登录成功！点击此处 登录';
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,' 欢迎你！进入 用户中心
';
echo '点击此处 注销 登录！
';
exit;
} else {
exit('登录失败！点击此处 返回 重试');
}
?>
my.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 '用户信息：
';
echo '用户ID：',$userid,'
';
echo '用户名：',$username,'
';
echo '邮箱：',$row['email'],'
';
echo '注册日期：',date("Y-m-d", $row['regdate']),'
';
echo '注销 登录
';
?>