简体中文（ZH-CN）English（EN）繁体中文（ZH-TW）日本語（JA）한국어（KO）Melayu（MS）Français（FR）Deutsch（DE）
Home
Article
Q&A
Course
Topic
Download
Game
Dictionary
Recent Updates

博客列表 >运用会话控制、PDO预处理实现记住用户和分页功能

运用会话控制、PDO预处理实现记住用户和分页功能

lilove的博客
lilove的博客原创
2020年08月26日 00:11:41836浏览

实例整体结构

  • check.php：登陆检查

  • control.php：控制台页（含分页功能）

  • db.php：数据库连接

  • index.php：主页

  • login.php：登录页

  • personal.php：个人中心页

  • rcheck.php：注册检查

  • register.php：注册页面

  • edit.php：编辑页面

  • handle.php：功能分配

代码

  • check.php：登陆检查
  1. <?php
  2. // 处理登录提交
  3. $username = $_POST['username'];
  4. $password = sha1($_POST['password']);
  5. $remember = $_POST['rem'];
  7. // 连接数据库
  8. require 'db.php';
  10. // PDO查询数据库
  11. $select = "SELECT `id`,`user_name`,`password` FROM `user` WHERE `user_name`=:username AND `password`=:pwd";
  12. $data = $pdo->prepare($select);
  13. $data->bindParam(':username', $username);
  14. $data->bindParam(':pwd', $password);
  15. $data->execute();
  16. $res = $data->fetch(PDO::FETCH_ASSOC);
  18. // 根据查询结果验证登陆数据及是否记住密码
  19. if ($data->rowCount() == 1) {
  20.     // 清理已有的cookie
  21.     setcookie('username', '', time() - 3600);
  22.     setcookie('auth', '', time() - 3600);
  23.     // 如果选择了记住密码
  24.     if ($remember == 'on') {
  25.         setcookie('username', $username, strtotime('+7 days'));
  26.         // 加盐生成令牌
  27.         $salt = '小刚';
  28.         $auth = sha1($username . $password . $salt) . ',' . $res['id'];
  29.         setcookie('auth', $auth, strtotime('+7 days'));
  30.     } else {
  31.         setcookie('username', $username);
  32.         $salt = '小刚';
  33.         $auth = sha1($username . $password . $salt) . ',' . $res['id'];
  34.         setcookie('auth', $auth);
  35.     }
  36.     exit("<script>
  37.         alert('登陆成功');
  38.         location.href = 'index.php';
  39.     </script>");
  40. } else {
  41.     exit("<script>
  42.         alert('登陆失败');
  43.         location.href = 'login.php';
  44.     </script>");
  45. }
  • control.php：控制台页（含分页功能）
  1. <?php
  2. require "db.php";
  4. $select = "SELECT `id`,`user_name`,`password`,`user_type` FROM `user`";
  5. $data = $pdo->prepare($select);
  6. $data->execute();
  7. $res = $data->fetchAll();
  9. if ($data->rowCount() == 0) {
  10.     exit("<script>
  11.         alert('查询失败')
  12.     </script>");
  13. }
  15. // 分页
  16. // 1.每页显示数量
  17. $num = 1;
  19. // 2.当前页码，默认为1
  20. $page = $_GET['p'] ?? 1;
  22. // 3.计算每页第一条记录偏移量
  23. $offset = ($page - 1) * $num;
  25. // 4.获取分页数据
  26. $pagedata = "SELECT * FROM `user` LIMIT {$num} OFFSET {$offset}";
  27. // 语句简写
  28. // $pagedata = "SELECT * FROM `user` LIMIT {$offset}, {$num}";
  29. $users = $pdo->query($pagedata)->fetchAll();
  31. // 5.计算总页数
  32. // 计算表中共计有多少条记录，每页显示几条
  33. // 总页数=ceil(记录总数/每页的记录数)：ceil()向上取整函数
  34. $sql = "SELECT CEIL(COUNT(`id`)/{$num}) AS `total` FROM `user`";
  35. $pages = $pdo->query($sql)->fetch()['total'];
  37. ?>
  39. <!DOCTYPE html>
  40. <html lang="zh-cn">
  41. <head>
  42.     <meta charset="UTF-8">
  43.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  44.     <link rel="stylesheet" href="layui/css/layui.css" media="all" />
  45.     <title>控制台</title>
  46. </head>
  47. <style>
  48.     body {
  49.         min-width: 1000px;
  50.     }
  52.     .tab {
  53.         width: 900px;
  54.         margin: 0 auto;
  55.     }
  56.     .container {
  57.         width: 500px;
  58.         margin: 0 auto;
  59.     }
  60.     .pag {
  61.         font-size: 0;
  62.         margin: 10px auto;
  63.     }
  65.     .pag > li {
  66.         display: inline-block;
  67.         min-width: 30px;
  68.         height: 20px;
  69.         font-size: 16px;
  70.     }
  72.     .pag > li > a {
  73.         display: block;
  74.         line-height: 20px;
  75.         text-align: center;
  76.         padding: 5px;
  77.         border: 1px solid gray;
  78.     }
  79.     .pag > li > a:hover {
  80.         color: white;
  81.         background-color: teal;
  82.     }
  83.     .active {
  84.         color: white;
  85.         background-color: teal;
  86.     }
  87. </style>
  88. <body>
  89.     <table class="layui-table tab">
  90.         <colgroup>
  91.             <col width="150">
  92.             <col width="200">
  93.             <col>
  94.         </colgroup>
  95.         <thead>
  96.             <tr>
  97.                 <th>ID</th>
  98.                 <th>用户名</th>
  99.                 <th>密码</th>
  100.                 <th>用户类型</th>
  101.                 <th>操作</th>
  102.             </tr> 
  103.         </thead>
  104.         <tbody>
  105.             <?foreach ($users as $user):?>
  106.             <tr>
  107.                 <td><?echo $user["id"]?></td>
  108.                 <td><?echo $user["user_name"]?></td>
  109.                 <td><?echo $user["password"]?></td>
  110.                 <td><?echo $user["user_type"] == 1 ? "管理员" : "非管理员"?></td>
  111.                 <td>
  112.                     <button class="layui-btn layui-btn-xs" onclick="location.href='handle.php?action=edit&userid=<?=$user['id']?>'">编辑</button>
  113.                     <button class="layui-btn layui-btn-xs layui-btn-warm" onclick="location.href='handle.php?action=del&userid=<?=$user['id']?>'">删除</button>
  114.                 </td>
  115.             </tr>
  116.             <?endforeach?>
  117.         </tbody>
  118.     </table>
  119.     <div class="container">
  120.         <ul class="pag">
  121.             <li><a href="<?=$_SERVER['PHP_SELF']. '?p=1'?>">首页</a></li>
  123.             <?php
  124.             // 上一页
  125.             $prev = ($page-1) == 0 ? 1 : ($page-1);
  126.             // 下一页
  127.             $next = ($page+1) > $pages ? $pages : ($page+1);
  128.             ?>
  130.             <li><a href="<?=$_SERVER['PHP_SELF']. '?p='. $prev?>">上一页</a></li>
  132.             <?php for ($i=1; $i<=$pages; $i++): ?>
  133.                 <?php
  134.                 // $i是分页条中的页码，$page是url中get获取到的页码
  135.                 $active = ($i == $page) ? 'active' : null;
  136.                 // $_SERVER['PHP_SELF']是全局变量中的url地址，做字符串拼接get请求参数
  137.                 // $jump = $_SERVER['PHP_SELF']. '?p='. $i;
  138.                 // 可以用sprintf()拼接url字符串
  139.                 $jump = sprintf("%s?p=%s", $_SERVER['PHP_SELF'], $i);
  140.                 ?>
  141.                 <li><a href="<?=$jump?>" class="<?=$active?>"><?=$i?></a></li>
  142.             <?php endfor ?>
  145.             <li><a href="<?=$_SERVER['PHP_SELF']. '?p='. $next?>">下一页</a></li>
  146.             <li><a href="<?=$_SERVER['PHP_SELF']. '?p='. $pages?>">尾页</a></li>
  147.         </ul>
  148.     </div>
  150. <script src="layui/layui.js" charset="utf-8"></script>
  151. </body>
  152. </html>
  • db.php：数据库连接
  1. <?php
  2. // 配置mysql数据库连接参数
  3. define('DB_HOST', 'localhost');
  4. define('DB_PORT', 3306);
  5. define('DB_NAME', 'phptest');
  6. define('DB_USER', 'root');
  7. define('DB_PWD', '123456');
  8. define('DB_TYPE', 'mysql');
  9. define('DB_CHARSET', 'utf8');
  10. // 配置PDO连接数据库参数,DSN:datasoursename
  11. define('DB_DSN', DB_TYPE . ':host=' . DB_HOST . ';dbname=' . DB_NAME . ';charset=' . DB_CHARSET);
  13. // 捕获错误,比较消耗资源
  14. try {
  15.     $pdo = new PDO(DB_DSN, DB_USER, DB_PWD);
  16.     // 抛出一个 PDOException 异常
  17. } catch (PDOException $e) {
  18.     echo $e->getMessage();
  19.     // 捕获拥有Throwable接口的错误或者其他异常
  20. } catch (Throwable $e) {
  21.     echo $e->getMessage();
  22. }
  24. // 可设置默认以索引数组方式获取结果集
  25. $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
  • index.php：主页
  1. <?php
  2. // 连接数据库
  3. require 'db.php';
  5. $token = $_COOKIE['auth'];
  6. $auth_true = explode(',', $token)[0];
  7. $id = end(explode(',', $token));
  8. $select = "SELECT `id`,`user_name`,`password` FROM `user` WHERE `id`=:id";
  9. $data = $pdo->prepare($select);
  10. $data->bindParam(':id', $id);
  11. $data->execute();
  12. $res = $data->fetch();
  13. if ($data->rowCount() === 1) {
  14.     $username = $res['user_name'];
  15.     $password = $res['password'];
  16.     $salt = '小刚';
  17.     $auth = sha1($username . $password . $salt);
  18.     if ($auth_true !== $auth) {
  19.         exit("<script>
  20.             alert('未登录');
  21.             location.href='login.php';
  22.         </script>");
  23.     }
  24. } else {
  25.     exit("<script>
  26.         alert('请先登录');
  27.         location.href='login.php';
  28.     </script>");
  29. }
  30. ?>
  32. <!DOCTYPE html>
  33. <html lang="zh-cn">
  35. <head>
  36.     <meta charset="UTF-8" />
  37.     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  38.     <link rel="stylesheet" href="layui/css/layui.css" media="all" />
  39.     <title>主页</title>
  40. </head>
  41. <style>
  42.     body {
  43.         margin: 0 30px;
  44.     }
  45. </style>
  47. <body>
  48.     <ul class="layui-nav">
  49.         <li class="layui-nav-item">
  50.             <a href="control.php" target="_blank">控制台<span class="layui-badge">9</span></a>
  51.         </li>
  52.         <li class="layui-nav-item">
  53.             <a href=<?php echo "personal.php"."?username={$username}" ?> target="_blank">个人中心<span class="layui-badge-dot"></span></a>
  54.         </li>
  55.         <li class="layui-nav-item layui-layout-right" lay-unselect="">
  56.             <a href="javascript:;"><img src="face.jpg" class="layui-nav-img">
  57.                 <?php echo $_COOKIE['username']; ?>
  58.             </a>
  59.             <dl class="layui-nav-child">
  60.                 <dd><a href="javascript:;">修改信息</a></dd>
  61.                 <dd><a href="javascript:;">修改密码</a></dd>
  62.                 <dd><a href="login.php?action=logout">退出</a></dd>
  63.             </dl>
  64.         </li>
  65.     </ul>
  66. </body>
  67. <script src="layui/layui.js" charset="utf-8"></script>
  68. <script>
  69.     layui.use('element', function() {
  70.         //导航的hover效果、二级菜单等功能，需要依赖element模块
  71.         var element = layui.element;
  72.     });
  73. </script>
  75. </html>
  • login.php：登录页
  1. <?php
  2. // 退出清cookie
  3. if ($_GET['action'] == 'logout') {
  4.     setcookie('username', '', time() - 3600);
  5.     setcookie('auth', '', time() - 3600);
  6.     exit("<script>
  7.         location.href='login.php';
  8.     </script>");
  9. }
  11. // 连接数据库
  12. require 'db.php';
  14. $token = $_COOKIE['auth'];
  15. $auth_true = explode(',', $token)[0];
  16. $id = end(explode(',', $token));
  17. $select = "SELECT `id`,`user_name`,`password` FROM `user` WHERE `id`=:id";
  18. $data = $pdo->prepare($select);
  19. $data->bindParam(':id', $id);
  20. $data->execute();
  21. $res = $data->fetch();
  22. if ($data->rowCount() == 1) {
  23.     $username = $res['user_name'];
  24.     $password = $res['password'];
  25.     $salt = '小刚';
  26.     $auth = sha1($username . $password . $salt);
  27.     if ($auth_true == $auth) {
  28.         exit("<script>
  29.             alert('已登陆');
  30.             location.href='index.php';
  31.         </script>");
  32.     }
  33. }
  34. ?>
  36. <!DOCTYPE html>
  37. <html lang="zh-cn">
  39. <head>
  40.     <meta charset="UTF-8" />
  41.     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  42.     <link rel="stylesheet" href="layui/css/layui.css" />
  43.     <title>登录页</title>
  44. </head>
  45. <style>
  46.     .container {
  47.         width: 400px;
  48.         min-height: 400px;
  49.         margin: 100px auto;
  50.     }
  51. </style>
  53. <body>
  54.     <form class="layui-form container" action="check.php" method="POST">
  55.         <div class="layui-form-item">
  56.             <label class="layui-form-label">用户名</label>
  57.             <div class="layui-input-block">
  58.                 <input type="text" name="username" lay-verify="required" lay-reqtext="用户名是必填项" placeholder="请输入用户名" autocomplete="off" class="layui-input" />
  59.             </div>
  60.         </div>
  62.         <div class="layui-form-item">
  63.             <label class="layui-form-label">密码</label>
  64.             <div class="layui-input-block">
  65.                 <input type="password" name="password" lay-verify="required" lay-reqtext="密码是必填项" placeholder="请输入密码" autocomplete="off" class="layui-input" />
  66.             </div>
  67.         </div>
  69.         <div class="layui-form-item">
  70.             <label class="layui-form-label">记住密码</label>
  71.             <div class="layui-input-block">
  72.                 <input type="checkbox" name="rem" lay-skin="switch" lay-filter="switchTest" lay-text="开启|关闭" />
  73.             </div>
  74.         </div>
  76.         <div class="layui-form-item">
  77.             <div class="layui-input-block">
  78.                 <button type="submit" class="layui-btn" lay-submit="" lay-filter="login">
  79.                     登陆
  80.                 </button>
  81.                 <a href="register.php" class="layui-btn layui-btn-normal" target="_blank">注册</a>
  82.             </div>
  83.         </div>
  84.     </form>
  85. </body>
  86. <script src="layui/layui.js" charset="utf-8"></script>
  87. <script>
  88.     layui.use(["form"], function() {
  89.         var form = layui.form,
  90.             layer = layui.layer;
  91.     });
  92. </script>
  94. </html>
  • personal.php：个人中心页
  1. <?php
  2. require "db.php";
  4. $username = $_GET['username'];
  6. $select = "SELECT `id`,`user_name`,`password`,`user_type` FROM `user` WHERE `user_name`=:username";
  7. $data = $pdo->prepare($select);
  8. $data->bindParam(':username', $username);
  9. $data->execute();
  10. $res = $data->fetch();
  11. if ($data->rowCount() !== 1) {
  12.     exit("<javascript>
  13.         alert('用户不存在')
  14.     </javascript>");
  15. }
  17. ?>
  19. <!DOCTYPE html>
  20. <html lang="zh-cn">
  22. <head>
  23.     <meta charset="UTF-8" />
  24.     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  25.     <link rel="stylesheet" href="layui/css/layui.css" />
  26.     <title>个人中心</title>
  27. </head>
  28. <style>
  29.     .container {
  30.         width: 400px;
  31.         min-height: 400px;
  32.         margin: 100px auto;
  33.     }
  34. </style>
  36. <body>
  37.     <form class="layui-form container" action="javascript:void(0)" method="POST">
  38.         <div class="layui-form-item">
  39.             <label class="layui-form-label">ID</label>
  40.             <div class="layui-input-block">
  41.                 <input type="text" name="userid" autocomplete="off" class="layui-input" value=<?echo $res["id"]?> disabled />
  42.             </div>
  43.         </div>
  45.         <div class="layui-form-item">
  46.             <label class="layui-form-label">用户名</label>
  47.             <div class="layui-input-block">
  48.                 <input type="text" name="username" autocomplete="off" class="layui-input" value=<?echo $res["user_name"]?> disabled />
  49.             </div>
  50.         </div>
  51.         <div class="layui-form-item">
  52.             <label class="layui-form-label">密码</label>
  53.             <div class="layui-input-block">
  54.                 <input type="password" name="password" autocomplete="off" class="layui-input" value=<?echo $res["password"]?> disabled />
  55.             </div>
  56.         </div>
  57.         <div class="layui-form-item">
  58.             <label class="layui-form-label">用户类型</label>
  59.             <div class="layui-input-block">
  60.                 <input type="text" name="usertype" autocomplete="off" class="layui-input" value=<?echo $res["user_type"] == 1 ? "管理员" : "非管理员"?> disabled />
  61.             </div>
  62.         </div>
  64.         <div class="layui-form-item">
  65.             <div class="layui-input-block">
  66.                 <button type="submit" class="layui-btn" lay-submit="" lay-filter="login" onclick="window.close()">
  67.                     关闭
  68.                 </button>
  69.             </div>
  70.         </div>
  71.     </form>
  72. </body>
  73. <script src="layui/layui.js" charset="utf-8"></script>
  74. <script>
  75.     layui.use(["form"], function() {
  76.         var form = layui.form,
  77.             layer = layui.layer;
  78.     });
  79. </script>
  81. </html>
  • rcheck.php：注册检查
  1. <?php
  2. // 处理注册提交
  3. $username = $_POST['username'];
  4. $password = sha1($_POST['password']);
  6. // 连接数据库
  7. require 'db.php';
  9. // PDO查询数据库
  10. $select = "SELECT `id`,`user_name` FROM `user` WHERE `user_name`=:username";
  11. $data = $pdo->prepare($select);
  12. $data->bindParam(':username', $username);
  13. $data->execute();
  14. $res = $data->fetch();
  16. // 根据查询结果验证注册数据
  17. if ($data->rowCount() == 1) {
  18.     // 如果已经存在用户
  19.     exit("<script>
  20.         alert('用户已存在');
  21.         location.href = 'register.php';
  22.     </script>");
  23. }
  25. $insert = "INSERT INTO user(`user_name`,`password`) VALUES(:username,:pwd)";
  26. $data = $pdo->prepare($insert);
  27. $data->bindParam(':username', $username);
  28. $data->bindParam(':pwd', $password);
  29. $data->execute();
  30. $res = $data->fetch();
  31. if ($data->rowCount() == 1) {
  32.     // 如果插入数据成功
  33.     exit("<script>
  34.         alert('注册成功');
  35.         location.href = 'login.php';
  36.     </script>");
  37. }else {
  38.     exit("<script>
  39.         alert('注册失败');
  40.         location.href = 'register.php';
  41.     </script>");
  42. }
  • register.php：注册页面
  1. <!DOCTYPE html>
  2. <html lang="zh-cn">
  4. <head>
  5.     <meta charset="UTF-8" />
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  7.     <link rel="stylesheet" href="layui/css/layui.css" />
  8.     <title>注册页</title>
  9. </head>
  10. <style>
  11.     .container {
  12.         width: 400px;
  13.         min-height: 400px;
  14.         margin: 100px auto;
  15.     }
  16. </style>
  18. <body>
  19.     <form class="layui-form container" action="rcheck.php" method="POST">
  20.         <div class="layui-form-item">
  21.             <label class="layui-form-label">用户名</label>
  22.             <div class="layui-input-block">
  23.                 <input type="text" name="username" lay-verify="required" lay-reqtext="用户名是必填项" placeholder="请输入用户名" autocomplete="off" class="layui-input" />
  24.             </div>
  25.         </div>
  27.         <div class="layui-form-item">
  28.             <label class="layui-form-label">密码</label>
  29.             <div class="layui-input-block">
  30.                 <input type="password" name="password" lay-verify="required" lay-reqtext="密码是必填项" placeholder="请输入密码" autocomplete="off" class="layui-input" />
  31.             </div>
  32.         </div>
  34.         <div class="layui-form-item">
  35.             <div class="layui-input-block">
  36.                 <button type="submit" class="layui-btn" lay-submit="" lay-filter="login">
  37.                     提交
  38.                 </button>
  39.             </div>
  40.         </div>
  41.     </form>
  42. </body>
  43. <script src="layui/layui.js" charset="utf-8"></script>
  44. <script>
  45.     layui.use(["form"], function() {
  46.         var form = layui.form,
  47.             layer = layui.layer;
  48.     });
  49. </script>
  51. </html>
  • edit.php：编辑页面
  1. <?php
  2. $edit = $pdo->query("SELECT * FROM `user` WHERE `id`={$userid}")->fetch();
  4. ?>
  6. <!DOCTYPE html>
  7. <html lang="zh-cn">
  8. <head>
  9.     <meta charset="UTF-8">
  10.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  11.     <link rel="stylesheet" href="layui/css/layui.css" media="all" />
  12.     <title>编辑表单</title>
  13. </head>
  14. <style>
  15.     .container {
  16.         width: 400px;
  17.         min-height: 200px;
  18.         margin: 100px auto;
  19.     }
  20. </style>
  21. <body>
  22.     <fieldset class="layui-elem-field container">
  23.         <legend>编辑用户</legend>
  24.         <div class="layui-field-box">
  25.             <form class="layui-form" action="<?php echo $_SERVER['PHP_SELF']. '?action=doedit&userid='. $edit['id']; ?>" method="POST">
  26.                 <div class="layui-form-item">
  27.                     <label class="layui-form-label">用户名</label>
  28.                     <div class="layui-input-block">
  29.                         <input type="text" name="username" required  lay-verify="required" autocomplete="off" class="layui-input" value="<?=$edit['user_name']?>">
  30.                     </div>
  31.                 </div>
  32.                 <div class="layui-form-item">
  33.                     <label class="layui-form-label">密码</label>
  34.                     <div class="layui-input-block">
  35.                         <input type="password" name="password" required lay-verify="required" autocomplete="off" class="layui-input" placeholder="请输入新密码">
  36.                     </div>
  37.                 </div>
  38.                 <div class="layui-form-item">
  39.                     <div class="layui-input-block">
  40.                         <button type="submit" class="layui-btn" lay-submit="" lay-filter="formDemo">保存</button>
  41.                         <button type="reset" class="layui-btn layui-btn-primary">重置</button>
  42.                     </div>
  43.                 </div>
  44.             </form>
  45.         </div>
  46.     </fieldset>
  48. </body>
  49. <script src="layui/layui.js" charset="utf-8"></script>
  50. <script>
  51.     layui.use('form', function(){
  52.         var form = layui.form;
  53.           //监听提交
  54. //   form.on('submit(formDemo)', function(data){
  55. //     layer.msg(JSON.stringify(data.field));
  56. //     return false;
  57. //   });
  58.     });
  59. </script>
  60. </html>
  • handle.php：功能分配
  1. <?php
  2. require "db.php";
  4. $action = $_GET['action'];
  5. $userid = $_GET['userid'];
  7. switch ($action) {
  8.     case 'edit':
  9.         // 加载、渲染数据编辑表单
  10.         include 'edit.php';
  11.     break;
  13.     case 'doedit':
  14.         $doedit = "UPDATE `user` SET `user_name`=?, `password`=? WHERE `id`=?";
  15.         $stmt = $pdo->prepare($doedit);
  16.         if (!empty($_POST)) {
  17.             $pwd = sha1($_POST['password']);
  18.             $stmt->execute([$_POST['username'], $pwd, $userid]);
  19.             echo $stmt->rowCount() == 1 ? "<script>alert('修改成功！');location.href='control.php';</script>" : "<script>alert('修改失败！');location.href='control.php';</script>";
  20.         }
  21.     break;
  23.     case 'del':
  24.         $del = "DELETE FROM `user` WHERE `id`=?";
  25.         $data = $pdo->prepare($del);
  26.         $data->execute([$userid]);
  27.         if ($data->rowCount() == 1) {
  28.             exit("<script>alert('删除成功');location.href='control.php';</script>");
  29.         } else {
  30.             exit("<script>alert('删除失败');location.href='control.php';</script>");
  31.         }
  33.     break;
  34. }

功能演示

  • 记住密码登陆：

  • 退出登录再直接进入主页提示先登陆：

  • 注册后登陆：

  • 渲染数据：

  • 简单分页：
    • 上一页、下一页；
    • 首页、尾页；

  • 编辑：

  • 删除：

总结

  • 将PDO预处理操作数据库和会话控制整合到实际案例中做了个大作业，还加入了分页功能，希望老师别打我呀:)

  • 提前预习了下前端框架layui的使用，感觉很强大，但有一定局限性。

上一条：表单小程序如何制作？下一条：html-css-01-鹅岭css
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多