View source for Using multiple databases

{{Howto|Advanced|Marlbil}}

Posted on the [http://www.achievo.org/forum/viewtopic.php?t=3121&highlight=multiple+database forum] by user marlbil (Marlon Bilog)

'''1. just add other database in config.inc.php like:''' 

<syntaxhighlight lang="php">
$config_db["module1db"]["driver"] = "mysql"; 
$config_db["module1db"]["host"] = "localhost"; 
$config_db["module1db"]["db"] = ""; 
$config_db["module1db"]["user"] = ""; 
$config_db["module1db"]["password"] = ""; 

$config_db["module2db"]["driver"] = "mysql"; 
$config_db["module2db"]["host"] = "localhost"; 
$config_db["module2db"]["db"] = ""; 
$config_db["module2db"]["user"] = ""; 
$config_db["module2db"]["password"] = ""; 

... 
</syntaxhighlight>

'''2. then specify the db to use in your nodes:''' 

<syntaxhighlight lang="php">
  $this->setTable("nodename","","module1db")
</syntaxhighlight>

'''3. and, if you use your node in other relations. just add the flag:''' 

for many2one: 

  AF_MANYTOONE_LAZY


for one2one: 

  AF_ONETOONE_LAZY 


Note that some features (like column sort) in the admin page does not work. So, you may also add the flag: 

for many2one and one2one: 

  AF_NO_SORT