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]