Using multiple databases with DooPHP

Question

I'm checking out DooPHP and I can't seem to find how to use multiple database connections simultaneously. I just want to have multiple database objects and use their methods to query the DB. Now I I'm doing this:

Doo::db()->setDb($dbconfig, $config['APP_MODE']);
Doo::db()->query('.......');

and then setDb again when I want to use another DB. This is retarded though. It's very difficult to find what you're looking for in the API documentation as well.

Any help here?

have you tried to specific the database name into the sql ? assuming all database are in the same host, listening on same port, same user has equally privileges on both databases — ajreal, Jun 17 '11 at 14:47

score 0 · Accepted Answer · answered Jun 18 '11 at 13:45

The solution was to do this in index.php:

Doo::loadCore('db/DooSqlMagic');
$db = new DooSqlMagic;
$db->setDb($dbconfig, 'db'.$config['APP_MODE']);
$db->connect();

$db2 = new DooSqlMagic;
$db2->setDb($dbconfig, 'db2'.$config['APP_MODE']);
$db2->connect();

This in db.conf.php:

$dbconfig['dbdev'] = array('localhost', 'db', 'root', '', 'mysql', true, 'collate'=>'utf8_unicode_ci', 'charset'=>'utf8');
$dbconfig['dbprod'] = array('localhost', 'db', 'root', '', 'mysql', true, 'collate'=>'utf8_unicode_ci', 'charset'=>'utf8');

$dbconfig['db2dev'] = array('localhost', 'db2', 'root', '', 'mysql', true, 'collate'=>'utf8_unicode_ci', 'charset'=>'utf8');
$dbconfig['db2prod'] = array('localhost', 'db2', 'root', '', 'mysql', true, 'collate'=>'utf8_unicode_ci', 'charset'=>'utf8');

And use it like this in the controller:

global $db;
global $db2;
$db->query('.......');
$db2->query('......');

Using multiple databases with DooPHP

1 Answers1