php实现登录注册的时候,数据库部分不会弄,请大神帮忙解决问题,谢谢!
已经创建了test表。
下面我贴上代码:
第一部分:(login.html)
用户登录button,input{padding:0px;}
html{font-size:12px;}
fieldset{width:300px; margin: 0 auto;}
legend{font-weight:bold; font-size:14px;}
.label{float:left; width:70px; margin-left:10px;}
.left{margin-left:80px; width: 65px;}
.input{width:150px;}
span{color: #666666;}
.right a{
text-decoration: none;
color:#000;
display: block;
width:100%;
height: 100%;
position: relative;
z-index: 999;
}
.right{
width: 65px;
margin-left:20px;
}
第二部分:(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('登录失败!点击此处 返回 重试');
}
?>
第三部分:(reg.html):
用户注册button,input{padding:0px;}
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; width:90px;}
.input{width:150px;}
span{color: #666666;}
.right a{
text-decoration: none;
color:#000;
display: block;
width:100%;
height: 100%;
position: relative;
z-index:999;
}
.right{
width:90px;
margin-left:20px;
}
第四部分:(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 user(username,password,email,regdate)VALUES('$username','$password','$email',$regdate)";
if(mysql_query($sql,$conn)){
exit('用户注册成功!点击此处 登录');
} else {
echo '抱歉!添加数据失败:',mysql_error(),'
';
echo '点击此处 返回 重试';
}
?>
第五部分:(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 '注销 登录
';
?>
最关键的一部分 :(conn.php):
/*****************************
*数据库连接
*****************************/
$conn = @mysql_connect("112.74.164.248","root","root");
if (!$conn){
die("连接数据库失败:" . mysql_error());
}
mysql_select_db("test", $conn);
//字符转换,读库
mysql_query("set character set 'gbk'");
//写库
mysql_query("set names 'gbk'");
?>