Re: [PHP-DB] relay response transactions between PHP scripts on different servers
Thanks,, are we talking about something like this? 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{ > star: year: } ?> - 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";> > > > VALUE="https://www.myserver.com/MovieInfo.php";> > > > > > > > > > > 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]
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";> > VALUE="https://www.myserver.com/MovieInfo.php";> > > > > > 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]
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";> > VALUE="https://www.myserver.com/MovieInfo.php";> > > > > > 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]
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";> https://www.myserver.com/MovieInfo.php";> 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]
[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";> https://www.myserver.com/MovieInfo.php";> 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]