CMS Made Simple Forums

Posted: **Wed Jul 17, 2019 7:44 am**

I want to use data from an alternative database in a UDT in CMSMS 2.2.10.

I have tried to connect it like this:

$alternativedb = array();
$alternativedbhost = '***';
$alternativedbuser = '***';
$alternativedbpswd = '***';
$alternativedbdbsn = '***';
$alternativedb = ADONewConnection('mysqli', 'pear:date:extend');
$alternativedb->Connect($alternativedbhost,$alternativedbuser,$alternativedbpswd,$alternativedbdbsn);
print_r($alternativedb);

However, the printed variable shows the information of the CMSMS database.

How can I connect to the other database?

Posted: **Wed Jul 17, 2019 11:57 am**

use \CMSMS\Database\Connection::Initialize();
you must provide it a \CMSSM\Database\ConnectionSpec object with your connection details.

Posted: **Wed Jul 17, 2019 12:23 pm**

Thank you Robert, this is what I needed.

CMS Made Simple Forums

How to connect to a second database

How to connect to a second database

Re: How to connect to a second database

Re: How to connect to a second database