若想访问多个数据库,首先需要在settings.php中,配置好多个数据库:
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'tianjinyizhuan',
'username' => 'tianjinyizhuan',
'password' => 'tianjinyizhuan',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
),
),
'commons' =>
array (
'default' =>
array (
'database' => 'commons',
'username' => 'commons',
'password' => 'commons',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
),
),
);
然后,在代码中访问别的数据库:
db_set_active('commons'); // 切换到commons定义的数据库
// 操作数据库commons
db_set_active(); //转到默认数据库