yii简单增删改查操作

//①连接数据库连接


//②创建model层
<?php
namespace app\models;
use yii\db\ActiveRecord;

class Motto extends ActiveRecord{

}
?>
//③控制器调用model层进行CURD操作 
<?php
/**
 * Created by PhpStorm.
 * User: crazy stone
 * Date: 2017/2/8
 * Time: 16:07
 */

namespace frontend\controllers;  //命名空间

use Yii;        //使用yii核心类库
use yii\web\Controller;   ///使用yii核心类库里的 controller
use app\models\Motto;

class HelloController extends Controller{


    
     //查看
    public function actionList(){
        $sql='select m_id,m_name from motto ';
        $data=Motto::findBySql($sql)->asArray()->all();
//        print_r($data);die;
        return $this->renderPartial('list',$data);//赋值给页面
    }
    //删除
    public function actionDel(){
        //方法1
        $res=Motto::find()->where(['m_id'=>5])->all();
        $res[0]->delete();
        //方法2
        Motto::deleteAll('m_id>3');
    }

    //添加
    public function actionAdd(){
        $motto=new Motto;
        $motto->m_name='啊啊啊';
        $motto->type_id=16;
        $motto->l_id=1;
        $motto->m_add_time=time();
        $motto->hitts=2;
        $motto->author=2;
        $motto->save();
    }
    //修改
    public function actionSave(){
        $res=Motto::find()->where(['m_id'=>3])->one();
        $res->m_name='石文远';
        $res->save();
    }
}