Temporarily change DB
Development and Programming
I’m trying to save some data to a separate DB than EE uses. I’m not sure how to do this, and I bet there’s probably an easy way I can change the $DB parameters.
So basically what i want to do is this:
global $DB; {!– change DB values to another DB –}
$my_query = $DB->query(“INSERT INTO table in another database…”);
{!– restore DB values from before –}
$my_query = $DB->query(“SELECT from EE database…”);
Moved to Plugins: Technical Assistance
This is more of a general PHP programming question than a technical support question.
I’ve always found it easier to keep all the tables I need in the same database so I can just use global $DB.
How are you going to use this code?
I have several EE installs that need to save to a single DB for some form results so they are all in the same place. They each use a different DB, so it would be a pain to have to compile the form submissions across 10 databases. So I want them all saved together. I have my PHP broken out into a plugin just to keep my templates a little cleaner.
It’s a general PHP question, but its also working with the EE framework, so that’s why I came here.
I figured it out. I just changed the database and changed it back afterwards. I was over-complicating things.
Thanks
Glad to hear it. /Don’t hesitate to post again if needed.