yii框架的简单curd

来源：互联网发布：冰川网络手游怎么样编辑：程序博客网时间：2024/04/29 19:19
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]]); //加载视图层        }    }}
0 0