switch the default database on the fly |
[eluser]Dave Rau[/eluser]
Often I have the need to change databases but from within the same CI app; what methods do you folks use to swap databases (and/or tables) on the fly? Is there a shortcut I can use to specify multiple database names, but keeping the same connection settings like server name, user/pass, etc.?
[eluser]GSV Sleeper Service[/eluser]
you'll have to set up each db in the database config using 'groups' - http://ellislab.com/codeigniter/user-gui...ation.html
[eluser]Dave Rau[/eluser]
What if all of the config settings are the same except the database name? Is there some shorthand I can use for that? Code: $db['default']['hostname'] = "localhost"; I want the other_db group to inherit all of the properties of the default group except database name; any suggestions on how to do that?
|
Welcome Guest, Not a member yet? Register Sign In |