Thanks,,
are we talking about something like this?


<?PHP
// MovieInfo.php on my site
IF ($submit=="submit"){ // user has submited request for movie info

// run the remote script and get the answer:
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);

echo"your movie info is: ";
echo ($movie_info);
}
else{

<form action=<?php Echo $PHP_SELF ?> >
star: <INPUT TYPE="text" NAME="star" >
year: <INPUT TYPE="text" NAME="year" >
 <INPUT TYPE="submit" value="submit">
 </FORM>
}

?>





----- Original Message -----
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Sunday, July 15, 2001 10:51 PM
Subject: RE: [PHP-DB] relay response transactions between PHP scripts on
different servers


>
> 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]

Reply via email to