I am looking at DooPHP and that i can't appear to locate using multiple database connections concurrently. Among the finest to possess multiple database objects and employ their techniques to question the DB. Now I I am carrying this out:

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

after which setDb again when I wish to use another DB. This really is retarded though. It's tough to determine what you are searching for within the API documentation too.

Any help here?

The answer was to get this done 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 employ it such as this within the controller:

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