search

博客列表 >使用面向对象方法实现用户信息增删改查

使用面向对象方法实现用户信息增删改查

江流
江流原创
2021年10月21日 20:35:20651浏览

auto.php

  1. <?php
  2. spl_autoload_register(
  3.     function($className){
  4.         // $className 是new的Son这个名字，这个名字是类名，不是文件名
  5.         require $className . '.php';
  6.     }
  7. );

创建PDO文件 CreatePDO.php

  1. <?php
  2. class CreatePDO{    
  4.     public static function Create(){
  5.         try{
  6.             $pdo = new PDO('mysql:host=127.0.0.1;dbname=prodb','root','123456');
  7.         }catch(PDOException $e){
  8.             // 抛出错误，错误是你可以定义的
  9.             echo '数据库连接失败' . $e->getMessage();
  10.         } 
  11.         return  $pdo;
  12.     }
  14. }

模型文件 User.php

  1. <?php
  2. class User{
  3.     public $id;
  4.     public $account;
  5.     public $password;
  6.     public $name;
  7.     public $phone;
  8.     public $email;
  9.     public $createtime;
  10.     public $updatetime;
  11.     public $state;
  12. }

操作文件 UserContr.php

  1. <?php
  2. require_once "auto.php";
  4. class UserContr{ 
  5.     /**
  6.      *添加用户 
  7.      */
  8.     public static function createUser($user){
  9.         $sql="INSERT INTO `php_user` SET `account`=? ,`password`=?,";
  10.         $sql.="`name`=?,`email`=?,`phone`=?,`createtime`=?,`updatetime`=?,`state`=?";
  11.         $pdo =CreatePDO::Create();
  13.         $pre=$pdo->prepare($sql);
  14.         $exec=$pre->execute(
  15.             [
  16.             $user->account,
  17.             $user->password,
  18.             $user->name,
  19.             $user->email,
  20.             $user->phone,
  21.             $user->createTime,
  22.             $user->updateTime,
  23.             $user->state
  24.             ]
  25.         );
  26.         if($exec){
  27.             return 1;
  28.         }else{
  29.             return 0;
  30.         }
  31.     }
  32.     // 根据id查询用户信息
  33.     public static function GetUserById($id){
  34.         $sql="SELECT * FROM `php_user` WHERE `id`=$id";
  35.         $pdo =CreatePDO::Create();
  36.         $pre=$pdo->prepare($sql);
  37.         $exec=$pre->execute();
  38.         $data = $pre -> fetch();
  40.         return $data;
  41.     }
  42.     // 所有用户信息
  43.     public static function GetAllUser(){
  44.         $sql="SELECT * FROM `php_user`";
  45.         $pdo =CreatePDO::Create();
  46.         $pre=$pdo->prepare($sql);
  47.         $exec=$pre->execute();
  48.         $data = $pre -> fetchAll(PDO::FETCH_OBJ);
  50.         return $data;
  52.     }
  53.     // 根据id删除用户信息
  54.     public static function DeleteById($id){
  55.         $pdo =CreatePDO::Create();
  56.         $sql="DELETE FROM `php_user` WHERE id=$id";
  57.         $pre=$pdo->prepare($sql);
  58.         $exec=$pre->execute();
  60.         if($exec){
  61.             $res=1;
  62.         }else{$res=0;}
  63.         return $res;
  64.     }
  65.     // 修改用户信息
  66.     public static function UpdateUser($user){
  67.         $pdo =CreatePDO::Create();
  69.         $sql="UPDATE `php_user` SET `name`=?,`email`=?,`phone`=?,`updatetime`=?,`state`=?  WHERE id=?";
  71.         $pre=$pdo->prepare($sql);
  72.         $exec=$pre->execute(
  73.             [            
  74.             $user->name,
  75.             $user->email,
  76.             $user->phone,
  78.             $user->updateTime,
  79.             $user->state,
  80.             $user->id
  81.             ]
  82.         );
  83.         if($exec){
  84.             return 1;
  85.         }else{
  86.             return 0;
  87.         }
  88.     } 
  89. }

添加用户信息文件 adduser.html（没有修改）

  1. <!DOCTYPE html>
  2. <html lang="en">
  3.   <head>
  4.     <meta charset="UTF-8" />
  5.     <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  7.     <title>添加用户</title>
  8.     <style>
  9.       .form {
  10.         width: 360px;
  11.         margin: 0 auto;
  12.         padding: 10px;
  13.       }
  14.       form {
  15.         display: grid;
  16.         gap: 0.5rem;
  17.       }
  18.       fieldset {
  19.         display: grid;
  20.         gap: 0.5rem;
  21.       }
  22.       h2 {
  23.         text-align: center;
  24.       }
  25.       label {
  26.         margin-left: 40px;
  27.       }
  28.     </style>
  29.   </head>
  30.   <body>
  31.     <div class="form">
  32.       <h2>添加用户</h2>
  33.       <form action="createuser.php" method="post">
  34.         <fieldset>
  35.           <legend>必填项</legend>
  36.           <div>
  37.             <label for="account">用名：</label>
  38.             <input id="account" type="text" name="account" required />
  39.           </div>
  40.           <div>
  41.             <label for="password">密码：</label>
  42.             <input type="password" id="password" name="password" required />
  43.           </div>
  44.         </fieldset>
  45.         <fieldset>
  46.           <legend>选填项</legend>
  48.           <div>
  49.             <label for="name">姓名：</label>
  50.             <input type="text" id="name" name="name" />
  51.           </div>
  52.           <div>
  53.             <label for="email">邮箱：</label>
  54.             <input id="email" type="email" name="email" />
  55.           </div>
  56.           <div>
  57.             <label for="phone">电话：</label>
  58.             <input id="phone" type="number" name="phone" />
  59.           </div>
  60.         </fieldset>
  61.         <div>
  62.           <label for="phone">状态：</label>
  63.           <select name="state" id="">
  64.             <option value="1">开启</option>
  65.             <option value="2">关闭</option>
  66.           </select>
  67.         </div>
  69.         <button>添加</button>
  70.       </form>
  71.     </div>
  72.   </body>
  73. </html>

添加用户信息后台文件createuser.php

  1. <?php
  2. require_once "auto.php";
  3. if(!empty($_POST)){
  4.     $user=new User();
  6.     $user->account=trim($_POST['account']);
  7.     $user->password=md5(trim($_POST['password']));
  8.     $user->name=trim($_POST['name'])??"";
  9.     $user->email=trim($_POST['email'])??"";
  10.     $user->phone=$_POST['phone'];
  12.     $user->createTime=time();
  13.     $user->updateTime=time();
  14.     $user->state=$_POST['state'];
  16.     if(UserContr::createUser($user)){
  17.         echo '<script>alert("添加成功");location.href="showuser.php"</script>';
  18.     }else{
  19.         print_r($pre->errorInfo());
  20.     }
  21. }

显示用户信息文件 showuser.php

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.     <title>显示用户信息</title>
  9.     <style>
  10.   /* 1. 添加表格线,添加给单元格 */
  11.   tbody td,
  12.   th {
  13.     border: 1px solid;
  14.   }
  15.   /* 2. 折叠表格线 */
  16.   table {
  17.     border-collapse: collapse;
  18.     width: 90%;
  19.     /* 对齐 */
  20.     text-align: center;
  21.     margin: 2em auto;
  22.   }
  23.   /* 标题 */
  24.   table caption {
  25.     font-weight: bolder;
  26.     margin-bottom: 1em;
  27.   }
  28.   table thead {
  29.     background-color: lightgreen;
  30.   }
  32.   tbody tr:nth-of-type(2n){
  33.       background-color: #ddd;
  34.   }
  35. </style>
  36. </head>
  37. <body>
  38.     <?php 
  39.      require_once "auto.php";    
  40.     $data=UserContr::GetAllUser();
  41.     ?>
  42.     <div class="show">
  43.         <table>
  44.     <caption>用户信息</caption>
  45.     <thead>
  46.         <tr>
  47.         <th><input type="checkbox" id="check_all"></th>
  48.         <th>ID</th>
  49.         <th>用户名</th>
  50.         <th>姓名</th>
  51.         <th>电话</th>
  52.         <th>邮箱</th>
  53.         <th>创建时间</th>   
  54.         <th>最后登录时间</th> 
  55.         <th>状态</th> 
  56.     </tr>
  57. </thead>
  58.     <tbody>
  59.     <?php foreach($data as $user):  ?>
  60.     <tr>
  61.         <td><input type="checkbox" class="chk_item"></td>
  62.         <td class="id"><?=$user->id?></td>
  63.         <td><a href="edituser.html?id=<?=$user->id?>" title="点击修改用户信息" ><?=$user->account?></a></td>
  64.         <td><?=$user->name?></td>
  65.         <td><?=$user->phone?></td>
  66.         <td><?=$user->email?></td>
  68.         <td><?=date('Y-m-d',$user->createtime)?></td>   
  69.         <td><?=date('Y-m-d',$user->updatetime)?></td> 
  70.         <td><?=$user->state==1?'开启':'关闭'?></td> 
  71.     </tr>        
  73.     <?php endforeach ?>
  74.     </tbody>
  75.     <tfoot>
  76.         <tr><td colspan="3"><button onclick="del()">删除</button></td>
  77.         <td><a href="adduser.html">添加用户</a></td>
  78.     </tr>
  79.     </tfoot>
  81.         </table>
  82.     </div>
  84.     <script>
  85.         const chkAll=document.querySelector("#check_all");
  86.         const chkItems=document.querySelectorAll(".chk_item");
  87.         chkAll.onchange=ev=>chkItems.forEach(item=>item.checked=ev.target.checked);
  88.         chkItems.forEach(item=>item.onchange=()=>chkAll.checked=[...chkItems].every(item=>item.checked));
  90.         function del(){
  91.             if(confirm('您确定要删除这些用户吗？')){
  92.                 const chkItems=document.querySelectorAll(".chk_item");
  93.                 chkItems.forEach(item=>{
  94.                     if(item.checked){
  95.                        const id=item.parentElement.nextElementSibling.textContent;
  96.                        let isDel=delOpt(id);  
  97.                        if(isDel){
  98.                         //    console.log( item.parentElement.parentElement);
  99.                            item.parentElement.parentElement.remove();  
  100.                        }                             
  101.                     }
  102.                 })
  103.             }else{
  104.                 alert("NO");
  105.             }
  106.         }
  107.         async function delOpt(id){
  108.             const response = await fetch("del_user.php?id=" + id);
  109.             const comments = await response.json();
  110.             return comments;
  111.         }
  112.     </script>
  114. </body>
  115. </html>

删除用户文件 del_user.php

  1. <?php
  2. require_once "auto.php";
  3. $id=$_GET['id'];
  5. $res=UserContr::DeleteById($id);
  6. echo $res;

修改用户信息 页面文件edituser.html(没有修改)

  1. <!DOCTYPE html>
  2. <html lang="en">
  3.   <head>
  4.     <meta charset="UTF-8" />
  5.     <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  7.     <title>更新用户</title>
  8.     <style>
  9.       .form {
  10.         width: 360px;
  11.         margin: 0 auto;
  12.         padding: 10px;
  13.       }
  14.       form {
  15.         display: grid;
  16.         gap: 0.5rem;
  17.       }
  18.       fieldset {
  19.         display: grid;
  20.         gap: 0.5rem;
  21.       }
  22.       h2 {
  23.         text-align: center;
  24.       }
  25.     </style>
  26.   </head>
  27.   <body>
  28.     <div class="form">
  29.       <h2>更新用户信息</h2>
  30.       <form action="updateuser.php" method="post">
  31.         <fieldset>
  32.           <legend>用户信息</legend>
  33.           <div>
  34.             <input type="hidden" name="id" />
  35.             <label for="account">用名：</label>
  36.             <input id="account" type="text" name="account" required readonly />
  37.           </div>
  39.           <div>
  40.             <label for="name">姓名：</label>
  41.             <input type="text" id="name" name="name" />
  42.           </div>
  43.           <div>
  44.             <label for="email">邮箱：</label>
  45.             <input id="email" type="email" name="email" />
  46.           </div>
  47.           <div>
  48.             <label for="phone">电话：</label>
  49.             <input id="phone" type="number" name="phone" />
  50.           </div>
  51.         </fieldset>
  52.         <div>
  53.           <label for="phone">状态：</label>
  54.           <select name="state" id="">
  55.             <option value="1">开启</option>
  56.             <option value="2">关闭</option>
  57.           </select>
  58.         </div>
  60.         <button>修改</button>
  61.       </form>
  62.     </div>
  63.     <script>
  64.       let url = location.search;
  65.       let id = url.substr(4);
  66.       if (id > 0) {
  67.         fetch("searchbyid.php?id=" + id)
  68.           .then((response) => response.json())
  69.           .then((json) => {
  70.             const form = document.forms[0];
  71.             form.id.value = json.id;
  72.             form.account.value = json.account;
  73.             form.account.readonly = true;
  74.             form.phone.value = json.phone;
  75.             form.email.value = json.email;
  76.             form.name.value = json.name;
  77.             form.state.value = json.state;
  78.           });
  79.       } else {
  80.       }
  81.     </script>
  82.   </body>
  83. </html>

修改用户信息 后台文件updateuser.php

  1. <?php
  2. require_once "auto.php";
  3. if(!empty($_POST)){
  4.     $user=new User();
  5.     $user->id=$_POST['id'];
  6.     $user->account=trim($_POST['account']);
  8.     $user->name=trim($_POST['name'])??"";
  9.     $user->email=trim($_POST['email'])??"";
  10.     $user->phone=$_POST['phone'];
  12.     $user->updateTime=time();
  13.     $user->state=$_POST['state'];    
  15.     $res=UserContr::UpdateUser($user);
  17.     if($res){
  19.         echo '<script>alert("修改成功");location.href="showuser.php"</script>';
  20.     }else{
  22.     }
上一条：静态、抽象、类常量、接口、后期静态绑定以及魔术方法下一条：结合课程知识完成用户列表的修改和删除功能
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多