yii框架的简单curd

class HelloController extends Controller
{

    public $enableCsrfValidation = false; //禁用csrf拦截 禁止提交重复表单

    /**
     * 添加
     *
     * @author YING
     * @param void
     * @return void
     */
     public function actionAdd(){

         $request=Yii::$app->request; //实例化请求类

         if($request->isPost){
             $data=$request->post(); //接值
             $res=Yii::$app->db->createCommand()->insert("user",$data)->execute(); //执行
             if($res){
                $this->redirect(["hello/list"]);
             }else{
                 echo "添加失败";
             }

         }else{

             return $this->renderPartial("register.html");

         }
     }

    /**
     * 查询
     *
     * @author YING
     * @param void
     * @return void
     */
     public function actionList(){
         //查询
         $db=Yii::$app->db;
         $userInfo=$db->createCommand("select * from `user`")->queryAll();//执行
         return $this->render("list",["userInfo"=>$userInfo]); //赋值

     }

    /**
     * 删除
     *
     * @author YING
     * @param id
     * @return void
     */
    public function actionDelete(){
        $request=Yii::$app->request; //定义类
        $id=$request->get("id"); //接值
        $db=Yii::$app->db;
        $res=$db->createCommand()->delete("user","id=$id")->execute(); //执行

        //判断
        if($res){
            $this->redirect(["hello/list"]);
        }else{
            echo  "删除失败";
        }

    }


    /**
     * 修改
     *
     * @author YING
     * @param void
     * @return void
     */
    public function  actionUpdate(){

        $request=Yii::$app->request; //请求方式

        if($request->isPost){

            //接值
            $username=$request->post("username");
            $password=$request->post("password");
            $id=$request->post("id");

            $result=Yii::$app->db->createCommand()->update("user",["username"=>$username,"password"=>$password],"id=:id",[":id"=>$id])->execute();

            //判断
            if($result){
               $this->redirect(["hello/list"]);
            }else{
                echo "修改失败";
            }


        }else{

            $id=$request->get("id"); //接值
            $sql="select * from `user` where id="$id""; //sql语句

            $userInfo=Yii::$app->db->createCommand($sql)->queryAll(); //执行
            return $this->render("update",["userInfo"=>$userInfo[0]]); //加载视图层

        }



    }






}