search

博客列表 >结合课程知识完成用户列表的修改和删除功能

结合课程知识完成用户列表的修改和删除功能

zg的php学习
zg的php学习原创
2021年10月21日 18:23:48448浏览

结合课程知识完成用户列表的修改和删除功能

工具类： DB.php

  1. <?php
  3. class DB{
  4.     public static $config = array(); //数据库连接的配置信息
  5.     public static $pdo = null;    //PDO连接标识符
  6.     public static $stmt = null; //PDOStatement类。预处理sql语句及存放结果集
  7.     public static $sql = null; //最后执行的sql语句
  8.     public static $lastInsertId = null;//最后一次插入操作的自增值(AUTO_INCREMANT)
  9.     public static $error=null; //错误信息
  11.     /**
  12.      * 构造函数, 实例化时用来连接数据库
  13.      * @param array 数据库配置项
  14.      */
  15.     public function __construct($dbConfig=''){
  16.         //实例化时，如果未传参数或参数非数组格式则连接默认数据库
  17.         if(!is_array($dbConfig)){
  18.             $dbConfig = [
  19.                 'dbms'=>'mysql',
  20.                 'host'=>'10.10.1.242',
  21.                 'dbname'=>'php',
  22.                 'user'=>'root',
  23.                 'password'=>'130599',
  24.                 'charset'=>'utf8'
  25.             ];
  26.         }
  28.         //判断是否配置了host项(数据库)
  29.         if(empty($dbConfig['host'])){
  30.             self::throw_exception("没有配置数据库，请先配置!");
  31.         }
  33.         self::$config = $dbConfig;
  35.         if(!isset(self::$pdo)){
  36.             try{
  37.                 if(self::$config['dbms']=='mysql'){
  38.                     $dsn = 'mysql:host=' . self::$config['host'] . ';dbname=' . self::$config['dbname'];
  39.                 }else if(self::$config['dbms']=='sqlsrv'){
  40.                     $dsn = 'sqlsrv:server=' . self::$config['host'] . ';database=' . self::$config['dbname'];                    
  41.                 }
  42.                 self::$pdo = new PDO($dsn,self::$config['user'],self::$config['password']);
  43.             }catch(PDOException $e){
  44.                 self::throw_exception($e->getMessage());
  45.             }
  46.         }
  48.         if(!self::$pdo){
  49.             self::throw_exception("PDO连接错误!");
  50.             return false;
  51.         }
  52.     }
  54.     /**
  55.      *获取单条记录
  56.      *@param    string  要执行的sql语句
  57.      *@return   array   结果集(一维数组) 
  58.      */
  59.     public static function fetch($sql=null){
  60.         if($sql!=null)self::query($sql);
  61.         $res = self::$stmt->fetch(constant("PDO::FETCH_ASSOC"));
  62.         return $res;
  63.     }
  65.     /**
  66.      * 获取所有记录
  67.      * @param   string  要执行的sql语句
  68.      * @return  array   结果集(二维数组)
  69.      */
  70.     public static function fetchAll($sql=null){
  71.         if($sql!=null)self::query($sql);
  72.         $res = self::$stmt->fetchAll(constant("PDO::FETCH_ASSOC"));
  73.         return $res;
  74.     }
  76.     /**
  77.      * 执行查询
  78.      * @param   要查询的sql语句
  79.      * @return  boolean
  80.      */
  81.     public static function query($sql=''){
  82.         if(!self::$pdo)return false; //如果PDO未连接则返回
  83.         if(!empty(self::$stmt))self::free(); //如果$stmt之前有结果集则先释放
  85.         self::$sql = $sql;
  86.         self::$stmt = self::$pdo->prepare(self::$sql);
  87.         $res = self::$stmt->execute();
  88.         self::haveErrorThrowException();
  90.         return $res;
  91.     }
  93.     /**
  94.      * 执行增删改操作，返回受影响的行数
  95.      * @param   string  要执行的sql语句
  96.      * @return  number  受影响的行数     * 
  97.      */
  98.     public static function execute($sql=null){
  99.         if(!self::$pdo)return false;//如果PDO未连接则返回
  100.         if(!empty(self::$stmt))self::free(); //如果$stmt之前有结果集则先释放
  101.         if($sql!=null)self::$sql = $sql;
  103.         $res = self::$pdo->exec($sql);
  104.         self::haveErrorThrowException();
  106.         if($res){
  107.             self::$lastInsertId = self::$pdo->lastInsertId();
  108.             return $res;
  109.         }else{
  110.             return false;
  111.         }
  112.     }
  114.     /**
  115.      * 释放结果集
  116.      */
  117.     public static function free(){
  118.         self::$stmt = null;
  119.     }
  121.     /**
  122.      * 自定义错误消息
  123.      * @param   string  错误消息
  124.      */
  125.     public static function throw_exception($msg){
  126.         echo $msg;
  127.     }
  129.     /**
  130.      * 抛出错误信息
  131.      *
  132.      * @return     boolean  ( description_of_the_return_value )
  133.      */
  134.     public static function haveErrorThrowException(){
  135.         $obj = empty(self::$stmt) ? self::$pdo : self::$stmt;
  136.         $arrError = $obj->errorInfo();
  137.         if($arrError[0]!='00000'){
  138.             self::$error = 'SQLSTATE=>'.$arrError[0].'<br/>SQL Error=>'.$arrError[2].'<br/>Error SQL=>'.self::$sql;
  139.             self::throw_exception(self::$error);
  140.             return false;
  141.         }
  142.         if(self::$sql==''){
  143.             self::throw_exception('没有可执行的SQL语句');
  144.             return false;
  145.         }
  146.     }
  147. }

列表页： user_list.php

  1. <?php
  2.     require_once 'auto.php';
  3.     $db = new DB();
  4.     $data = DB::fetchAll('select * from user');
  5. ?>
  7. <!DOCTYPE html>
  8. <html lang="en">
  9.   <head>
  10.     <meta charset="UTF-8" />
  11.     <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  12.     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  13.     <title>用户列表</title>
  14.     <style>
  15.       .list {
  16.         margin:1em auto;
  17.         border-collapse: collapse;
  18.       }
  19.       .title{
  20.           text-align:center;
  21.           margin-top:2em;
  22.       }
  23.       .list th,
  24.       .list td {
  25.         border: 1px solid black;
  26.         font-size:14px;
  27.         padding: 2px 5px;
  28.       }
  29.       .list a{
  30.           background-color: #f3f3f3;
  31.           border-radius:10px;
  32.           padding:0 3px;
  33.       }
  34.     </style>
  35.   </head>
  36.   <body>
  37.     <h2 class="title">用户列表</h2>
  38.     <table class="list">
  39.       <thead>
  40.         <tr>
  41.           <th>id</th>
  42.           <th>帐号</th>
  43.           <th>姓名</th>
  44.           <th>年龄</th>
  45.           <th>手机号码</th>
  46.           <th>注册时间</th>
  47.           <th>登录时间</th>
  48.           <th>状态</th>
  49.           <th>操作</th>
  50.         </tr>
  51.       </thead>
  52.       <tbody>
  53.           <?php
  54.             foreach($data as $row){              
  55.           ?>
  56.         <tr>
  57.           <td><?= $row['id'] ?></td>
  58.           <td><?= $row['account'] ?></td>
  59.           <td><?= $row['name'] ?></td>
  60.           <td><?= $row['age'] ?></td>
  61.           <td><?= $row['phone'] ?></td>
  62.           <td><?= $row['add_time'] ?></td>
  63.           <td><?= $row['last_time'] ?></td>
  64.           <td><?= $row['status'] ?></td>
  65.           <td><a href="user_curd.php?type=m&id=<?= $row['id'] ?>">修改</a> <a href="user_curd.php?type=d&id=<?= $row['id'] ?>">删除</a></td>
  66.         </tr>
  67.         <?php
  68.             }
  69.         ?>
  70.       </tbody>
  71.     </table>
  72.     </body>
  73. </html>

user_list

修改删除操作页： user_curd.php

  1. <?php
  2.     require_once 'auto.php';
  4.     $type = $_REQUEST['type'];
  5.     $id = $_REQUEST['id'];
  6.     if(empty($_POST)){ //GET    
  7.         if($type == 'm'){  //修改 
  8.             $db = new DB();
  9.             $data = DB::fetch("select * from user where id = " . $id);
  10.         }else if($type == 'd'){ //删除
  11.             $db = new DB();
  12.             $res = DB::execute("delete from user where id = " . $id);
  13.             if($res){
  14.                 echo "<script>alert('删除成功!');window.location='user_list.php';</script>";
  15.             }else{
  16.                 echo "<script>alert('没有任何数据被修改!');window.location='user_list.php';</script>";
  17.             }
  18.             return;
  19.         }else{
  20.             echo '无效的请求!';
  21.             return false;
  22.         }
  23.     }else{
  24.         //POST
  25.         $data['account'] = trim($_POST['account']);
  26.         $data['password'] = trim($_POST['pwd']);
  27.         $data['name'] = trim($_POST['username']);
  28.         $data['age'] = trim($_POST['age']);
  29.         $data['phone'] = trim($_POST['phone']);
  30.         $data['add_time'] = strtotime($_POST['atime']);
  31.         $data['last_time'] = strtotime($_POST['ltime']);
  32.         $data['status'] = $_POST['status'];
  34.         if(empty($data['account']) or empty($data['password'])){
  35.             echo '帐号或密码不能为空!';
  36.         }else{ 
  37.             //拼接sql语句       
  38.             $sql = "update user set ";
  39.             foreach($data as $key=>$value){
  40.                 $sql .= $key . " = '" . $value . "',";
  41.             }
  42.             $sql = rtrim($sql,',');
  43.             $sql .= " where id = " . $id;
  45.             //执行修改操作
  46.             $db = new DB();
  47.             $res = DB::execute($sql);
  49.             if($res){
  50.                 // header("Refresh:2;url=user_list.php");
  51.                 echo "<script>alert('修改成功!即将返回用户列表页..');window.location='user_list.php';</script>";
  52.             }else{
  53.                 echo "<script>alert('修改失败!');</script>";
  54.             }
  55.         }
  56.     }
  57. ?>
  59. <!DOCTYPE html>
  60. <html lang="en">
  61.   <head>
  62.     <meta charset="UTF-8" />
  63.     <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  64.     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  65.     <title>用户列表</title>
  66.     <style>
  67.       * {
  68.         box-sizing: border-box;
  69.       }
  70.       .box {
  71.         width: 400px;
  72.         background-color: #f9f9f9;
  73.         margin: 0 auto;
  74.         border-radius: 10px;
  75.       }
  76.       .form {
  77.         width: 400px;
  78.         padding: 1em 1.5em 0.5em 1em;
  79.         display: grid;
  80.         grid-template-columns: 25% 75%;
  81.         gap: 0.5em;
  82.       }
  83.       .title {
  84.         text-align: center;
  85.         margin-top: 1em;
  86.       }
  87.     </style>
  88.   </head>
  89.   <body>
  90.     <h2 class="title">用户信息修改</h2>
  91.     <div class="box">
  92.       <form action="" method="post" class="form">
  93.         <label>id</label>
  94.         <input type="text" value="<?= $data['id'] ?>" name="id" readonly disabled />
  95.         <label for="account">帐号</label>
  96.         <input
  97.           type="text"
  98.           name="account"
  99.           id="account"
  100.           required
  101.           placeholder="帐号不为空..."
  102.           value="<?= $data['account'] ?>"
  103.         />
  104.         <label for="pwd">密码</label>
  105.         <input
  106.           type="password"
  107.           name="pwd"
  108.           id="pwd"
  109.           required
  110.           placeholder="密码不能为空..."
  111.           value="<?= $data['password'] ?>"
  112.         />
  113.         <label for="username">姓名</label>
  114.         <input type="text" name="username" id="username" value="<?= $data['name'] ?>" />
  115.         <label for="age">年龄</label>
  116.         <input type="text" name="age" id="age" value="<?= $data['age'] ?>" />
  117.         <label for="phone">手机号码</label>
  118.         <input type="text" name="phone" id="phone" value="<?= $data['phone'] ?>" />
  119.         <label for="atime">注册时间</label>
  120.         <input type="text" name="atime" id="atime" value="<?= date('Y-m-d',$data['add_time']) ?>"/>
  121.         <label for="ltime">登录时间</label>
  122.         <input type="text" name="ltime" id="ltime" value="<?= date('Y-m-d H:i:s',$data['last_time']) ?>"/>
  123.         <label for="status">状态</label>
  124.         <select name="status" id="status">
  125.           <option value="1" <?= $data['status'] == '1' ? 'selected' : ''; ?> >开启</option>
  126.           <option value="0" <?= $data['status'] == '0' ? 'selected' : ''; ?> >关闭</option>
  127.         </select>
  128.         <label for=""></label>
  129.         <input type="submit" value="提交" />
  130.       </form>
  131.     </div>
  132.   </body>
  133. </html>

user_curd

修改操作截图：

3

4

5

删除操作截图：

6

7

上一条：使用面向对象方法实现用户信息增删改查下一条：PHP4风格的构造函数
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多