db:
//This service returns a MySQL database $di->set('dbMaster', function() { return new \Phalcon\Db\Adapter\Pdo\Mysql(array( "host" => "localhost", "username" => "", "password" => "", "dbname" => "" )); }); //This service returns a PostgreSQL database $di->set('dbSlave', function() { return new \Phalcon\Db\Adapter\Pdo\Mysql(array( "host" => "localhost", "username" => "", "password" => "", "dbname" => "" )); });
public function initialize() { $this->setConnectionService('dbMaster'); //or $this->setConnectionService('dbSlave'); }
这是给出来的案例,在实际代码环境,用的是默认生成的模板文件。
修改配置文件
'database' => array( 'adapter' => 'Mysql', 'host' => '127.0.0.1', 'username' => 'root', 'password' => 'toor', 'dbname' => 'db1', 'charset' => 'utf8', ), 'db2' => array( 'adapter' => 'Mysql', 'host' => '127.0.0.1', 'username' => 'root', 'password' => 'toor', 'dbname' => 'db2', 'charset' => 'utf8', ),
$di->set('db', function () use ($config) { return new DbAdapter($config->database->toArray()); }); $di->set('db2', function () use ($config) { return new DbAdapter($config->db2->toArray());
在model中使用时,
class user extends Model { public function initialize() { $this->setConnectionService('db2'); } }