search

博客列表 >初识 类与对象

初识 类与对象

Mr.Ran
Mr.Ran原创
2021年10月20日 19:29:51485浏览

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.运行效果

  • 列表页:
  • 登录页:
  • 编辑页:
上一条：数据库与商城sql下一条：通过curl请求接口实现数据读取
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多