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.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

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

problem with external database connection


Reply


1237 Views

Avatar
ojalà

Community Member, 87 Posts

15 January 2009 at 9:16pm

Hi!
I need to connect silverstripe to external database. I read forum and I found somethig useful about connection here: http://silverstripe.org/archive/show/120 but I can't connect to my database.

So I wrote:

class Page extends SiteTree {

function db_external_connection() {
   $db = new MySQLDatabase(array(
"server" => "pandora",
"ip" => "127.0.0.1"
"username" => "admin",
"password" => "mm",
"database" => "ville_free",
"type" => "mysql",
));
$query = $db->query("SELECT * FROM mm_service");
Debug::show($row);
}
}

and in Page.ss
$db_external_connection