Previous Thread
Next Thread
Print Thread
Rate Thread
Session variable to connect two databases? #318259
10/06/2009 7:55 PM
10/06/2009 7:55 PM
Joined: Dec 2001
Posts: 84
Issaquah, WA
Bill B Offline OP
Power User
Bill B  Offline OP
Power User
Joined: Dec 2001
Posts: 84
Issaquah, WA
I might have a small job for someone. I have a second MySQL membership database that people login to. Once they are validated there, what would it take for me to send them to our UBB Forum so that they don't have to log in a second time?


Bill Barker
Issaquah, Wa
Sponsored Links
Re: Session variable to connect two databases? [Re: TylerWells] #318437
01/06/2010 11:13 PM
01/06/2010 11:13 PM
Joined: Dec 2001
Posts: 84
Issaquah, WA
Bill B Offline OP
Power User
Bill B  Offline OP
Power User
Joined: Dec 2001
Posts: 84
Issaquah, WA
Okay. Here it goes..... (DB = database)

DB One is MySQL. ID and passwords are stored in "open" format.
Session variable is used. This is a membership database.

DB Two is Threads MySQl db. Naturally passwords are encrypted.

So... my goal is to use "DB One" to authenticate members and then pass them to "DB Two" using the session variable (?) and possibly the member ID in order to link to their Threads account.

So.... the member ID is unique in DB One... and I assume that I need to add a new table (?) to the Threads DB to match membership to an identifier in the Forum account?

Your thoughts?


Bill Barker
Issaquah, Wa
Re: Session variable to connect two databases? [Re: Bill B] #322749
03/30/2017 11:07 PM
03/30/2017 11:07 PM
Joined: Mar 2017
Posts: 1
Doha, Qatar
A
AbdulRaheem Offline
Lurker
AbdulRaheem  Offline
Lurker
A
Joined: Mar 2017
Posts: 1
Doha, Qatar
Ohh wow a lot have been changed now. It's a really too old post to reply but just for information sake
4.5.2 Creating and Configuring a New Project

Many web sites feature the facility for the user to create a user account. They can then log into the web site and enjoy a personalized experience. This requires that the developer creates database tables to store user information, along with code to gather and process this data. This represents a burden on the developer, and there is the possibility for security issues to creep into the developed code. However, ASP.NET 2.0 introduced the Membership system. This system is designed around the concept of Membership, Profile and Role Providers, which together provide all of the functionality to implement a user system, that previously would have to have been created by the developer from scratch.

Reference Link : https://dev.mysql.com/doc/connector-net/en/connector-net-simple-membership-tutorial-creating.html


Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need for Migration, Security or Coding Services.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
· Interserver.net
Visit Us on Facebook
Member Spotlight
Mark_S
Mark_S
UK
Posts: 309
Joined: November 2003
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,428
Posts293,394
Members13,779
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,929
Greg Hard 5,533
Top Posters(30 Days)
isaac 12
Gizmo 1
Today's Statistics
Currently Online 615
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 18
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2017 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171111.dev)
Page Time: 0.026s Queries: 15 (0.008s) Memory: 3.1979 MB (Peak: 3.3265 MB) Zlib enabled. Server Time: 2017-11-18 17:44:08 UTC