Page 1 of 1
Using external DB
Posted: Thu 3. Feb 2005, 18:22
by Mike1
So the idea is - what is the best way to integrate presenting some external DB like a table inside a phpwcms content? I mean - I have some table like
cutomer_ID, mail, etc
and I want to show it as a Table.
some ideas ? (thinking without 3rd party script...)
TIA!
Posted: Wed 2. Mar 2005, 09:14
by Pauli
bump
same here
Please?
Posted: Thu 3. Mar 2005, 04:51
by jsw_nz
Ok, not an expert here...
but here goes
(1) I-FRAME option - all scripts would go within I-frame tags
(2) {PHP:query_results.php}
(3) Use XML-driven menu and create page outside 'Wcms proper'
Option (1)
if you want to send interactive queries
Option (2)
is very reliable, if you want only results from an external DB
{PHP:query_results.php} can be called within content area
Option (3)
the menu exists 'outside' Wcms proper (no page rendering required).....
http://www.sportotago.co.nz/find_sport.php (example only)
this is a 'static' page with 'independent XML-driven Phpwcms menu returning dynamic category results yet supporting full interactivity with your DB.
I would not be surprised that there are others on the boards that have devised newer methods, especially with the release of 1.2.1, that supports init and render options.
In fact would be most interested if others have implemnted init/render in this regard....
Hope this helps,
John