Using external DB

Mike1 · Post by **Mike1** » Thu 3. Feb 2005, 18:22

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!

Pauli · Post by **Pauli** » Wed 2. Mar 2005, 09:14

bump

same here
Please?

jsw_nz · Post by **jsw_nz** » Thu 3. Mar 2005, 04:51

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