i searched the forums and didnt find a thread about this even though im sure there would be one
someone asked me if i could do this for them:
he runs two sites that are membership required and hes getting a third site and he wants when people register on one to be registered on all three...
first off i know that if more than one mysql server runs off localhost then i dont think it would be possible, but if only one did then users could register from the site containing that one.
so if none or one of them runs on localhost could i connect to the database of site A from site B?
I dont see why not but since i dont have his ftp+sql details yet i cant test and i dont have multiple sites of my own to test
connecting to offsite databases
Moderator: General Moderators
-
thegreatone2176
- Forum Contributor
- Posts: 102
- Joined: Sun Jul 11, 2004 1:27 pm
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
it's possible in the connect function of the database architecture you use. However, most hosts disallow access from outside localhost to the database. So you will very likely need a script on the all the servers for each of them to access each other, to perform selections, insertions and updates. I'd strongly suggest using strong encryption to pass information.