yii中一些简单的增删改查

在控制器层

<?php

namespace frontend\controllers;

use Yii;
use yii\base\InvalidParamException;
use yii\web\BadRequestHttpException;
use yii\web\Controller;
use yii\filters\VerbFilter;
use yii\filters\AccessControl;
use common\models\LoginForm;
use frontend\models\PasswordResetRequestForm;
use frontend\models\ResetPasswordForm;
use frontend\models\SignupForm;
use frontend\models\ContactForm;
use frontend\models\User;
class NewsController extends Controller

{
  public $enableCsrfValidation=false;//注意yii中表单提交页面咋控制器要加上这一句
    /**
     * 展示表单/添加页面
     */
    public function actionIndex()
    {
        $request = \YII::$app->request;
       if ($request->post())
        {
          $data = $request->post();
          $user = new User;
          $user->username=$data['username'];
          $user->age=$data['age'];
          $user->sex=$data['sex'];
          $user->save();
          $this->redirect("index.php?r=news/show");
        }
       else
       {
            return $this->render("form");
       }
    }

    public function actionShow()
    {
       $arr = User::find()->asArray()->all();
       $data['arr']=$arr;
       return $this->render("show",$data);

    }

    /**
     * 删除
     *
     * @author: BING <itbing@sina.cn>
     */    
 

   public function actionDel()
   {
        $request = \YII::$app->request;
      if ($request->get("id"))
        {
           $id = $request->get("id");
           User::deleteAll("id=$id");
             $this->redirect("index.php?r=news/show");
        }
        else
        {
           $this->redirect("index.php?r=news/show");
        }

   }

   public function actionUpdate()
   {
       $request = \YII::$app->request;
       $id =$request->get("id");
       $arr = User::find()->where(["id"=>$id])->asArray()->one();
      // print_r($arr);die;
      if ($request->post())
        {
          $data = $request->post();
          $user = new User;
          $user->username=$data['username'];
          $user->age=$data['age'];
          $user->sex=$data['sex'];
          $id=$data['id'];
          User::find()->where(["id"=>$id])->asArray()->one();
          $user->save();
          $this->redirect("index.php?r=news/show");
        }
        else
        {
         return $this->render("update",$arr);

        }

   }

}

在models层中,我们使用活动记录ActiveRecord
<?php
namespace frontend\models;
use yii\db\ActiveRecord;

class User extends ActiveRecord
{

    
}

这里的ActiveRecord之中已经封装好了所需要的增删改查