//①連接數據庫連接//②創建model層
<?phpnamespace 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核心類庫里的 controlleruse 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();    }}