referring wrong db while using multiple db connections in codeigniter

Question

I loaded two different database in Codeigniter controllers _contruct in series. While I call the second database in action it works fine but first loaded db is referring second loaded db.

function __construct(){
  parent::__construct();  

 $this->liveDB = $this->load->database('liveDB', TRUE);
 $this->metricsDB = $this->load->database('metricsDB', TRUE);
}

My Action

$this->metricsDB->query("") // working good

$this->liveDB->query("") // referring database metricsDB

Note : If I change the order in __construct it works opposite

do you have your database set to autoload, if so what happens when you turn autoload database off? — allen213
– allen213, Commented Aug 14, 2013 at 7:54
@allen213: I tried removing 'database' from autoload. Still same — Gowri
– Gowri, Commented Aug 14, 2013 at 9:00
Have you put the right config entries for each in the database.php config file? — Nishant
– Nishant, Commented Aug 14, 2013 at 9:10
I'd imagine he has, as he states: " If I change the order in __construct it works opposite". — allen213
– allen213, Commented Aug 14, 2013 at 9:13
Have you tried any of the advice here : stackoverflow.com/questions/634291/… ? — allen213
– allen213, Commented Aug 14, 2013 at 9:13

Kinko182 · Accepted Answer · 2014-06-26 15:41:33Z

1

This could be caused by persistent connect, set

$db['livDB']['pconnect'] = FALSE;
$db['metricsDB']['pconnect'] = FALSE;

in your database config see if that helps

answered Jun 26, 2014 at 15:41

Kinko182

111 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

Boris · Accepted Answer · 2013-08-14 08:23:14Z

0

Have a look at CI User guide:

If you need to connect to more than one database simultaneously you can do so as follows:

$liveDB = $this->load->database('liveDB', TRUE);
$metricsDB = $this->load->database('metricsDB', TRUE);

Then you can use:

$metricsDB->query();
$metricsDB->result();

answered Aug 14, 2013 at 8:23

Boris

8021 gold badge10 silver badges13 bronze badges

1 Comment

Boris Over a year ago

Make sure a database is not set to autoload -> application/config/autoload.php. As @allen213 mentioned.

Collectives™ on Stack Overflow

referring wrong db while using multiple db connections in codeigniter

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related