Invision Power Services

Help - Search - Members - Calendar

Full Version: External DB

Invision Power Services > Community Forums > Community Web Design and Coding

simpsoholic

Apr 17 2006, 02:31 AM

Can i use the normal IPB registration page to insert the user into a different DB?

Grant

Apr 17 2006, 04:07 AM

IPS Beyond would probably be better suited to answer that question.

http://www.ipsbeyond.com

Michael Boutros

Apr 17 2006, 05:26 AM

Do you mean it inserts into two different databases? Or into a database hosted on another server/account?

simpsoholic

Apr 17 2006, 05:55 AM

i mean that it inserts in into a different DB hosted on the same server

simpsoholic

Apr 18 2006, 10:34 AM

Or 2 Databases, it doesnt really matter

marcele

Apr 18 2006, 12:38 PM

QUOTE(simpsoholic @ Apr 16 2006, 08:31 PM)

Can i use the normal IPB registration page to insert the user into a different DB?

Yes this is easy.. just create a different db object:

E.G.

CODE

//connect to a remote db
$this->ipsclass->RDB = new db_driver();
$this->ipsclass->RDB->obj['sql_database']         = $this->ipsclass->vars['remote_database'];
$this->ipsclass->RDB->obj['sql_user']                = $this->ipsclass->vars['remote_user'];
$this->ipsclass->RDB->obj['sql_pass']               = $this->ipsclass->vars['remote_pass'];
$this->ipsclass->RDB->obj['sql_host']               = $this->ipsclass->vars['remote_host'];
$this->ipsclass->RDB->obj['sql_tbl_prefix']         = $this->ipsclass->vars['remote_tbl_prefix'];
$this->ipsclass->RDB->obj['use_shutdown']         = 0;
$this->ipsclass->RDB->obj['force_new_connection'] = 1;
$this->ipsclass->RDB->connect();

Then do your inserts with the new object ..

Then call this to close your remote connection.

CODE

$this->ipsclass->RDB->close_db();

simpsoholic

Apr 19 2006, 08:42 AM

Sorry, im a complete PHP newb...
Where do i put this?

marcele

Apr 19 2006, 12:14 PM

QUOTE(simpsoholic @ Apr 19 2006, 02:42 AM)

Sorry, im a complete PHP newb...
Where do i put this?

If you are new to PHP then you probably shouldn't try inserting data into a remote db ... I would just hire someone to do it

simpsoholic

Apr 19 2006, 10:00 PM

Dont have the money

simpsoholic

Apr 20 2006, 11:02 AM

But thanks very much for your suggestions

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.