[eluser]Uplift[/eluser]
I can't seem to get multiple database connections to work. where am i going wrong?
i followed the steps here;
http://ellislab.com/codeigniter/user-gui...cting.html
Code:
$active_group = 'default';
$active_record = TRUE;
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'username';
$db['default']['password'] = 'password';
$db['default']['database'] = 'database1';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = FALSE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
$db['forum']['hostname'] = 'localhost';
$db['forum']['username'] = 'username';
$db['forum']['password'] = 'password';
$db['forum']['database'] = 'database2';
$db['forum']['dbdriver'] = 'mysql';
$db['forum']['dbprefix'] = '';
$db['forum']['pconnect'] = FALSE;
$db['forum']['db_debug'] = FALSE;
$db['forum']['cache_on'] = FALSE;
$db['forum']['cachedir'] = '';
$db['forum']['char_set'] = 'utf8';
$db['forum']['dbcollat'] = 'utf8_general_ci';
$db['forum']['swap_pre'] = '';
$db['forum']['autoinit'] = TRUE;
$db['forum']['stricton'] = FALSE;
and then in controller:
Code:
$DB1 = $this->load->database('default', TRUE);
$DB2 = $this->load->database('forum', TRUE);
$query = $DB2->query("SELECT * FROM post WHERE postid = 1");
returns:
Code:
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: DB2
Filename: controllers/blog.php
Line Number: 20
Fatal error: Call to a member function query() on a non-object in /home/ubuzznet/public_html/ubuzz/application/controllers/blog.php on line 20
