login.php
<html>
<head>
<meta content="text/html;charset=utf-8" http-equiv="content-type">
</head>
<h1>管理员登录系统</h1>
<form action="loginProcess.php" method="post">
<table>
<tr>
<td>用户id</td>
<td><input type="text" name="id" /></td>
</tr>
<tr>
<td>密 码</td>
<td><input type="password" name="password" /></td>
</tr>
<tr>
<td><input type="submit" value="用户登录" /></td>
<td><input type="reset" value="重新填写" /></td>
</tr>
</table>
</form>
<?php
if(!empty($_GET['errno'])){
$errno=$_GET['errno'];
if($errno==1){
echo "<font color='red' size='3'>你的用户名或密码错误</font>";
}
}
?>
</html>
loginProcess.php
<?php
//接受用户的数据
//1.id
$id = $_POST ['id'];
//2.密码
$password = $_POST ['password'];
//得到连接
$conn = mysql_connect ( "localhost", "root", "root" );
if (! $conn) {
die ( "连接失败" . mysql_errno () );
}
//设置访问数据库的编码
mysql_query ( "set names utf8", $conn ) or die ( mysql_errno () );
//选择数据库
mysql_select_db ( "test", $conn ) or die ( mysql_errno () );
//发送sql语句验证
$sql = "select password from admin where id=$id";
//通过id获取password
$res = mysql_query ( $sql, $conn );
if ($row = mysql_fetch_assoc ( $res )) {
//取出数据库的密码
if ($row ['password'] == md5 ( $password )) {
header ( "Location:empManage.php" );
exit ();
}
}
header ( "Location:login.php?errno=1" );
exit ();
//关闭资源
mysql_free_result($res);
mysql_close($conn);
?>
empManage.php
<html> <head> <meta http-equiv="content-type" content="text/html;charset=utf-8"> </head> <?php echo "登录成功！..."; echo "<br/><a href='login.php'>返回重新登录</a>"; ?> <h1>主界面</h1> <a href="#">管理用户</a> <br /> <a href="#">添加用户</a> <br /> <a href="#">查询用户</a> <br /> <a href="#">退出系统</a> <br /> </html>
