Re: DataObject with Multiple Databases

There are settings for multiple DBs in the ini files. Look at http://pear.php.net/manual/en/package.database.db-dataobject.intro-configuration.php Configuration Options - Multiple Databases (optional) database_* string

    When you have multiple databases you can use the database_* to specify the DSN for each database

    Example 20-4. using multiple databases - database passwords

database_authentication = mysql://user:password@localhost/authentication

database_sales           = mysql://user:password@localhost/sales

table_* string

    When you have multiple databases you can use the table_* configuration variables to map individual tables to different databases, for example

    Example 20-5. using multiple databases - table settings

table_users     = authentication

table_saleslog = sales

table_stock     = sales

Steve Lianoglou wrote:

I'm wondering if (and how) it would be possible to use DB_DataObjects to access two different databases (not just separate tables, but separate databases with different usernames/pwords) "at the same time" (in the same application). It seems to me that the DataObject class stores it's db connection info in the $GLOBALS['_DB_DATAOBJECT']['CONFIG'] array and always hooks into that global variable to get the db name, pword, etc ... leaving no space to put connection info in for a second dbase ... is there a work around? thanks, -steve