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..?
----- Original Message -----
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
Sent: Sunday, July 15, 2001 9:37 PM
Subject: RE: [PHP-DB] relay response transactions between PHP scripts on
> 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
> 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
> 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 method="post"
> <INPUT TYPE="hidden" NAME="x_ADC_URL"
> <INPUT TYPE="hidden" NAME="query" VALUE=$sql>
> <INPUT TYPE="submit">
> etc? etc?
> how could it work?
> 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]