Jump to content

One Form to Multiple Databases


Recommended Posts

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

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.