Question

I m making a website with two different databases. Let s say one is DB1, and the other is DB2. I ve set up my database.php in the config folder, so they each have the correct host/password/username/database etc with db[ DB1 ][ hostname ] and the other db[ DB2 ][ hostname ] etc, so I m pretty sure I ve got that part right.

According to CodeIgniter docs, I m supposed to do $this->load->database( DB1 ) to get that one to work within my model. First, I put it in my constructor for my model, and it didn t work. Then I tried putting that line as the first line of every function in the model, and that didn t work. I m still getting this error:

Error Number: 1146

Table  DB2.stores  doesn t exist

When I m trying to use DB1, and have done $this->load->database( DB1 ) as the first line of the model s function. Does anyone know what I m doing wrong? Thanks!

Answer 1

There are a couple of caveats I ran into when I last tried to do that.

In your model constructor, load DB1 and DB2 as

$this->DB1=$this->load->database( DB1 ,true) //<-- notice the true parameter
$this->DB2=$this->load->database( DB2 ,true) //<-- notice the true parameter

and then use $this->DB1->get()->where()->result_array() etc.etc.

Caveat 2
make sure persistent connections are off... they are on by default in CI

$db[ DB2 ][ pconnect ] = FALSE;

and

$db[ DB2 ][ pconnect ] = FALSE;

in your application/config/database.php file

hope that helps...

友情链接