You could use file functions with a URL:
$movie_site = fopen("http://www.site.com/MovieResponder.php?star="; .
urlencode($star) . "&year=" . urlencode($year), "r");
$movie_info = fread($movie_site, 10240);
fclose($movie_site);
-----Original Message-----
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 1:40 AM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] relay response transactions between PHP scripts on
different servers
Here's the part that confuses me:
How does MovieResponder.php on your site get the results back to my site
and back to the browser/user who is visiting my site..?
ken
----- Original Message -----
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing
List'" <[EMAIL PROTECTED]>
Sent: Sunday, July 15, 2001 9:37 PM
Subject: RE: [PHP-DB] relay response transactions between PHP scripts on
different servers
>
> Ken--
>
> If you have access to that server with the SQL database... Then
> instead of creating an additional PHP script on the SQL server...
> Could you simply add a username/password that was allowed to access
> that particular database (read-only, of course) remotely?
>
> If that isn't an option, here's an idea:
>
> Transmit the $star and $decade variables to the MovieResponder.php
> (don't pass the SQL query directly-- that's a bad idea!)... Have the
> MovieResponder.php execute the SQL query, retrieve all results into an
> array, and serialize() the array, then pass the serialized data back
> to MovieInfo.php.
>
> I'm sure others will have other suggestions, and there are probably
> better ways to do it than this.
>
> Good luck!
>
>
> -----Original Message-----
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 12:22 AM
> To: PHP DB Mailing List
> Subject: [PHP-DB] relay response transactions between PHP scripts on
> different servers
>
>
> Hello,
> suppose you have a MOVIES table in your database on your server at
> your hosting company. Suppose I want some MOVIE info from your
> database..the titles of all the Robert Deniro movies released in the
> 1980's. Can I get the info and relay it back to the user on MY site?
>
> Would it be something like this?:
>
> Suppose I have a php page on MY web site called MovieInfo.php
>
> MovieInfo.php creates a sql command string from info provided by the
> user at MY site.
>
> something like $sql=" select titles,dates from movies where star =
> 'Robert Deniro' and decade = '1980'"
>
> assume correct syntax.
>
> Suppose you have a PHp script on your site called MovieResponder.php
> that is designed to run the query and send the result back to MY
> script.
>
> The php page on MY web site called MovieInfo.php has something like
> this
> form:
>
> FORM method="post"
> action="https://www.yourserver.com/gateway/MovieResponder.php";>
> <INPUT TYPE="hidden" NAME="x_ADC_URL"
> VALUE="https://www.myserver.com/MovieInfo.php";>
> <INPUT TYPE="hidden" NAME="query" VALUE=$sql>
> <INPUT TYPE="submit">
> </FORM>
>
> etc? etc?
>
> how could it work?
>
> Ken
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
