1.yii數據查詢

a.使用CDbCriteria數據查詢

$attributes = array();

$criteria = new CDbCriteria;

//$criteria->select='amount'; ?

$criteria->condition='user_id=:user_id';

$criteria->params=array(':user_id'=>18889195);

$DwCouponModel = new Coupon();

$cla***esult = $DwCouponModel->findAllByAttributes($attributes,$criteria);

//返回一個數組，每個數組元素為一個對象

if(count($cla***esult)>0){

foreach($cla***esult as $key => $row) {

$returnResult[$key] = $row->getAttributes();

}

}

//將數組元素轉換成數組

b.使用createCommand數據查詢

$user = Yii::app()->db->createCommand()

? ? ? ? ->select('user_id,sn')

? ? ? ? ->from('dw_coupon')

? ? ? ? ->where('user_id=:user_id', array(':user_id'=>$this->user_id))

? ? ? ? ->queryAll();

? ? ? ? queryAll、execute、queryRow、queryColumn

2.目錄結構

model:/protected/lib/models/Coupon.php(優惠券對應dw_coupon表)

view:/views/newuser/main/XXX.tpl

controller:/protected/modules/newuser/controllers/MainController.php

service:/protected/lib/services/

class:/protected/lib/classes/

3.主從數據庫的切換

Yii::app()->db->switchToMaster();

? ? ? ? Yii::app()->db->switchToSlave();

4.yii拓頁面

controller:

$this->user_id = xxx;

$returnResult = AccountService::getInstance()->getAccountInfo($this->user_id);

$this->render("test",$returnResult);

view:

<{$key.key.key}>

5.方法不存在是執行__call方法

執行到/itzlib/yiiext/ItzBaseService.php->getDataFromCache()通過第二個參數$method識別getSystem、getBorrow等