Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 结合课程知识完成用户列表的修改和删除功能
Blogger Information
Blog 20
fans 0
comment 1
visits 13140
Special Recommendation
More>
Related recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
结合课程知识完成用户列表的修改和删除功能
zg的php学习
Original
447 people have browsed it

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

工具类： 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

Correcting teacher：PHPzPHPz

Correction status：qualified

Teacher's comments：
Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post