UBB.Developers Forums Community Development Programming PHP and Server-side Scripting Help! SSI on a different server?

Is there any way to run a CGI program located on a different server via SSI????

I need to share some dynamic content with another website, but I obviously don't want to give him any script that includes my database login information. His server is NT using ASP pages and mine is Linux running PHP pages. Any suggestions??? I am getting REALLY frustrated. Everything I have tried doesn't seem to work.

Any help would be GREATLY, GREALY appreciated.

Thanks!

Okay, well now I know that I can't call use a SSI with a CGI script located on a different server.

There has got to be a way to share the results of a MySQL query with another server without giving them full access to my entire database.

Any ideas?

hmmm... can you print it to a text file on the one server and do a virtual include to the other?

I think I might have to dump to an XML file, but I was hoping to avoid that because the contents of the table changes frequently. I guess whenever someone makes a change I can have it create an updated version of the XML file. Now I just need to write a little CGI program to get the XML file, parse it and output the info in the proper format. Then the other guy can put the CGI program on his server and do an include. He doesn't have any idea how to work with XML himself, so I'll need to make a program for him.

Thanks Allen for the suggestion. If anybody has any other suggestions, I'd still love to hear them.

Thanks!

Get PHP to fopen the url for the cgi script on the other server and print out the results?
then you can include the php script in your SSI.
http://www.php.net/manual/en/function.fopen.php

or create an extra script and configure its output format as;

document.write("result1");
document.write("result2");
document.write("result3");

then, he/she can call it like;

t type="text/javascript" src="http://yoursite/some.php">pt>

Another option would be SSIing a script that makes the request to the site, i.e.:

#!/usr/bin/perl
use CGI qw(:standard);
use LWP::Simple;
print header . get("http://yoursite/some.php");

Thanks for the ideas! I'll give them a shot!

You guys are lifesavers (what flavor is up to you.. haha)