clowes Posted March 24, 2010 Share Posted March 24, 2010 Hello. I am looking for some advice on the best way to achieve what I am looking for. I have various websites. 2 or 3 utilize wordpress as a CMS, and use the ExecPHP plugin to execute my PHP content. The others do not use any CMS. I want to setup a system such that a user can register on any ONE site, and that registration is valid for every site in my network. My idea was a separate database for user information. I could then switch between each sites database and the 'users' database. This is extremely complicated with wordpress however, as I cannot go through and change every wordpress query to include the database which it is querying. Is the above viable? If not does anyone have a better suggestion to achieve the wanted results. Thanks Link to comment https://forums.phpfreaks.com/topic/196392-connecting-to-multiple-databases/ Share on other sites More sharing options...
ignace Posted March 24, 2010 Share Posted March 24, 2010 Select one of the 3 websites as your base and authorize all users against the base database. Link to comment https://forums.phpfreaks.com/topic/196392-connecting-to-multiple-databases/#findComment-1031169 Share on other sites More sharing options...
clowes Posted March 24, 2010 Author Share Posted March 24, 2010 Could you perhaps elaborate on that further. There are in fact 10 websites. 3 are wordpress. I want to be able to have a database for the content of each site, and then a database of users which is utilized by all sites. Thanks Link to comment https://forums.phpfreaks.com/topic/196392-connecting-to-multiple-databases/#findComment-1031179 Share on other sites More sharing options...
ignace Posted March 24, 2010 Share Posted March 24, 2010 Select one of those 10 websites which will become the base for authentication it's best to select the one with the easiest/best coding as you will have to make some adjustments so that all websites authenticate with the same database. Research how each application identifies a user as logged-in and make sure your modifications match this. Link to comment https://forums.phpfreaks.com/topic/196392-connecting-to-multiple-databases/#findComment-1031222 Share on other sites More sharing options...
clowes Posted March 24, 2010 Author Share Posted March 24, 2010 Apologies. I appreciate the help, but please can you outline what you are suggesting in the most simple way possible as what is written above makes little to no sense as a viable idea. Thanks Link to comment https://forums.phpfreaks.com/topic/196392-connecting-to-multiple-databases/#findComment-1031354 Share on other sites More sharing options...
clowes Posted March 25, 2010 Author Share Posted March 25, 2010 Does anybody have any suggestions? Thanks Link to comment https://forums.phpfreaks.com/topic/196392-connecting-to-multiple-databases/#findComment-1031643 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.