[eluser]getSurreal[/eluser]
I'm looking for some design advice to my application. My app connects to another applications database to run reports from it. There can be multiple instances of that application and I want it to be user selectable which one they are connecting to and I want a admin interface to define the different databases to connect to. I don't want the user to have to edit the php file to define all the database connections.
My thoughts are the best solution is to store the database connection settings in my app's database and then write something that queries that and generates the standard codeigniter database connection settings for each user defined database connection (although I'm not sure how to write such code just yet)
Thoughts and suggestions?
Thanks.