DontheCat Posted August 28, 2005 Share Posted August 28, 2005 have this site where I've installed phpBB-Forum, B2evo blogs, A GB and PhpLinks. All of them have their own databases. I also have a Form where members can register. The Form has Login and PassWord entry fields and the values are stored in the Member master table in a different databse. Is there someway I could also populate the Login/Password of all the applications on submission of the above form? Would the member then be able to be "Logged In" while he accesses the different areas across the site? Or would it need a session varaiable or something like that? Thanks for the support Quote Link to comment https://forums.phpfreaks.com/topic/2472-one-form-to-multiple-databases/ Share on other sites More sharing options...
ChrisDarl Posted October 27, 2005 Share Posted October 27, 2005 Im not sure weather you're allowed to edit their code? Might wanna check it out. Some bits of code i used years didnt allow you to. But it could be done by using one table containing all the users, and instead of calling the users from the individual databases call it from the one table. Chris Quote Link to comment https://forums.phpfreaks.com/topic/2472-one-form-to-multiple-databases/#findComment-9190 Share on other sites More sharing options...
jamiemcconnell Posted October 27, 2005 Share Posted October 27, 2005 if all of those programs have databases, then i dont see why you dont just loop though each database adding the username/password and any other information to the appropiate tables. Quote Link to comment https://forums.phpfreaks.com/topic/2472-one-form-to-multiple-databases/#findComment-9192 Share on other sites More sharing options...
ChrisDarl Posted October 27, 2005 Share Posted October 27, 2005 that would be using database space that is not required, and will also slow down the loading of the pages slightly, would it not? Chris Quote Link to comment https://forums.phpfreaks.com/topic/2472-one-form-to-multiple-databases/#findComment-9197 Share on other sites More sharing options...
jamiemcconnell Posted October 28, 2005 Share Posted October 28, 2005 Thats true, but the time taken to query the database is extremly fast, and it would only be happening once per user registration. If you did want to have a seperate table for members then you would have to go through each program edditing the code, and i can imaagine there would be alot. Quote Link to comment https://forums.phpfreaks.com/topic/2472-one-form-to-multiple-databases/#findComment-9209 Share on other sites More sharing options...
DontheCat Posted October 28, 2005 Author Share Posted October 28, 2005 jamie, your solution is the one I tried after I posted this query here. It works. meaning the DBs get populated alright. But the problem is that the session variable created by my regular Login page does not match the other programs' authentication scripts. I'm forced to change lotsa code especially in phpBB. Also, changing the login auth script to read from another table apart its own created some other problems. What I've done is ask the Registering Members to use the same credentials and register separately in each application. Actually, I started developing another time-bound site in the meanwhile and so the earlier one is in temporary cold-storge :-) Thanks Chris, jamie for the suggests. I'll keep this post updated as I work on a solution. Ideas and more suggestions welcome... Quote Link to comment https://forums.phpfreaks.com/topic/2472-one-form-to-multiple-databases/#findComment-9210 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.