Codeigniter – multiple database connections

by

You should provide the second database information in `application/config/database.php´

Normally, you would set the default database group, like so:

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "root";
$db['default']['password'] = "";
$db['default']['database'] = "database_name";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = FALSE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";
$db['default']['swap_pre'] = "";
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

Notice that the login information and settings are provided in the array named $db['default'].

You can then add another database in a new array – let’s call it ‘otherdb’.

$db['otherdb']['hostname'] = "localhost";
$db['otherdb']['username'] = "root";
$db['otherdb']['password'] = "";
$db['otherdb']['database'] = "other_database_name";
$db['otherdb']['dbdriver'] = "mysql";
$db['otherdb']['dbprefix'] = "";
$db['otherdb']['pconnect'] = TRUE;
$db['otherdb']['db_debug'] = FALSE;
$db['otherdb']['cache_on'] = FALSE;
$db['otherdb']['cachedir'] = "";
$db['otherdb']['char_set'] = "utf8";
$db['otherdb']['dbcollat'] = "utf8_general_ci";
$db['otherdb']['swap_pre'] = "";
$db['otherdb']['autoinit'] = TRUE;
$db['otherdb']['stricton'] = FALSE;

Now, to actually use the second database, you have to send the connection to another variabel that you can use in your model:

function my_model_method()
{
  $otherdb = $this->load->database('otherdb', TRUE); // the TRUE paramater tells CI that you'd like to return the database object.

  $query = $otherdb->select('first_name, last_name')->get('person');
  var_dump($query);
}

That should do it.
The documentation for connecting to multiple databases can be found here: http://codeigniter.com/user_guide/database/connecting.html

More Related Contents:

  1. PHP – Change value y,n in database [closed]
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Error Code: 2013. Lost connection to MySQL server during query
  5. Do different databases use different name quote?
  6. MySQL Trigger after update only if row has changed
  7. Binary Data in MySQL [closed]
  8. MySQL Query to select data from last week?
  9. Using an Alias in SQL Calculations
  10. Can a table field contain a hyphen?
  11. Select last N rows from MySQL
  12. Adding a leading zero to some values in column in MySQL
  13. Auto Generate Database Diagram MySQL [closed]
  14. MySQL InnoDB foreign key between different databases
  15. View’s SELECT contains a subquery in the FROM clause
  16. MySQL : Multiple row as comma separated single row
  17. How to insert data to MySQL with auto-incremented column(field)?
  18. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  19. Case statement in MySQL
  20. Export a MySQL Database to SQLite Database
  21. Replace Into Query Syntax
  22. How to find out the MySQL root password
  23. Remote connect to clearDB heroku database
  24. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  25. How to display open transactions in MySQL
  26. MySQL foreign key to allow NULL?
  27. MySQL query, MAX() + GROUP BY
  28. What’s the best way to migrate a Django DB from SQLite to MySQL?
  29. Easiest way to copy a table from one database to another?
  30. How to store data with dynamic number of attributes in a database

Leave a Comment