FUDforum: comp.lang.php » Copying data between databases

Home » Imported messages » comp.lang.php » Copying data between databases

Show: Today's Messages :: Polls :: Message Navigator

Re: Copying data between databases [message #174779 is a reply to message #174777]

Thu, 07 July 2011 04:56

The Natural Philosoph
Messages: 993
Registered: September 2010

Karma:

Senior Member

Sloan wrote:
> Hi all,
>
> I'm a bit new to PHP, but have been programming in other languages for
> quite a while. I'm pretty good a SQL, including MySQL.
>
> Here's my question:
>
> How do I connect to two databases (on the same server) to use an INSERT
> .... ON DUPLICATE KEY UPDATE in PHP were the source table in one
> database, and the destination table is in another?
>
> I've written the SQL statement with explicit db.table.field references
> so I think I can use mysql_query, but which link do I use, or how can I
> pass both links?
>
> Thanks in advance!
>
> Sloan
>
>
open the one database get the data,. open the other, insert the data.

you can have two database handles open together, you know.

i.e
$link = mysql_connect($locale_remote_database, 'web-user', '2123utr789');
$link2 = mysql_connect($locale_database, 'other-web-user', 'abc0987');

Just use the different handles in the select and insert statements.

Report message to a moderator

[Message index]

		Copying data between databases By: Sloan on Thu, 07 July 2011 04:41
		Re: Copying data between databases By: Mick Gurling on Thu, 07 July 2011 04:51
		Re: Copying data between databases By: Sloan on Thu, 07 July 2011 05:00
		Re: Copying data between databases By: The Natural Philosoph on Thu, 07 July 2011 06:09
		Re: Copying data between databases By: The Natural Philosoph on Thu, 07 July 2011 04:56
		Re: Copying data between databases By: alvaro.NOSPAMTHANX on Thu, 07 July 2011 06:28

Previous Topic:	multi-page form
Next Topic:	Earn $24.00 per Sign-Up!...Get Paided on all FREE MEMBERS!....{Sign-Up FREE}

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 04:15:26 GMT 2024

Total time taken to generate the page: 0.03772 seconds