Multiple Databases

[eluser]prakash[/eluser]
Hi guys i want to access multiple databases can anybody guide me...

There are 2 databases namely test11,test12 i want to give an drop down list of database names depending on the selected database name i should fetch the records from that particular database.

[eluser]Matalina[/eluser]
Here is how to set your database.php file: http://ellislab.com/codeigniter/user-gui...ation.html

Then in your model:

Code:

class Modelname_model extends CI_Model {

  private $default; // Default Database
  private $ideal; // Ideal Database
  private $main; // Main Database

  function __construct() {
    parent::__construct();
    // Load Databases
    $this->default = $this->load->database('default',TRUE);
    $this->ideal = $this->load->database('ideal',TRUE);
    $this->main = $this->load->database('main',TRUE);
  }

  function get_info() {
    $this->default->get('info'); // instead of $this->db->get('info');
  }
}