创建新的数据库的语句
{{return array(‘accessControl’,);}{return array((‘allow’,’actions’=>array(‘index’, ‘del’,’add’, ‘edit’),’users’ => array(‘@’)),array(‘deny’,’users’ => array(‘*’)),);}/*** 查看栏目*/{$categoryModel = Category::model();;$categoryInfo = $categoryModel->findAllBySql($sql);$this->render(‘index’, array(‘categoryInfo’=>$categoryInfo));}/*** 添加栏目*/{$categoryModel = new Category();if(isset($_POST[‘Category’])){$categoryModel->attributes = $_POST[‘Category’];if($categoryModel->save()){$this->redirect(array(‘index’));}}// p($_POST);$this->render(‘add’, array(‘categoryModel’=>$categoryModel));}/*** 编辑栏目*/){$categoryModel = Category::model();$categoryInfo = $categoryModel->findByPk($cid);// p($_POST);if(isset($_POST[‘Category’])){$categoryInfo->attributes = $_POST[‘Category’];if($categoryInfo->save()){$this->redirect(array(‘index’));}}$this->render(‘edit’, array(‘categoryModel’=>$categoryInfo));}/*** 删除栏目*/){$articleModel = Article::model();;$articleInfo = $articleModel->findBysql($sql);if(is_object($articleInfo)){Yii::app()->user->setFlash(‘hasArt’, ‘栏目下面有文章，请先删除文章’);$this->redirect(array(‘index’));}else {if(Category::model()->deleteByPk($cid)){$this->redirect(array(‘index’));}}}}
，多看书，看好书。
