Multiple Database Connection

We do this by creating a connections file in the models folder (connections.php):

PHP Code:

class Connections extends CI_Model {

 var $db='';

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

 $config['dbdriver'] = "mysqli";
 $config['dbprefix'] = "";
 $config['pconnect'] = FALSE;
 $config['db_debug'] = FALSE;
 $config['cache_on'] = FALSE;
 $config['cachedir'] = "";
 $config['char_set'] = "utf8";
 $config['dbcollat'] = "utf8_general_ci";
 $config['hostname'] = XXXXXXXXXXXXXXXXXXXX;
 $config['username'] = XXXXXXXXXXXXXXXXXXXX;
 $config['password'] = XXXXXXXXXXXXXXXXXXXX;
 $config['database'] = XXXXXXXXXXXXXXXXXXXX;

 $this->DB2=$this->load->database($config,TRUE);
 }

 function _db_two() {

 $config['dbdriver'] = "mysqli";
 $config['dbprefix'] = "";
 $config['pconnect'] = FALSE;
 $config['db_debug'] = FALSE;
 $config['cache_on'] = FALSE;
 $config['cachedir'] = "";
 $config['char_set'] = "utf8";
 $config['dbcollat'] = "utf8_general_ci";
 $config['hostname'] = XXXXXXXXXXXXXXXXXXXX;
 $config['username'] = XXXXXXXXXXXXXXXXXXXX;
 $config['password'] = XXXXXXXXXXXXXXXXXXXX;
 $config['database'] = XXXXXXXXXXXXXXXXXXXX;

 $this->DB2=$this->load->database($config,TRUE);
 }

} 


Then in our models, we have:

PHP Code:

class Orders extends Connections {

 function __construct() {
   // Call the Model constructor
   parent::__construct();
   $this->_db_one();
 }
public function adjust_cart($cart_key, $productid, $qty) {
    $this->DB2->where('sessionid', $cart_key); 
    $this->DB2->where('productid', $productid); 
    $this->DB2->update($this->tbl_order_storage, array('qty'=>$qty, 'date'=>time()));   
  }