Welcome Guest, Not a member yet? Register   Sign In
a little advice in connecting to multiple database
#1

[eluser]xeroblast[/eluser]
i had already checked the previous post regarding this matter and this ( http://ellislab.com/forums/viewthread/224254/ ) is the nearest answer to an advice i wanted.

my current set-up :
my db1 is access through the default connection. the users listed in db1 have different settings in connecting to the database. e.i. user1 db = db2 while user2 db = db3.. user1 can only see db1 & db2 while user2 can only see db1 & db3. db2 & db3 have the same tables and fields. so i want to use the same model in different connection without to call the config setting in every model i load.

controller: current and working
Code:
function index() {
$this->load->model('user_model');
$this->load->model('other_model');
$data['somedata'] = $this->user_model->get_data();
$data['otherdata'] = $this->other_model->get_data();
$this->load->view('html', $data);
}
user_model: current and working
Code:
var user_db;
function __construct() {
$config = $this->db1_model->get_user_db_configuration(); // return the config array and autoloaded
$this->user_db = $this->load->database( $config, true );
}
function somefunction() {
$query = $this->user_db->get('sometable');
return $query->result();
}
other_model: current and working
Code:
var user_db;
function __construct() {
$config = $this->db1_model->get_user_db_configuration(); // return the config array and autoloaded
$this->user_db = $this->load->database( $config, true );
}
function somefunction() {
$query = $this->user_db->get('sometable');
return $query->result();
}

my current problem is when loading multiple models in the controller which every model calls the same user configuration. i wanted to use the model to autoconnect to the database using via the 3rd parameter.
Code:
function index() {
$config = $this->db1_model->get_user_db_configuration();
$this->load->model('user_model','',$config);
$this->load->model('other_model','',$config);
...
}
but its not working. it is still using the default db configuration which is the db1.
i want it that so i only have to call
Quote:$this->db1_model->get_user_db_configuration()
only once.

thanks in advance.




Theme © iAndrew 2016 - Forum software by © MyBB