single sign-on: the other database

Question

i'm having problems using the single sign-on. The problem i have is that my database is on an entirely other server account.

There is particularly something i don't understand. I didn't see anywhere in the qa-external-users.php file a place where you ask for the "other database" connexion credentials. Did i overlook something?

Answer 1

You would need to connect to this other database in the usual PHP way, using mysql_connect() with the appropriate arguments. You can add this in each function in qa-external-users.php, and PHP will automatically re-use the previous connection instead of reconnecting if the parameters are the same.

Make sure you pass the result from your mysql_connect to mysql_query(), instead of the $qa_db_connection parameter, so that your query is run against your database, and not Question2Answer's.

Comments

thank you that clarified it.