开始界面截图:
密码正确获取数据库内容
数据库截图
登陆密码或者账号错误
登陆账号或密码为空
源代码
1.home.html登录界面
<html>
<head>
<title></title>
<style>
.shadow {
width:300px;
font-size:12px;
color:#FFFFFF;
text-align:center;
padding:10px 0 10px;
background:#6BCBF6;
}
.main{
text-align: center;
background-color: #fff;
border-radius: 20px;
width: 300px;
height: 30px;
top: 0;
left: 0;
right: 0;
bottom: 0;
}
</style>
</head>
<body background="E:\background\1.jpg">
<center><h1>WELCOME</h1></center>
<form action="login.php" method="post">
<center><input placeholder="UUSER ID"type="text" name="name" class="main"/></center></br></br>
<center><input placeholder="PASSWORD"type="password" name="password" class="main"/></center></br>
<center><div><input type="submit" value="LOGIN"class="shadow" /></div></center>
<CENTER><h3>DESIGN BY SUN</h3><h6>Version:8.1.2</h6></center>
</form>
</body>
</html>
2.连接数据库源码login.php
<?php
header("Content-Type:text/html;charset=utf-8");
session_start();
//获取name和password
$name = $_POST["name"];
$password = $_POST["password"];
//数据库连接
define("HOST","localhost");
define("USER","root");
define("PASS","root");
define("DBNAME","user");
$link=@mysql_connect(HOST,USER,PASS)or die("数据库连接失败");
mysql_select_db(DBNAME,$link);
mysql_query("SET NAMES 'utf-8'");
$sql='select * from user ';
$result =mysql_query($sql,$link);
$row=mysql_fetch_assoc($result);
//判断是否为空
if($name != null && $password != null){
//比对与数据库中的值
if($name==$row['name']&& md5($password.$row['salt'])==$row['password']){
$_SESSION["name"]=$name;//write session
$_SESSION["uid"]=$row['uid'];
$_SESSION["time"]= $row['last_login_time'];
$_SESSION["ip"]= $row['last_login_ip'];
header("Location:success.php");//跳转成功
}else{
header("Location:error.php");//跳转失败
}
}
else{
header("Location:error0.php");//跳转失败
}
mysql_close($link);
?>
3.成功session获取界面success.php
<?php
header("Content-Type:text/html;charset=utf-8");
session_start();
//找session
if(empty($_SESSION["uid"]))
{
header("Location:login.php");
}
$time1= date("Y-m-d H:i:s",$_SESSION["time"]);//将时间戳转换为时间
echo "登陆成功<br/>用户姓名:";
echo $_SESSION["name"];//从session中获取值
echo "<br/>";
echo "用户ID:";
echo $_SESSION["uid"];
echo "<br/>时间:";
echo $time1;
echo "<br/>IP:";
echo $_SESSION["ip"];
?>
4.密码错误或者账号错误error.php
<?php
header("Content-Type:text/html;charset=utf-8");
echo "登陆失败<br/>用户名或密码错误";
?>
5.账号或密码为空error0.php
<?php
header("Content-Type:text/html;charset=utf-8");
echo "登陆失败<br/>用户名或密码不能为空";
?>
7.在apache服务下127.0.0.1/home.html即可或者phpstudy