How to Manage Multiple Database Connections in CodeIgniter?

Multiple database connections in Codeigniter

Codeigniter is a popular PHP framework that provides a simple and convenient way to connect to and interact with multiple databases. This can be useful in scenarios where you need to access data from different databases or perform complex queries that span multiple databases.

How to setup multiple database connections in Codeigniter

To setup multiple database connections in Codeigniter, you will need to add the following lines of code to your application's config/database.php file.

$db['default']['hostname'] = 'your_hostname';
$db['default']['username'] = 'your_username';
$db['default']['password'] = 'your_password';
$db['default']['database'] = 'your_database';
$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['otherdb']['hostname'] = 'other_hostname';
$db['otherdb']['username'] = 'other_username';
$db['otherdb']['password'] = 'other_password';
$db['otherdb']['database'] = 'other_database';
$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';

In the above example, we have created two database connections. The first connection is named "default" and is used to connect to the default database that is defined in your application. The second connection is named "otherdb" and is used to connect to another database.

How to use multiple database connections in Codeigniter

Once you have setup multiple database connections, you can use them in your models and controllers to access data from the different databases. For example, the following code shows how to use the "otherdb" connection in a 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);
}

This code will load the "otherdb" connection into a variable called $otherdb. The get() method is then used to execute a query against the "person" table in the "otherdb" database.

Conclusion

Multiple database connections can be a useful feature in Codeigniter, especially in applications that need to access data from different databases or perform complex queries that span multiple databases.

The above is the detailed content of How to Manage Multiple Database Connections in CodeIgniter?. For more information, please follow other related articles on the PHP Chinese website!