课Yii代码课件笔记Yii框架.pptVIP

?php if($this-beginCache(data, array( duration=3600, varyByParam=array(page), dependency=array( class=system.caching.dependencies.CDbCacheDependency, sql=select username from sw_user where user_id=1 ) ))){ ? public function filters() { return array( accessControl, array(system.web.widgets.COutputCache +detail, duration=3600, varyByParam=array(id), dependency=array( class=system.caching.dependencies.CDbCacheDependency, sql=select goods_price from sw_goods where goods_id=.$_GET[id], ), ), ); } 没有权限访问 Error 403 You are not authorized to perform this action. 没有此方法 Error 404 The system is unable to find the requested action sldks. 没有此控制器 Error 404 Unable to resolve the request usdfs. 控制器方法在使用的时候没有传递参数 Error 400 Your request is invalid. $connection = Yii::app()-db; $sql = select * from {{article}}; $command = $connection -createCommand($sql); $dataReader = $command - query(); 第一种获得数据方法 while(($row = $dataReader-read()) !== false){ var_dump($row); } 第二种获得数据方法 foreach($dataReader as $row){ var_dump($row); } 第三种获得数据方法 $rows = $dataReader-readAll(); var_dump($rows); 第四种获得数据方法 $goods_info = $goods_reader-read(); //获得一条记录 var_dump($goods_info); 直接使用queryAll()方法获得全部结果 $rows = $command - queryAll(); var_dump($rows); 使用queryRow()方法直接返回第一条结果 $row = $command - queryRow(); var_dump($row); 使用queryColumn()方法是自己返回第一列结果 $column = $command -queryColumn(); var_dump($column); 执行更新语句 $sql = insert into {{article}} values (null,aa,aa,10,now(),now()),(null,bb,bb,10,now(),now()); $command = $connection - createCommand($sql); $rowCount = $command - execute(); echo $rowCount; //返回受影响结果数目2 $sql = update {{article}} set article_title=dd where article_id2; $command = $connection - createCommand($sql); $rowCount = $command - execute(); echo $rowCount; //返回受影响结果数目