yii2使用ActiveRecord类对数据库的操作-蒲公英云

yii2使用ActiveRecord类对数据库的操作

你的名字 2021-12-14 15:45 317阅读 0赞

ActiveRecord提供了一套面向对象的对数据库进行增删改查的方法，很实用，省去了select*的一系列操作

注意:一个ActiveRecord类对应一个数据表

首先来创建一个model，然后model内如下配置

<?php
namespace frontend\models;
use yii\db\ActiveRecord;
class Userinfo extends ActiveRecord
{
    //这里来配置连接的表名
    public static function tableName()
    {
        return 'userinfo';
    }
}

下面就可以开始对username表进行操作了

1.find()方法的使用

//获取表中所有数据信息并数组化
    public static function getallusermsg()
    {
        $model = self::find() -> asArray()  -> all();
        return $model;
    }
//按条件查询
    public static function getusermsg($username)
    {
        $model = self::find() -> asArray() -> where(['username' => $username]) -> one();
        return model;
    }
//数据库添加
    public static function setusermsg($userinfo)
    {
        $userinfotable = new userinfo;
        $userinfotable->username = $userinfo['username'];
        $userinfotable->password = $userinfo['password'];
        $userinfotable->role = $userinfo['role'];
        if ($userinfotable->save()) {
            return ['code' => 200,'message' => '注册成功！'];
        } else {
            return ['code' => 201,'message' => '注册失败！'];
        }
    }
//数据库更新
    public static function setusermsg($username)
    {
        $model = self::find() -> asArray() -> where(['username' => $username]) -> one();
        $model->username = 'suibian';
        if ($model->save()) {
            return ['code' => 200,'message' => '注册成功！'];
        } else {
            return ['code' => 201,'message' => '注册失败！'];
        }
    }
//数据库删除
    public static function setusermsg($username,$password)
    {
        $model = self::find() -> where(['username' => $username,'password' => $password]) -> one();
        if ($model->delete()) {
            return ['code' => 200,'message' => '注册成功！'];
        } else {
            return ['code' => 201,'message' => '注册失败！'];
        }
    }