Displaying results from another MySql database in an CMSMS web page

The place to talk about things that are related to CMS Made simple, but don't fit anywhere else.
Post Reply
burlington
Power Poster
Power Poster
Posts: 444
Joined: Wed Dec 27, 2006 5:15 pm

Displaying results from another MySql database in an CMSMS web page

Post by burlington »

I am running a CMSMS website.

I want to be able to display the results from another MySql database, which carries stats, in a normal CMSMS webpage.

How would I go about this please? Using an inline frame, or is there a better method?

Thank you.

Martin
tyman00
Power Poster
Power Poster
Posts: 906
Joined: Tue Oct 24, 2006 5:59 pm

Re: Displaying results from another MySql database in an CMSMS web page

Post by tyman00 »

I guess it all depends where your database is and if it accepts remote connections (assuming that the database is on another sever).

Are the stats already provided for you in a formatted form? If so an inline frame would likely be the easiest. Another way would be to use the existing code to create a UDT and insert the UDT in your CMSMS page.
If all else fails, use a bigger hammer.
M@rtijn wrote: This is a community. This means that we work together and have the same goal (a beautiful CMS), not that we try to put people down and make their (voluntary) job as difficult as can be.
burlington
Power Poster
Power Poster
Posts: 444
Joined: Wed Dec 27, 2006 5:15 pm

Re: Displaying results from another MySql database in an CMSMS web page

Post by burlington »

Thanks Tyman00

The database is on the same domain though whether it is actually on the same server as the CMSMS one is questionable.

I already get the stats in a formatted form from the database but have to clone the page header etc to match the main website. Therefore I suppose an inline frame would be best

Sorry, but what is a UDT?

Regards

Martin
tyman00
Power Poster
Power Poster
Posts: 906
Joined: Tue Oct 24, 2006 5:59 pm

Re: Displaying results from another MySql database in an CMSMS web page

Post by tyman00 »

burlington wrote: Thanks Tyman00

The database is on the same domain though whether it is actually on the same server as the CMSMS one is questionable.

I already get the stats in a formatted form from the database but have to clone the page header etc to match the main website. Therefore I suppose an inline frame would be best

Sorry, but what is a UDT?

Regards

Martin
In this situation it would probably be easiest to use an iFrame.

UDT: http://wiki.cmsmadesimple.org/index.php ... fined_Tags
If all else fails, use a bigger hammer.
M@rtijn wrote: This is a community. This means that we work together and have the same goal (a beautiful CMS), not that we try to put people down and make their (voluntary) job as difficult as can be.
burlington
Power Poster
Power Poster
Posts: 444
Joined: Wed Dec 27, 2006 5:15 pm

Re: Displaying results from another MySql database in an CMSMS web page

Post by burlington »

Thanks, will try it

Martin
Post Reply

Return to “The Lounge”