Advice on integration of two php applications

My project has two 3rd party php apps on a dedicated box running apache, mysql.  My biggest problem is how to join the two registrations/logins/password resets/etc.

Should I work towards combining the user tables in mysql and try to get one of the apps to read user authentication from there?  

Or do I need an SSO server/app (like Josso) on my server to handle authentication and just choose one app to collect the data?  

I do already have about 200 users so I would prefer to not make them change anything but at this point I want to make it solid.   They may have different usernames/passwords between the two right now but I can force a choice.  

One app uses memberID and the other uses userID, if that matters.  

So any direction here would be great...thanks!
Large_FarvaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MichaelALoftusCommented:
Are these PHP applications which you have written or are they established systems?  What is the context of these applications (ecommerce, cms etc.)?
0
Large_FarvaAuthor Commented:
One is Jrox JEM, shopping cart with integrated cms/affiliate program manager and the other is phpFox social network.  I am using JEM to lock the directory that Fox is in unless they have a paid membership.  So members need to checkout through the cart first and then they have access to the social network, which has a separate registration form...obviously this is confusing to the user.  

Thanks for your reply.  
0
MichaelALoftusCommented:
It seems like you'll need to edit the code directly so that when the user checks out all of the data fields that are necessary for phpFox are then immediately pushed into that database.  You'll have to dig into the registration script for phpFox and integrate that into the final process after the user has paid through Jrox JEM.  Does that help? It will certainly require custom scripting once the user has successfully completed the transaction.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Large_FarvaAuthor Commented:
So would I need to choose which user table to use or would it be writing to both dbs?  I know one uses password salt and the other does not...both are md5 so I would have to choose which process to send this through if writing to single user table, right?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.