基于php和html的简易个人中心web前后段界面,部署apache2,lamp
dbconnect.php
<?php
$server = "xxx.xxx.xxx.xxx";
$db_username = "xxx";
$db_passwd = "xxx";
$dbname = "xxx";
//连接数据库
$db_link = mysqli_connect($server,$db_username,$db_passwd,$dbname);
//连接失败
if(!$db_link){
die("Can't connect to MySQL Server.Errorcode:" . mysqli_connect_error());
}
//设置数据库编码
mysqli_query($db_link,"SET NAMES 'utf8'");
?>
index.php
<?php
header('Content-type:text/html; charset=utf-8');
//开启session
session_start();
//先判断cookie是否有用户信息
if(isset($_COOKIE['username'])){
$_SESSION['username'] = $_COOKIE['username'];
$_SESSION['islogin'] = 1;
#print_r($_SESSION);
}
if(isset($_SESSION['islogin'])){
//如果已经登陆
echo "你好".$_SESSION['username']." ,欢迎来到个人中心!<br>";
echo "<a href='logout.php'>退出登陆<br></a>";
echo "<a href='psw_change.php'>修改密码<br></a>";
echo "<a href='search.php'>查询个人信息<br></a>";
echo "<a href='remove.php'>注销<br></a>";
}else{
//如果没有登录
echo "你还没有登录,请<a href = 'login.html'>登录</a>";
}
?>
login.html
<html>
<!--https://www.jb51.net/article/172542.htm-->
<head>
<title>后台登录</title>
<!--解决html中文在浏览器中显示乱码-->
<meta http-equiv="Content-Type"content="text/html;charset=utf-8">
</head>
<body>
<h1>请输入你的账号密码进行登录</h1>
<form action="login.php" method="post">
<fieldset>
<legend><h2>用户登录</h2></legend>
<ul>
<li>
<label>用户名:</label>
<input type="text" name="username">
</li>
<li>
<label>密码:</label>
<input type="password" name="passwd">
</li>
<li>
<label> </label>
<input type="checkbox" name="remember" value="yes"> 七天内自动登录
</li>
<li>
<label> </label>
<input type="submit" name="login" value="登录"> <input type="reset" name="reset" value="重置"> </td> </tr>
</li>
<li>
<label> <label>
<td colspan="2" align="center"> 还没有账号,快去<a href="register.php" rel="external nofollow" >注册</a>吧</td> </li>
</ul>
</fieldset>
</form>
</body>
</html>
login.php
<?php
require("dbconnect.php");
header('Content-Type:text/html;charset=utf-8');
//开启session()
session_start();
//处理用户登录信息
if(isset($_POST['login'])){
//接收用户的登录信息
$username=$_POST['username'];
$passwd = $_POST['passwd'];
//判断提交的登录信息
if(($username == '') || ($passwd == '')){
//若为空则视为未填写返回login.html页面
header('refresh:3;url=login.html');
echo "用户名或密码不能为空,3秒后将返回登录页面,请重新输入!";
exit;
}else{
//若不为空则判断和账号密码是否存在于数据库中
$sql = "select Name,Password from user where Name = '$username'"; //构造查询账号密码语句
$result = mysqli_query($db_link,$sql); //查询字符串
$row = mysqli_fetch_assoc($result); //从结果中取一行为关联数组
if(($username != $row['Name']) || ($passwd != $row['Password'])){
//账号密码错误的情况下 同样和空处理一样
header('refresh:3;url=login.html');
echo "用户名或密码错误,3S后将放回登录页面,请重新输入!";
exit;
}elseif($passwd==$row['Password']){
#用户名和密码都正确,将用户名和密码信息存到Session中
$_SESSION['username'] = $username;
$_SESSION['islogin'] = 1;
echo "登录成功!三秒后跳转到后台管理页面";
if($_POST['remember'] == "yes"){
#如果勾选七天内自动登录 将其保存到cookie中 并设置保存7天
setcookie('username',$username,time()+7*24*60*60);
setcookie('code',md5($username.md5($passwd)),time()+7*24*60*60);
#print_r($_COOKIE);
}else{
#没有勾选删除cookie
setcookie('username','',time()-999999);
setcookie('code','',time()-999999);
}
header('refresh:3;url=index.php');
}
}
}
?>
logout.php
<?php
header('Contet-type:text/html; charset=utf-8');
//注销后的操作
session_start();
//清楚session
$username = $_SESSION['username']; //用于后面的提示信息
$_SESSION = array();
session_destroy();
//清除cookie
setcookie('username','', time()-99);
setcookie('code','', time()-99);
//提示信息
echo "期待下次登录,".$username.'<br>';
echo "<a href='login.html'>重新登录</a>";
?>
psw_change.php
<html>
<head><title>修改密码</title>
<meta name="content-type"; charset="UTF-8">
</head>
<body>
<h1>修改密码</h1>
<form action="psw_change.php" method="post">
<table border="0">
<tr><td>用户名:</td>
<td><input type="text" id="id_name" name="username" required="required"></td>
</tr>
<tr><td>密码:</td>
<td><input type="passwd" id="passwd" name="passwd" required="required"></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" id="register" name="register" value="提交">
<input type="reset" id="rester" name="rester" value="重置">
</td>
</tr>
<tr>
<td colspan="2" align="center">
重新<a href="login.html" rel="external nofollow" rel="external nofollow"> 登录</a>吧!
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
require('dbconnect.php');
header('Content-type:text/html;charset=utf-8');
$username = $_POST['username'];
$passwd = $_POST['passwd'];
$sql = "select Name from user where Name = '$username'";
$result = mysqli_query($db_link,$sql);
$row = mysqli_fetch_assoc($result);
$sql_insert = "update user set Password='$passwd' where Name='$username'";
mysqli_query($db_link,$sql_insert);
header('refrsh:3;url=login.html');
echo "<script>alert('修改密码成功,请点击登录去重新登录!')</script>";
?>
register.php
<html>
<head><title>用户注册</title>
<meta name="content-type"; charset="UTF-8">
</head>
<body>
<h1>用户注册</h1>
<form action="register.php" method="post">
<table border="0">
<tr><td>用户名:</td>
<td><input type="text" id="id_name" name="username" required="required"></td>
</tr>
<tr><td>密码:</td>
<td><input type="password" id="passwd" name="passwd" required="required"></td>
</tr>
<tr>
<tr><td>性别:</td>
<td><input type="text" id="id_sex" name="sex" required="required"></td>
</tr>
<tr><td>邮箱:</td>
<td><input type="text" id="email" name="email" required="required"></td>
</tr>
<tr>
<tr><td>出生年份:</td>
<td><input type="text" id="id_year" name="year" required="required"></td>
</tr>
<tr><td>出生月份:</td>
<td><input type="text" id="id_month" name="month" required="required"></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" id="register" name="register" value="注册">
<input type="reset" id="rester" name="rester" value="重置">
</td>
</tr>
<tr>
<td colspan="2" align="center">
如果已有账号,快去<a href="login.html" rel="external nofollow" rel="external nofollow"> 登录</a>吧!
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
require('dbconnect.php');
header('Content-type:text/html;charset=utf-8');
$username = $_POST['username'];
$passwd = $_POST['passwd'];
$sex = $_POST['sex'];
$email = $_POST['email'];
$year = $_POST['year'];
$month = $_POST['month'];
$sql = "select Name from user where Name = '$username'";
$result = mysqli_query($db_link,$sql);
$row = mysqli_fetch_assoc($result);
//判断用户名是否存在
if($username == $row['Name']){
echo "<script>alert('用户名.$username.已经存在!请重新注册')</script>";
}else{
//用户名不存在 将注册的账号密码加入数据库
$sql_insert = "insert into user(Name,Password,Sex,Email,birth_month,birth_year) values('$username','$passwd','$sex','$email','$month','$year')";
mysqli_query($db_link,$sql_insert);
header('refrsh:3;url=login.html');
echo "<script>alert('$username.用户注册成功,请点击登录去登录!')</script>";
}
?>
remove.php
<?php
require('dbconnect.php');
header('Contet-type:text/html; charset=utf-8');
//注销后的操作
session_start();
//清楚session
$username = $_SESSION['username']; //用于后面的提示信息
$_SESSION = array();
session_destroy();
$sql_delete = "delete from user where Name='$username'";
mysqli_query($db_link,$sql_delete);
//清除cookie
setcookie('username','', time()-99);
setcookie('code','', time()-99);
//提示信息
echo "期待下次注册,".$username.'<br>';
echo "<a href='login.html'>重新登录</a>";
?>
search.php
<!DOCTYPE html>
<html>
<body>
<table style='text-align:left;' border='1'>
<tr><th>id</th><th>名字</th><th>性别</th><th>邮箱</th></tr>
<?php
require 'dbconnect.php';
session_start();
$username = $_SESSION['username']; //用于后面的提示信息
$_SESSION = array();
$sql = ("select ID,Name,Sex,Email from user where Name='$username'");
$result = mysqli_query($db_link,$sql); //查询字符串
$row = mysqli_fetch_assoc($result); //从结果中取一行为关联数组
$id = $row['ID'];
$name = $row['Name'];
$sex = $row['Sex'];
$email = $row['Email'];
echo "<tr><td>$id</td><td>$name</td><td>$sex</td><td>$email</td></tr>";
$_SESSION['username'] = $username;
$_SESSION['islogin'] = 1;
setcookie('username','', time()+7*24*60*60);
setcookie('code','', time()+7*24*60*60);
?>
<a href="index.php" rel="external nofollow" rel="external nofollow"> 返回</a>
</table>
</body>
</html>