Using multiple databases - Revision history

Gabilan at 03:12, 21 April 2008

2008-04-21T03:12:55Z

← Older revision		Revision as of 03:12, 21 April 2008
Line 24:		Line 24:

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

Marlbil at 02:22, 21 April 2008

2008-04-21T02:22:13Z

← Older revision		Revision as of 02:22, 21 April 2008
Line 1:		Line 1:
	{{Howto\|Advanced\|Marlbil}}		{{Howto\|Advanced\|Marlbil}}

	Posted on the [http://www.achievo.org/forum/viewtopic.php?t=3121&highlight=multiple+database forum] by user 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:'''		'''1. just add other database in config.inc.php like:'''
Line 24:		Line 24:

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

bahtiar at 22:28, 17 October 2007

2007-10-17T22:28:24Z

← Older revision		Revision as of 22:28, 17 October 2007
Line 5:		Line 5:
	'''1. just add other database in config.inc.php like:'''		'''1. just add other database in config.inc.php like:'''

	~~Quote:~~		<syntaxhighlight lang="php">

	$config_db["module1db"]["driver"] = "mysql";		$config_db["module1db"]["driver"] = "mysql";
	$config_db["module1db"]["host"] = "localhost";		$config_db["module1db"]["host"] = "localhost";
Line 20:		Line 19:

	...		...
			</syntaxhighlight>

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

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

	'''3. and, if you use your node in other relations. just add the flag:'''		'''3. and, if you use your node in other relations. just add the flag:'''
Line 32:		Line 31:
	for many2one:		for many2one:

	~~Quote:~~		AF_MANYTOONE_LAZY
	AF_MANYTOONE_LAZY


	for one2one:		for one2one:
	~~Quote:~~

	AF_ONETOONE_LAZY		AF_ONETOONE_LAZY


Line 46:		Line 43:
	for many2one and one2one:		for many2one and one2one:

	~~Quote:~~		AF_NO_SORT
	AF_NO_SORT

bahtiar at 22:27, 17 October 2007

2007-10-17T22:27:38Z

← Older revision		Revision as of 22:27, 17 October 2007
Line 1:		Line 1:
			{{Howto\|Advanced\|Marlbil}}

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

bahtiar: Use Multiple Databases in ATK Applications moved to Using multiple databases

2007-10-17T22:27:08Z

Use Multiple Databases in ATK Applications moved to Using multiple databases

← Older revision	Revision as of 22:27, 17 October 2007
(No difference)

Jgarifuna at 07:20, 11 October 2007

2007-10-11T07:20:42Z

New page

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

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

Quote:

$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"] = "";

...

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

Quote:
$this->setTable("nodename","","module1db"])

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

for many2one:

Quote:
AF_MANYTOONE_LAZY

for one2one:
Quote:

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:

Quote:
AF_NO_SORT