Posted by NC on 08/17/07 21:06

On Aug 17, 7:11 am, Jerim <wyo...@gmail.com> wrote:
>
> I am attempting to put together one script that pulls data from one
> database on its own server, and data from another database on its own
> server, which is off-site.
>
> Server 1 - Only allows shared memory access to the database. Also
> disallows http:// includes. This is where the database of names is
> stored. This is our internal MySQL server.
>
> Server 2 - Only allows shared memory access to the database. So
> anything that calls the connection has to be on the same server. This
> is our external web server maintained by an outside party.
>
> To get a list of names, I created a PHP page on Server 2 that simply
> includes a script from Server 1.

Ain't going to work. Remote include() only includes the output of a
script, not the executable code.

What you need is to deploy a Web service provider on Server 2 and
consume the service from Server 1. Ideally, though, you should allow
access to Server 2 databases from Server 1 (preferably via SSL).

Cheers,
NC

• Next in forum: Re: Child class references static variable of parent instead of its own
• Prev in forum: Re: Child class references static variable of parent instead of its own
• Thread view: Re: Two MySQL servers, one script

[Reply to this message]