登录---验证---分页

来源：互联网发布：必应输入法mac 编辑：程序博客网时间：2024/05/20 06:52

登录页面

<!DOCTYPE html><html><head>    <meta http-equiv="content-type" content="text/html;charset=utf-8"/></head><h1>管理员登录</h1><form action="loginProcess.php" method="post">    <table>        <tr>            <td>用户id</td>            <td><input type="text" name="id"/></td>        </tr>        <tr>            <td>密　&nbsp;码</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><?phpif (!empty($_GET['errno'])) {    if ($_GET['errno'] == 1) {        echo "<font color='red'>账号错误，请重新输入</font>";    }}?></html>

验证页面

<?php$id = $_POST['id'];$password = $_POST['password'];$mysqli = new mysqli("localhost", "root", "123456", "emp");if ($mysqli->connect_error) {    die ("LINK FAILED" . $mysqli->connect_error);}$mysqli->query("set names utf8");//变化验证逻辑；$query = "select password,name from admin where id='" . $id . "'";$res = $mysqli->query($query);if ($row = $res->fetch_assoc()) {    //防止SQL注入攻击；    if ($row['password'] == md5($password)) {        $name = $row['name'];        header("Location:empManage.php?name=$name");        exit();    }}header("Location:login.php?errno=1");exit();

管理界面

<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>管理界面</title></head><?phpecho "欢迎".$_GET['name']."登录成功";echo "<br><a href='login.php'>返回登录</a>";?><h1>主界面</h1><a href='empList.php'>管理用户</a></br><a href='?'>添加用户</a></br><a href='?'>查询用户</a></br><a href='?'>退出系统</a></br></html>

雇员列表页面

<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>雇员信息列表</title></head><?php$mysqli=new mysqli("localhost","root","123456","emp");if($mysqli->connect_error){    die ("LINK FAILED".$mysqli->connect_error);}$mysqli->query("set names utf8");$query1="select count(id) from emp";$res1=$mysqli->query($query1);if($row=$res1->fetch_row()){    //取出记录条数；    $rowCount=$row[0];}$res1->free();//指定每页显示的记录条数；$pageSize=3;//默认显示第一页；否则显示用户点击的页数；$pageNow=1;if(!empty($_GET['pageNow'])){    $pageNow=$_GET['pageNow'];}$pageCount=ceil($rowCount/$pageSize);//分页算法；$query2="select * from emp limit ".($pageNow-1)*$pageSize.",$pageSize";$res2=$mysqli->query($query2);echo "<table width='700px' border='1' bordercolor='yellow' cellspacing='0px'>";echo "<tr><th>id</th><th>name</th><th>grade</th><th>email</th><th>salary</th><th>删除用户</th><th>修改用户</th></tr>";while($row=$res2->fetch_assoc()){echo "<tr><td>{$row['id']}</td><td>{$row['name']}</td><td>{$row['grade']}</td><td>{$row['email']}</td><td>{$row['salary']}</td><td><a href='?'>删除用户</a></td><td><a href='?'>修改用户</a> </td></tr>";}echo "<h1>雇员信息列表</h1>";echo "</table>";for($i=1;$i<=$pageCount;$i++){    echo "<a href='empList.php?pageNow=$i'>$i</a>&nbsp;";}$res2->free();$mysqli->close();?><body></body></html>

0 0