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