how use two database

[eluser]minhbu[/eluser]
i want to use two database for my project. How do i use ?
help me ? thanks

[eluser]pistolPete[/eluser]
Connecting to multiple databases

[eluser]Banana Man[/eluser]
Edit database.php in config folder so you have two different sets.

Code:

$db['database 1']['hostname'] = "localhost";
$db['database 1']['username'] = "";
$db['database 1']['password'] = "";
$db['database 1']['database'] = "";
$db['database 1']['dbdriver'] = "";
$db['database 1']['dbprefix'] = "";
$db['database 1']['pconnect'] = TRUE;
$db['database 1']['db_debug'] = TRUE;
$db['database 1']['cache_on'] = FALSE;
$db['database 1']['cachedir'] = "";
$db['database 1']['char_set'] = "utf8";
$db['database 1']['dbcollat'] = "utf8_general_ci";

$db['database 2']['hostname'] = "localhost";
$db['database 2']['username'] = "";
$db['database 2']['password'] = "";
$db['database 2']['database'] = "";
$db['database 2']['dbdriver'] = "";
$db['database 2']['dbprefix'] = "";
$db['database 2']['pconnect'] = TRUE;
$db['database 2']['db_debug'] = TRUE;
$db['database 2']['cache_on'] = FALSE;
$db['database 2']['cachedir'] = "";
$db['database 2']['char_set'] = "utf8";
$db['database 2']['dbcollat'] = "utf8_general_ci";

Then when accessing them in the model use this:-

Code:

$DB1 = $this->load->database('database 1', TRUE);
$DB2 = $this->load->database('database 2', TRUE);

database 1 and database 2 are just for example.


Do this help ya ?