SQL & DDM via PHP

[Steve]

Morning,

I have a "small" question..........

We have an iseries that is partitioned; one partition is set into the
DMZ and allows our suppliers to access a CGI-driven RPG website and
the other partition runs our core internal systems.

We now have PHP installed on the DMZ partition. I've developed a
system that runs in PHP on the internal system but we need to open it
up to our suppliers. I've moved the code across to the DMZ partition
but I'm getting problems when using SQL.....

All of the files reside on our internal partition and we have DDM
across from DMZ. I know I need to use the "CONNECT TO" command in SQL
but does anybody have any experience of using this in PHP across
multiple systems.

Thanks

Steve

[iseriesflorida]

Could you use ODBC to make the connection??

[Tim M]

How about not doing it at all.

Instead set up the Apache server with mod_proxy and mod_rewrite and make
your DMZ proxy the requests to your internal instance. You can create a
rewrite rule like this

RewriteRule $/internalapp/(.*) http://internalhost/internalapp/$1 [P,QSA]

[Kent Milligan]

The PHP program running on i should be able to connect to any database/server
registered in the Relational Database Directory Entry (WRKRDBDIRE)

--
Kent Milligan
ISV Enablement - System i
km...@us.eye-bee-m.com (spam trick) GO HAWKEYES!!
>>> ibm.com/iseries/db2
(opinions stated are not necessarily those of my employer)