[eluser]Nick Woodhead[/eluser]
Set up your db config file like this
$db['user']['hostname'] = 'localhost';
$db['user']['username'] = 'root';
$db['user']['password'] = '';
$db['user']['database'] = 'user';
$db['user']['dbdriver'] = 'mysql';
$db['user']['dbprefix'] = '';
$db['user']['pconnect'] = FALSE;
$db['user']['db_debug'] = TRUE;
$db['user']['cache_on'] = FALSE;
$db['user']['cachedir'] = '';
$db['user']['char_set'] = 'utf8';
$db['user']['dbcollat'] = 'utf8_general_ci';
$db['user']['swap_pre'] = '';
$db['user']['autoinit'] = FALSE;
$db['user']['stricton'] = FALSE;
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'data1';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$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'] = FALSE;
$db['default']['stricton'] = FALSE;
I autoload the 'database' library which loads the default database which will be used throughout your application. In your user model you can then set it up like this to be able to access both DB's
class User_model extends CI_Model {
private $db_user;
public function __construct() {
$this->db_user = $this->load->database('user', TRUE);
}
public function get_info() {
$user_query = $this->db_user->query($user_sql); //get info from user DB
$query = $this->db->query($sql); //get info from default DB - can be called in any model
}
}
Hope this helps!
