'db' => (defined('DB_CONNECTION') ? array(
'connectionString' => DB_CONNECTION,
'username' => DB_USER,
'password' => DB_PWD,
'charset' => 'utf8',
'emulatePrepare' => true,
'enableParamLogging' => true,
'schemaCachingDuration' => 3600, //cache table schema
) : array()),
//member DB connection
'db_member' => (defined('DB_CONNECTION_MEMBER') ? array(
<span style="color:#FF6666;"> 'class'=> 'CDbConnection' , </span>
'connectionString' => DB_CONNECTION_MEMBER,
'username' => DB_USER_MEMBER,
'password' => DB_PWD_MEMBER,
'charset' => 'utf8',
'emulatePrepare' => true,
'enableParamLogging' => true,
'schemaCachingDuration' => 3600, //cache table schema
) : array()),
可以有不同的方法选择:
1、Yii::app()->db_member->createCommand(‘SELECT * FROM tbl_user’);
2、在模型类中重写getDbConnection()方法:
//Point.php
class Point extends CActiveRecord {
public function getDbConnection() {
return Yii::app()->db_member; //默认为Yii::app()->db;
}
}