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

Use Silverstripe page to Load Other database


Go to End


4 Posts   2348 Views

Avatar
acefx

Community Member, 8 Posts

5 March 2009 at 10:46pm

Hi

I'm trying to load the content of another database and showcase it in tree on my page. The problem is that i can just get Silverstripe to load the content of the DB.
Also i want to create a drop down using : 'Issue' => 'Drop', but its not working and i also tried dropdown and list but non worked.

Can anyone help me out

Thanks

Avatar
acefx

Community Member, 8 Posts

6 March 2009 at 2:06am

Edited: 11/03/2009 6:26pm

I was able to load the database at last by just creating a function that handles all the connection.

function tre()
{

return "This could be HTML/Text/Images or PHP";

$sava = "localhost";
$usa = "root";
$pas = "not to worry";

$db = "mysite";

$con = mysql_connect($sava, $usa, $pas);

$ue = mysql_select_db($db);

$info = "SELECT * FROM broad";

$inf = mysql_query($info) or die(mysql_error());

while ($ini = mysql_fetch_array($inf, MYSQL_ASSOC))
{
//return "<ul><li>". $ini["id"]. "</li><li>". $ini["user"]. "</li></ul>";
}

}

But i can load it to the appropriate location in the page

:)

Avatar
Jainx

Community Member, 1 Post

4 July 2011 at 10:43pm

Thanks for posting the function!
Gonna give it a go myself