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.

Customising the CMS /

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

Use Silverstripe page to Load Other database


Go to End
Reply


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