Codeigniter - how do I update my database config settings dynamically?

Question

I want to change some database settings for one part of my program.

In my setup the databse class is autoloaded with a config which looks like this

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '****';
$db['default']['database'] = 'database';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$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;

At one part of the script I want to change the value of $db['default']['keyname'] , how can I do this?

Brendan · Accepted Answer · 2012-10-24 15:09:13Z

You should be adding another set of credentials instead of changing the existing ones dynamically:

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

You can load this other database by doing:

$another_db = $this->load->database('another_db', TRUE);

Then use it like normal database driver:

$another_db->select();
...etc

Svetoslav · Accepted Answer · 2012-10-24 11:30:33Z

2

There is how class > check it http://codeigniter.com/user_guide/libraries/config.html

How ever you can NOT change db connection settings.... They are loaded long before your configs..

answered Oct 24, 2012 at 11:30

Svetoslav

4,6862 gold badges30 silver badges43 bronze badges

Comments

Ruu Mouat · Accepted Answer · 2012-10-24 11:56:05Z

0

Slightly hacky, but you could add something like this to system/database/DB_driver.php (I've used db password change as an example):-

public function update_pw($value) {
  $this->password = $value;
}

Then in your project, do

$this->db->update_pw('example');
$this->db->reconnect();

Depending on specifically what you want to change in the config - and also more importantly, why you want to change it - this may or may not be the best option.

answered Oct 24, 2012 at 11:56

Ruu Mouat

1151 silver badge7 bronze badges

Comments

Marco Monteiro · Accepted Answer · 2012-10-26 14:31:38Z

0

Also you can always use a Global var. Normally I always have 2 databases in place. One for production and one for development. You just check that var to load one or the other.

That concept can be used to load one database in one part of your application and other in other part. However, I would go with the built in solution like Brendan pointed out.

answered Oct 26, 2012 at 14:31

Marco Monteiro

395 bronze badges

Collectives™ on Stack Overflow

Codeigniter - how do I update my database config settings dynamically?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related