thinkphp5操作mysql数据库入库信息方法整理

柔光的暖阳◎ 2022-12-28 01:35 193阅读 0赞

### thinkphp5操作mysql数据库入库信息方法整理 ###

*   *  添加用户add.html
     *  创建公共lib库
     *  封装配置文件参数
     *  创建model层
     *  admin控制器add方法

## 添加用户add.html ##

{include file="public/_meta" /}
    <article class="page-container">
      <form class="form form-horizontal" id="form-admin-add" method="post" action="{:url('admin/add')}">
        <div class="row cl">
          <label class="form-label col-xs-4 col-sm-3"><span class="c-red">*</span>管理员名：</label>
          <div class="formControls col-xs-8 col-sm-9">
            <input type="text" class="input-text" value="" placeholder="" id="username" name="username">
          </div>
        </div>
        <div class="row cl">
          <label class="form-label col-xs-4 col-sm-3"><span class="c-red">*</span>密码：</label>
          <div class="formControls col-xs-8 col-sm-9">
            <input type="password" class="input-text" autocomplete="off" value="" placeholder="密码" id="password" name="password">
          </div>
        </div>
    
        <div class="row cl">
          <div class="col-xs-8 col-sm-9 col-xs-offset-4 col-sm-offset-3">
            <input class="btn btn-primary radius" type="submit" value="  提交  ">
          </div>
        </div>
      </form>
    </article>
    {include file="public/_footer" /}
    
    </body>
    </html>

## 创建公共lib库 ##

thinkphpwu/application/common/lib 中创建AdminAuth.php 文件，用于验证密码信息，封装之后，可以复用

<?php
    
    namespace app\common\lib;
    
    class AdminAuth
    { 
        //得到密码加密后的信息
        public static function setPassword($password)
        { 
           return md5($password.config('app.admin_password_pre'));
        }
    }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70]

## 封装配置文件参数 ##

在thinkphpwu/application/extra 目录中创建app.php

<?php
    
    return [
        'admin_password_pre' => '_qipa250',//后台管理员密码加密后缀
    ];

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70 1]  
调用方法：

> config(‘文件名称.参数’);  
> config(‘app.admin\_password\_pre’);

## 创建model层 ##

<?php
    
    namespace app\common\model;
    
    
    use think\Model;
    
    
    class AdminUser extends Model
    { 
        //新增管理员信息入库
        public function add($params)
        { 
            //判断是否为数组
            if (!is_array($params)) { 
                //抛出异常
                exception('传递的数据不合法！');
            }
            //常用变量
            $params['status'] = 0;
            $params['create_time'] = date('Y-m-d H:i:s', time());
            //入库
            $this->allowField(true)->save($params);
            //返回主键id
            return $this->getLastInsID();
        }
    }

## admin控制器add方法 ##

<?php
    
    namespace app\admin\controller;
    
    use app\common\lib\AdminAuth;
    use think\Controller;
    use think\Exception;
    
    
    class Admin extends Controller
    { 
        public function add()
        { 
    
            try { 
                //判断是否为post提交
                if (request()->isPost()) { 
                    //得到post提交的数据
                    $data = (input('post.'));
                    //实例化校验规则类库
                    $validate = validate('AdminUser');
                    //校验
                    if (!$validate->check($data)) { 
                        $this->error($validate->getError());
                    }
                    
                    //组装数据入库
                    $params = array(
                        'username' => $data['username'],
                        'password' => AdminAuth::setPassword($data['password']),
                    );
                    //判断是否已经存在
                    $admin_user_info = model('AdminUser')->get(['username' => $data['username']]);
                    if ($admin_user_info) { 
                        $this->error('该用户名称已经存在，请勿重复添加！');
                    }
                    //入库
                    $admin_user_id = model('AdminUser')->add($params);
                    if (!$admin_user_id) { 
                        $this->error('管理员添加失败！');
                    }          
                  $this->success('添加管理员成功!', 'index/index');
                } else { 
                    //加载视图文件
                    return $this->fetch();
                }
            } catch (Exception $e) { 
                $this->error($e->getMessage());
            }
        }
    }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70 3]数据库中查看

![在这里插入图片描述][20201213153327879.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70]: /images/20221120/8b4c4ab33a574651a75045cef19868a0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70 1]: /images/20221120/fc7d41c6f78848ccb042df3eca467d70.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/2020121315330822.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20201213153319277.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n,size_16,color_FFFFFF,t_70
[20201213153327879.png]: https://img-blog.csdnimg.cn/20201213153327879.png