General Questions/New to Joomla! 3.x • Re: joomla multiple database connection and join query

Easy, use:

Code:

$option['[[[drive]]]'] = 'mysql';

$option['host'] = 'localhost';

$option['user'] = 'db1_user';

$option['password'] = 'testing';

$option['database'] = 'db1';

$option['prefix'] = 'joomla_';

$db1 = JDatabase::getInstance( $option );



$option['[[[drive]]]'] = 'mysql';

$option['host'] = 'localhost';

$option['user'] = 'db2_user';

$option['password'] = 'testing';

$option['database'] = 'db2';

$option['prefix'] = 'joomla_';



$db2 = JDatabase::getInstance( $option );

Statistics: Posted by sovainfo — Sun Apr 12, 2015 4:42 am

---

via Joomla! http://ift.tt/1Dz8Ol4