Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 初识 类与对象
Blogger Information
Blog 14
fans 0
comment 0
visits 9497
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
初识 类与对象
Mr.Ran
Original
486 people have browsed it

1.创建一个用户类

文件 users.php 代码:

  1. <?php
  2.     // 用户类
  3.     class User{
  4.         public $phone;
  5.         public $pwd;
  6.         public $name;
  7.         public $age;
  8.         public $status;
  10.         //登录
  11.         public function login($uphone,$upwd){
  12.             require('db.php');
  13.             $sql = "select * from users where u_phone = '".$uphone."' and u_pwd ='".md5($upwd)."'";
  14.             $stmt = $pdo -> prepare($sql);
  15.             $res = $stmt -> execute();
  16.             if ($res) {
  17.             $row = $stmt -> fetch();
  18.             if (!empty($row)) {
  19.                 return array('code'=>1,'msg'=>"登录成功",'res'=>$row);
  20.             }else {
  21.                 return array('code'=>0,'msg'=>'登录失败');
  22.             };
  23.             };
  24.         }
  26.         //获取用户信息
  27.         public function getUser($id){
  28.             require('db.php');
  29.             $sql = "select * from users where u_id = ".$id."";
  30.             $stmt = $pdo -> prepare($sql);
  31.             $res = $stmt -> execute();
  32.             if ($res) {
  33.             $row = $stmt -> fetch();
  34.             if (!empty($row)) {
  35.                 return array('code'=>1,'msg'=>"成功",'res'=>$row);
  36.             }else {
  37.                 return array('code'=>0,'msg'=>'失败');
  38.             };
  39.             };
  40.         }
  42.         //获取用户列表
  43.         public function getUserList(){
  44.             require('db.php');
  45.             $sql = "select * from users";
  46.             $stmt = $pdo -> prepare($sql);
  47.             $res = $stmt -> execute();
  48.             if ($res) {
  49.             $row = $stmt -> fetchAll();
  50.             if (!empty($row)) {
  51.                 return array('code'=>1,'msg'=>"成功",'res'=>$row);
  52.             }else {
  53.                 return array('code'=>0,'msg'=>'失败');
  54.             };
  55.             };
  56.         }
  58.         //注册
  59.         public function add($uphone,$upwd,$uname,$uage){
  60.             require('db.php');
  61.             $sql = "insert into `users`(`u_phone`,`u_pwd`,`u_name`,`u_age`,`u_createtime`) values('".$uphone."','".md5($upwd)."','".$uname."',".$uage.",".time().")";
  62.             $stmt = $pdo -> prepare($sql);
  63.             $stmt -> execute();
  64.             if ($stmt -> rowCount() > 0) {
  65.             return array('code'=>1,'msg'=>"注册成功");
  66.             }else {
  67.             return array('code'=>0,'msg'=>'注册失败');
  68.             };
  69.         }
  71.         //修改
  72.         public function update($id,$name,$age,$pwd,$status){
  73.             require('db.php');
  74.             if (!empty($pwd)) {
  75.                 $sql = "update `users` set `u_name`='".$name."',`u_age`=".$age.",`u_pwd`= '".md5($pwd)."',`u_status`=".$status." where `u_id` = ".$id.";";
  76.             }else {
  77.                 $sql = "update `users` set `u_name`='".$name."',`u_age`=".$age.",`u_status`=".$status." where `u_id` = ".$id.";";
  78.             }
  79.             $stmt = $pdo -> prepare($sql);
  80.             $stmt -> execute();
  81.             if ($stmt -> rowCount() > 0) {
  82.             return array('code'=>1,'msg'=>"修改成功");
  83.             }else {
  84.             return array('code'=>0,'msg'=>'修改失败');
  85.             };
  86.         }
  88.         //删除
  89.         public function delete($uid){
  90.             require('db.php');
  91.             $sql = "delete from `users` where `u_id` = ".$uid;
  92.             echo $sql;
  93.             $stmt = $pdo -> prepare($sql);
  94.             $stmt -> execute();
  95.             if ($stmt -> rowCount() > 0) {
  96.             return array('code'=>1,'msg'=>"删除成功");
  97.             }else {
  98.             return array('code'=>0,'msg'=>'删除失败');
  99.             };
  100.         }
  102.     }
  104. ?>

2.注册用户

文件 reg.php 代码:

  1. <?php
  2.     require_once('users.php');
  3.     if (isset($_POST['submit'])) {
  4.         $user = new User();
  5.         $u = $user->add($_POST['phone'],$_POST['pwd'],$_POST['name'],$_POST['age']);
  6.         if ($u['code']) {
  7.             print_r($u);
  8.             echo "<script>alert('".$u['msg']."');location.href='login.php'</script>";
  9.         } else {
  10.             echo "<script>alert('".$u['msg']."');</script>";
  11.         }
  12.     }
  13. ?>
  15. <!DOCTYPE html>
  16. <html lang="en">
  17. <head>
  18.     <meta charset="UTF-8">
  19.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  20.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  21.     <title>注册</title>
  22.     <link href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.6.0/css/bootstrap.css" rel="stylesheet" />
  23. </head>
  24. <body>
  25.     <div class="jumbotron">
  26.         <h1 class="display-4">用户注册</h1>
  27.         <hr class="my-4">
  28.         <form method="POST" action="" >
  29.             <div class="form-group">
  30.                 <label>姓名</label>
  31.                 <input class="form-control" type="text" name="name">
  32.             </div>
  33.             <div class="form-group">
  34.                 <label>手机号</label>
  35.                 <input class="form-control" type="text" name="phone">
  36.             </div>
  37.             <div class="form-group">
  38.                 <label>密码</label>
  39.                 <input class="form-control" type="password" name="pwd">
  40.             </div>
  41.             <div class="form-group">
  42.                 <label>年龄</label>
  43.                 <input class="form-control" type="number" name="age">
  44.             </div>
  45.             <hr class="my-4">
  46.             <button type="submit" name="submit" class="btn btn-primary">立即注册</button>
  47.             <a  href="login.php" class="btn btn-success">登录</a>
  48.         </form>
  49.     </div>
  50. </body>
  51. </html>

3.登录

文件 login.php 代码:

  1. <?php
  2.     require_once('users.php');
  3.     if (!empty($_POST['phone'])) {
  4.         $user = new User();
  5.         $u = $user->login($_POST['phone'],$_POST['pwd']);
  6.         if ($u['code']) {
  7.             echo "<script>alert('".$u['msg']."');location.href='list.php'</script>";
  8.         } else {
  9.             echo "<script>alert('".$u['msg']."');</script>";
  10.         }
  11.     }
  12. ?>
  14. <!DOCTYPE html>
  15. <html lang="en">
  16. <head>
  17.     <meta charset="UTF-8">
  18.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  19.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  20.     <title>登录</title>
  21.     <link href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.6.0/css/bootstrap.css" rel="stylesheet" />
  22. </head>
  23. <body>
  24.     <div class="jumbotron">
  25.         <h1 class="display-4">登录</h1>
  26.         <hr class="my-4">
  27.         <form method="POST" action="" >
  28.             <div class="form-group">
  29.                 <label>手机号</label>
  30.                 <input class="form-control" type="text" name="phone">
  31.                 <small class="form-text text-muted">请输入手机号码</small>
  32.             </div>
  33.             <div class="form-group">
  34.                 <label>密码</label>
  35.                 <input class="form-control" type="password" name="pwd">
  36.             </div>
  37.             <button type="submit" class="btn btn-primary">登录</button>
  38.             <a  href="reg.php" class="btn btn-success">注册</a>
  39.         </form>
  40.     </div>
  41. </body>
  42. </html>

4.用户列表&删除用户

文件 list.php 代码:

  1. <?php
  3.     require_once('users.php');
  4.     $user = new User();
  5.     $u = $user->getUserList();
  7.     if (!empty($_GET['id'])) {
  8.         $res = $user -> delete($_GET['id']);
  9.         if ($res['code'] === 1) {
  10.             echo "<script>alert('".$res['msg']."');location.href='list.php'</script>";
  11.         } else {
  12.             echo "<script>alert('".$res['msg']."');</script>";
  13.         }
  14.     }
  16. ?>
  18. <!DOCTYPE html>
  19. <html lang="en">
  20. <head>
  21.     <meta charset="UTF-8">
  22.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  23.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  24.     <title>用户列表</title>
  25.     <link href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.6.0/css/bootstrap.css" rel="stylesheet" />
  26. </head>
  27. <body>
  28.     <div class="jumbotron">
  29.         <h1 class="display-4">用户列表</h1>
  30.         <hr class="my-4">
  31.         <table class="table">
  32.             <thead class="thead-dark">
  33.                 <tr>
  34.                     <th>ID</th>
  35.                     <th>手机号</th>
  36.                     <th>用户名</th>
  37.                     <th>年龄</th>
  38.                     <th>注册日期</th>
  39.                     <th>状态</th>
  40.                     <th>操作</th>
  41.                 </tr>
  42.             </thead>
  43.             <tbody>
  44.                 <?php foreach ($u['res'] as $user) { ?>
  45.                 <tr>
  46.                     <td><?=$user['u_id']?></td>
  47.                     <td><?=$user['u_phone']?></td>
  48.                     <td><?=$user['u_name']?></td>
  49.                     <td><?=$user['u_age']?></td>
  50.                     <td><?=date('Y-m-d',$user['u_createtime'])?></td>
  51.                     <td><?=$user['u_status'] == 0?'<span class="badge badge-warning">待审</span>':'<span class="badge badge-success">正常</span>'?></td>
  52.                     <td>
  53.                         <a href="edit.php?id=<?=$user['u_id']?>" class="btn btn-primary btn-sm">修改</a>
  54.                         <a href="list.php?id=<?=$user['u_id']?>" class="btn btn-danger btn-sm">删除</a>
  55.                     </td>
  56.                 </tr>
  57.                 <?php } ?>
  58.             </tbody>
  59.         </table>
  60.     </div>
  62. </body>
  63. </html>

5.编辑用户

文件 edit.php 代码:

  1. <?php
  2.     require_once('users.php');
  3.     $id = $_GET['id'];
  4.     $info = array();
  6.     if (!empty($id)) {
  7.         $user = new User();
  8.         //读取用户信息
  9.         $uinfo = $user -> getUser($id);
  10.         if ($uinfo['code'] == 1) {
  11.             $info  =  $uinfo['res'];
  12.         }
  14.         //提交修改
  15.         if(isset($_POST['submit'])){
  16.             $status = $_POST['status'];
  17.             $u = $user-> update($id,$_POST['name'],$_POST['age'],$_POST['pwd'],$status == 'on'? $status=1:$status=0);
  18.             if ($u['code']) {
  19.                 echo "<script>alert('".$u['msg']."');location.href='list.php'</script>";
  20.             } else {
  21.                 echo "<script>alert('".$u['msg']."');</script>";
  22.             }
  23.         }
  24.     }else {
  25.         echo "<script>alert('请选择用户');</script>";
  26.     }
  27. ?>
  29. <!DOCTYPE html>
  30. <html lang="en">
  31. <head>
  32.     <meta charset="UTF-8">
  33.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  34.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  35.     <title>修改用户信息</title>
  36.     <link href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.6.0/css/bootstrap.css" rel="stylesheet" />
  37. </head>
  38. <body>
  39.     <div class="jumbotron">
  40.         <h1 class="display-4">编辑用户信息</h1>
  41.         <hr class="my-4">
  42.         <form method="POST" action="" >
  43.             <div class="form-group">
  44.                 <label>姓名</label>
  45.                 <input class="form-control" type="text" name="name" value="<?=$info['u_name']?>">
  46.             </div>
  47.             <div class="form-group">
  48.                 <label>手机号</label>
  49.                 <input class="form-control" type="text" name="phone" value="<?=$info['u_phone']?>" readonly>
  50.             </div>
  51.             <div class="form-group">
  52.                 <label>密码</label>
  53.                 <input class="form-control" placeholder="不填为不修改" type="password" name="pwd" value="">
  54.             </div>
  55.             <div class="form-group">
  56.                 <label>年龄</label>
  57.                 <input class="form-control" type="number" name="age" value="<?=$info['u_age']?>">
  58.             </div>
  59.             <div class="form-group">
  60.                 <div class="custom-control custom-switch">
  61.                     <input type="checkbox" class="custom-control-input" name="status" <?=$info['u_status']==1?'checked':''?> id="status">
  62.                     <label class="custom-control-label" for="status">状态</label>
  63.                 </div>
  64.             </div>
  65.             <hr class="my-4">
  66.             <button type="submit" name="submit" class="btn btn-primary">提交修改</button>
  67.         </form>
  68.     </div>
  69. </body>
  70. </html>

6.运行效果

  • 列表页:
  • 登录页:
  • 编辑页:
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