Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

Customising the CMS /

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Connection to multiple databases


Go to End


6 Posts   6996 Views

Avatar
linkoovi

Community Member, 12 Posts

10 August 2010 at 3:31am

Hi,

I have to connect to a "external" db, (with different params:username/host/pass ), that holds some data, it has nothing to do with SS. I managed to connect and exe a query
but I cant reconnect to the SS database back.

How do i do this in SS 2.4?

Avatar
patjnr

Community Member, 102 Posts

6 October 2010 at 10:58pm

Hi

iam trying to do the same thing. how do you connect to a secondary db?

thx

PAt J

Avatar
swaiba

Forum Moderator, 1899 Posts

6 October 2010 at 11:18pm

Edited: 07/10/2010 12:04am

how about the standard php way...

//note use of true in mysql_connect, this ensure that the connection ($C) is a new
//resource and not stomping all over the previous mysql_connect return value
$C = mysql_connect( $MYSQL_SERVER, $MYSQL_USER, $MYSQL_PASS ,true);
$cursor = mysql_query( $QUERY, $C );
while ($r = mysql_fetch_array($cursor))
{
	//do stuff here, e.g.
	$dataitem=$r['colname'];
}

Avatar
bummzack

Community Member, 904 Posts

7 October 2010 at 12:48am

I did this recently and this is how:
In your _config.php you create two db connection settings, something along these lines:

global $databaseConfig;

$databaseConfig = array(
	'type' => 'MySQLDatabase',
	'server' => 'localhost', 
	'username' => 'usernameA', 
	'password' => 'passwordA', 
	'database' => 'databaseA'
);

global $databaseConfig2;

$databaseConfig2 = array(
	'type' => 'MySQLDatabase',
	'server' => 'localhost', 
	'username' => 'usernameB', 
	'password' => 'passwordB', 
	'database' => 'databaseB'
);

Then in a function where you need both DBs, you do something like this:

public function doStuff() {
	global $databaseConfig, $databaseConfig2;
	
	// connect to DB 2
	DB::connect($databaseConfig2);
	
	// create a query.. this will go to "databaseB"
	$query = new SQLQuery("*", "MyTable");

	$result = $query->execute();

	// do something with the result...
	
	// when done, switch back to the regular DB Config
	DB::connect($databaseConfig);
}

Avatar
patjnr

Community Member, 102 Posts

7 October 2010 at 10:30pm

The solution that worked for me is from Banal as my situation involved connecting to 3 databases.
I created all my connection setting in _config.php. As said above, whenever i wanted to switch, I used

 DB::connect($databaseConfig_WP); 

and the most important part was to revert back to your default SS connection soon after.

thx All

PJ

Avatar
muskie9

Community Member, 24 Posts

8 December 2014 at 6:05pm

Anyone tackled this in 3.1.x when using an _ss_environment.php file?