用户信息添加、修改、删除

添加用户信息 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.     </style>
  26.   </head>
  27.   <body>
  28.     <div class="form">
  29.       <h2>添加用户</h2>
  30.       <form action="createuser.php" method="post">
  31.         <fieldset>
  32.           <legend>必填项</legend>
  33.           <div>
  34.             <label for="account">用名：</label>
  35.             <input id="account" type="text" name="account" required />
  36.           </div>
  37.           <div>
  38.             <label for="password">密码：</label>
  39.             <input type="password" id="password" name="password" required />
  40.           </div>
  41.         </fieldset>
  42.         <fieldset>
  43.           <legend>选填项</legend>
  45.           <div>
  46.             <label for="name">姓名：</label>
  47.             <input type="text" id="name" name="name" />
  48.           </div>
  49.           <div>
  50.             <label for="email">邮箱：</label>
  51.             <input id="email" type="email" name="email" />
  52.           </div>
  53.           <div>
  54.             <label for="phone">电话：</label>
  55.             <input id="phone" type="number" name="phone" />
  56.           </div>
  57.         </fieldset>
  58.         <div>
  59.           <label for="phone">状态：</label>
  60.           <select name="state" id="">
  61.             <option value="1">开启</option>
  62.             <option value="2">关闭</option>
  63.           </select>
  64.         </div>
  66.         <button>添加</button>
  67.       </form>
  68.     </div>
  69.   </body>
  70. </html>

数据库链接，创建PDO对象文件 linkdb.php

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

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

  1. <?php
  2. require_once "linkdb.php";
  3. if(!empty($_POST)){
  4.     $account=trim($_POST['account']);
  5.     $password=md5(trim($_POST['password']));
  6.     $name=trim($_POST['name'])??"";
  7.     $email=trim($_POST['email'])??"";
  8.     $phone=$_POST['phone'];
  9.     // var_dump(is_integer($phone),$phone);
  11.     $createTime=time();
  12.     $updateTime=time();
  13.     $state=$_POST['state'];
  17.     $pdo->query('SET NAMES utf8');
  18.     $sql="INSERT INTO `php_user` SET `account`=? ,`password`=?,";
  19.     $sql.="`name`=?,`email`=?,`phone`=?,`create_time`=?,`update_time`=?,`state`=?";
  20.     $pre=$pdo->prepare($sql);
  21.     $exec=$pre->execute(
  22.         [
  23.         $account,
  24.         $password,
  25.         $name,
  26.         $email,
  27.         $phone,
  28.         $createTime,
  29.         $updateTime,
  30.         $state
  31.         ]
  32.     );
  33.     if($exec){
  34.         echo $pre -> rowCount();
  35.         echo '<hr>';
  36.         echo $pdo -> lastInsertId();
  37.         echo '<script>alert("添加成功");location.href="showuser.php"</script>';
  38.     }else{
  39.         print_r($pre->errorInfo());
  40.     }
  42. }

显示用户信息文件 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 "linkdb.php";
  40.     $sql='SELECT * FROM `php_user`';
  41.     $pre=$pdo->prepare($sql);
  42.     $pre -> bindColumn('id',$id);
  43.     $pre -> bindColumn('account',$account);
  44.     $pre -> bindColumn('name',$name);
  45.     $pre -> bindColumn('phone',$phone);
  46.     $pre -> bindColumn('email',$email);
  47.     $pre -> bindColumn('create_time',$create_time);
  48.     $pre -> bindColumn('update_time',$update_time);
  49.     $pre -> bindColumn('state',$state);
  50.     $exec=$pre->execute();
  53.     ?>
  54.     <div class="show">
  55.         <table>
  56.     <caption>用户信息</caption>
  57.     <thead>
  58.         <tr>
  59.         <th><input type="checkbox" id="check_all"></th>
  60.         <th>ID</th>
  61.         <th>用户名</th>
  62.         <th>姓名</th>
  63.         <th>电话</th>
  64.         <th>邮箱</th>
  65.         <th>创建时间</th>   
  66.         <th>最后登录时间</th> 
  67.         <th>状态</th> 
  68.     </tr>
  69. </thead>
  70.     <tbody>
  71.     <?php while ($pre->fetch(PDO::FETCH_ASSOC)):?>
  72.         <tr>
  73.         <td><input type="checkbox" class="chk_item"></td>
  74.         <td class="id"><?=$id?></td>
  75.         <td><a href="edituser.html?id=<?=$id?>" title="点击修改用户信息" ><?=$account?></a></td>
  76.         <td><?=$name?></td>
  77.         <td><?=$phone?></td>
  78.         <td><?=$email?></td>
  80.         <td><?=date('Y-m-d',$create_time)?></td>   
  81.         <td><?=date('Y-m-d',$update_time)?></td> 
  82.         <td><?=$state==1?'开启':'关闭'?></td> 
  83.     </tr>
  84.     <?php endwhile ?>
  85.     </tbody>
  86.     <tfoot>
  87.         <tr><td colspan="3"><button onclick="del()">删除</button></td>
  88.         <td><a href="adduser.html">添加用户</a></td>
  89.     </tr>
  90.     </tfoot>
  92.         </table>
  93.     </div>
  95.     <script>
  96.         const chkAll=document.querySelector("#check_all");
  97.         const chkItems=document.querySelectorAll(".chk_item");
  98.         chkAll.onchange=ev=>chkItems.forEach(item=>item.checked=ev.target.checked);
  99.         chkItems.forEach(item=>item.onchange=()=>chkAll.checked=[...chkItems].every(item=>item.checked));
  101.         function del(){
  102.             if(confirm('您确定要删除这些用户吗？')){
  103.                 const chkItems=document.querySelectorAll(".chk_item");
  104.                 chkItems.forEach(item=>{
  105.                     if(item.checked){
  106.                        const id=item.parentElement.nextElementSibling.textContent;
  107.                        let isDel=delOpt(id);  
  108.                        if(isDel){
  109.                         //    console.log( item.parentElement.parentElement);
  110.                            item.parentElement.parentElement.remove();
  112.                        }                     
  114.                     }
  115.                 })
  116.             }else{
  117.                 alert("NO");
  118.             }
  119.         }
  120.         async function delOpt(id){
  121.             const response = await fetch("del_user.php?id=" + id);
  122.             const comments = await response.json();
  123.             return comments;
  125.         }
  126.     </script>
  128. </body>
  129. </html>

  • 选中，点击删除

删除用户文件 del_user.php

  1. <?php
  2. require_once "linkdb.php";
  3. $id=$_GET['id'];
  5. $sql="DELETE FROM `php_user` WHERE id=$id";
  6. $pre=$pdo->prepare($sql);
  7. $exec=$pre->execute();
  8. if($exec){
  9.     echo 1;
  10. }else{echo 0;}

修改用户信息 页面文件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 "linkDB.php";
  3. if(!empty($_POST)){
  4.     $id=$_POST['id'];
  5.     $account=trim($_POST['account']);
  7.     $name=trim($_POST['name'])??"";
  8.     $email=trim($_POST['email'])??"";
  9.     $phone=$_POST['phone'];
  10.     // var_dump(is_integer($phone),$phone);
  13.     $updateTime=time();
  14.     $state=$_POST['state'];    
  17.     $pdo->query('SET NAMES utf8');
  18.     $sql="UPDATE `php_user` SET `name`=?,`email`=?,`phone`=?,`update_time`=?,`state`=?  WHERE id=?";
  19.     $pre=$pdo->prepare($sql);
  20.     $exec=$pre->execute(
  21.         [        
  22.         $name,
  23.         $email,
  24.         $phone,
  26.         $updateTime,
  27.         $state,
  28.         $id
  29.         ]
  30.     );
  31.     if($exec){
  32.         echo $pre -> rowCount();
  33.         echo '<hr>';
  34.         echo $pdo -> lastInsertId();
  35.         echo '<script>alert("修改成功");location.href="showuser.php"</script>';
  36.     }else{
  37.         print_r($pre->errorInfo());
  38.     }
  40. }

更多相关文章

  1. PHP用数据库类实现数据库增删改查
  2. 如何通过PHP将“if”添加到给定字符串的前面
  3. 【前端】手机号码输入框添加 空格
  4. 【前端】添加draggable 属性，无论怎么设置都无法触发dragstart后
  5. 事件的添加方式
  6. JavaScript实现留言板添加删除留言
  7. 三分钟！意派Epub360制作高端H5邀请函
  8. html中的链接不添加http（协议相对 URL）
  9. 尝试用css各类选择器添加样式制作一个注册表单

随机推荐

  1. Android中MVC框架的运用
  2. 从零开始写项目【总结】
  3. android 属性系统代码分析
  4. Android中显示html标签或者带图片
  5. 一个java同步工具类Semaphore的详解
  6. Android(安卓)ContentProvider和Uri详解
  7. 【android】 使用sd卡
  8. Android实现AppWidget、Broadcast静态注
  9. 浅谈Android五大布局——LinearLayout、F
  10. android快速开发框架afinal（数据库篇）