两个项目共享相同的用户帐户

Question

I have two independent projects / sites which each has it's own database. I want to have a common user registration between both. Should I created a third database for user accounts?

How should I implement this? I am using PHP Code Igniter (looking at Ion Auth) also that's another problem as the database configuration has to be set in a php config file how would I alternate between both.

Answer 1

http://codeigniter.com/user_guide/database/connecting.html

In code:

application/config/database.php:

$db["default"]["hostname"] = "localhost";
$db["default"]["username"] = "username";
$db["default"]["password"] = "password";
$db["default"]["database"] = "database";

$db["userdatabase"]["hostname"] = "localhost";
$db["userdatabase"]["username"] = "username";
$db["userdatabase"]["password"] = "password";
$db["userdatabase"]["database"] = "database";

In your model:

$this->load->database('userdatabase');
// Do user stuff
$this->load->database('default');