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've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Customising the CMS /

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

Use Silverstripe page to Load Other database


Go to End


4 Posts   2776 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