Welcome to WebmasterWorld Guest from 107.23.176.162

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

2 sites sharing customer data

2 separate site needign to share registration and login info

     
9:33 am on Jun 26, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 23, 2003
posts:165
votes: 0


First of all is it possible for two separate website to automatically share customer registration data and login status on 2 separate servers with two different domain names one with HTTPS and one with just HTTP?

If it's possible what's the best way to do this?

the details:

server 1:
HTTPS
Apache
PHP 5
SQL Server

server 2:
HTTP
Apache
PHP 4
MySQL

3:38 pm on June 26, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Mar 11, 2006
posts:76
votes: 0


I believe it is possible.

What you need to do is to point one script to connect to a remote host and access the database.

When connecting to mysql you use:

mysql_connect('localhost', 'username', 'password');

So basically you setup one database and access it locally by one script and remotely by the other:

mysql_connect('someremotehost', 'username' , 'password');

9:24 am on June 27, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 23, 2003
posts:165
votes: 0


thanks alce but the sites both use different databases so I'm not sure how easy that will be.
10:03 am on June 27, 2006 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12548
votes: 2


Why not install the database server on the other server? It would make things much easier, and much safer.
1:39 pm on June 27, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 23, 2003
posts:165
votes: 0


For reasons beyond my control it isn't an option. I'll elaborate.

A third party runs our ecommerce site which collects user info including emails, passwords and addresses, etc.

We also have a legacy site that runs competitions and people can enter their details on this site which we use for marketing purposes.

If someone signs up to one it would be best if they were signed up automatically to the other site. If they log- in to one and move across it would be best if they were still logged-in. Apart from the URL changing the customer should never be aware that theyr'r moving from site to site.

It isn't feasible to end the competitions - much as I'd like. It also isn't feasible for us to simply send all our customer data to the third party running our ecommerce site with nothing in return plus that wouldn't help the logging in issue

5:05 pm on June 27, 2006 (gmt 0)

Senior Member

joined:Nov 12, 2005
posts:5967
votes: 0


>>>If someone signs up to one it would be best if they were signed up automatically to the other site.

If you do not have access to the third-party host then you won't be able to implement this yourself, but maybe have them do it for you, or give you access to the host to do it.

5:37 pm on June 27, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 31, 2003
posts:1316
votes: 0


You could use http or https to move data back and forth. For example, when someone signs up, the server they're on could send an HTTP POST to the other server with all of their data, which that server would then save to its database.

To make moving from one server to the other transparent to the user, you'd need to set two cookies when they log in -- one for each server. But that would be a third-party cookie, which might be blocked by the browser.

Worst-case scenario, though, they'd have to log in twice.

3:30 pm on June 28, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 23, 2003
posts:165
votes: 0


Thanks for the advice everyone.

I think the main way to solve this is to lobby for change and instead of having people logging in to enter competitions on a different website, merely have them enter their details for each competition they enter (and to make this work, really cut down on the amount of details we ask for).

I don't know about you but if I enter a competition on a website I don't expect to be signing up for a user account complete with password - that makes little sense to me and now I've thought about it a little, I've decided a rethink is necessary.

5:07 pm on June 28, 2006 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts:15756
votes: 0


I agree absolutely with everything you said in your last post

it really won't work very well the way it is now and it will never be seamless enough

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members