[PHP-DB] remote database exchange
Is it possible to exchange data on remote databases in PHP mysql? Suppose I had a MUSIC database that you wanted your site visitors to be able to query,and it was OK with me because you had a MOVIE database that I wanted MY site visitors to be able to query, Could we swing this? what is the name of this process? remote process serving? remote database access? relay exchange process server? IF it exists,,where are all the tutorials and docs on it? 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]
RE: [PHP-DB] remote database exchange
The mysql_connect() function accepts a host name, which can be the internet address of another machine! However-- the MySQL database on that machine has to be set up to allow outside connections for whatever particular username/password you are using! Please see these pages to answer your questions: http://www.mysql.com/doc/A/d/Adding_users.html-- MySQL username/password configuration http://www.php.net/manual/en/ref.mysql.php---MySQL functions in PHP The PHP page has an example on that page that will show you -exactly- how to do it. --Matt -Original Message- From: Ken Sommers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:53 PM To: PHP DB Mailing List Subject: [PHP-DB] remote database exchange Is it possible to exchange data on remote databases in PHP mysql? Suppose I had a MUSIC database that you wanted your site visitors to be able to query,and it was OK with me because you had a MOVIE database that I wanted MY site visitors to be able to query, Could we swing this? what is the name of this process? remote process serving? remote database access? relay exchange process server? IF it exists,,where are all the tutorials and docs on it? 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] remote database exchange
Suppose I Need to get Vendor prices from a very large remote (Oracle) price list . They probably don't have PHP installed. What are my options? Ken - Original Message - From: Matthew Loff [EMAIL PROTECTED] To: 'Ken Sommers' [EMAIL PROTECTED]; 'PHP DB Mailing List' [EMAIL PROTECTED] Sent: Monday, July 16, 2001 3:31 PM Subject: RE: [PHP-DB] remote database exchange The mysql_connect() function accepts a host name, which can be the internet address of another machine! However-- the MySQL database on that machine has to be set up to allow outside connections for whatever particular username/password you are using! Please see these pages to answer your questions: http://www.mysql.com/doc/A/d/Adding_users.html-- MySQL username/password configuration http://www.php.net/manual/en/ref.mysql.php---MySQL functions in PHP The PHP page has an example on that page that will show you -exactly- how to do it. --Matt -Original Message- From: Ken Sommers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:53 PM To: PHP DB Mailing List Subject: [PHP-DB] remote database exchange Is it possible to exchange data on remote databases in PHP mysql? Suppose I had a MUSIC database that you wanted your site visitors to be able to query,and it was OK with me because you had a MOVIE database that I wanted MY site visitors to be able to query, Could we swing this? what is the name of this process? remote process serving? remote database access? relay exchange process server? IF it exists,,where are all the tutorials and docs on it? 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] remote database exchange
(Quote from an annotation found on http://www.php.net/manual/en/function.ocilogon.php): [EMAIL PROTECTED] 31-Mar-2000 11:32 Regarding connecting to an Oracle Db on NT from Linux, here is what you need to do. Little Oracle knowledge is a prerequisite. 1. Install Oracle database client onto Linux. 2. Once installed on Linux, modify the tnsanmes.ora file to create an alias to the database running on the NT box. Follow the syntax already in the tnsnames.ora file 3. Depending on the version of Oracle you have and the Oracle Database has the listener running there is a utility called tnsping(xx) that you can use to verify that you can hit a remote 0racle database syntax is tnsping alias in tnsnames.ora 4. You could use sqlplus to conenct to the remote database to verify the login process works. Remember to use login_id@tnsnames_alias/password 5. Once you have gotten this far PHP should be able to hit the database. Give it a shot. You might need to tool around the PHP config to get things to work. use the phpinfo function to debug, its rather useful. That's the only solution I've found without setting up a CGI on the other end to retrieve the info... -Original Message- From: Ken Sommers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 6:56 PM To: Matthew Loff; 'PHP DB Mailing List' Subject: Re: [PHP-DB] remote database exchange Suppose I Need to get Vendor prices from a very large remote (Oracle) price list . They probably don't have PHP installed. What are my options? Ken - Original Message - From: Matthew Loff [EMAIL PROTECTED] To: 'Ken Sommers' [EMAIL PROTECTED]; 'PHP DB Mailing List' [EMAIL PROTECTED] Sent: Monday, July 16, 2001 3:31 PM Subject: RE: [PHP-DB] remote database exchange The mysql_connect() function accepts a host name, which can be the internet address of another machine! However-- the MySQL database on that machine has to be set up to allow outside connections for whatever particular username/password you are using! Please see these pages to answer your questions: http://www.mysql.com/doc/A/d/Adding_users.html-- MySQL username/password configuration http://www.php.net/manual/en/ref.mysql.php---MySQL functions in PHP The PHP page has an example on that page that will show you -exactly- how to do it. --Matt -Original Message- From: Ken Sommers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:53 PM To: PHP DB Mailing List Subject: [PHP-DB] remote database exchange Is it possible to exchange data on remote databases in PHP mysql? Suppose I had a MUSIC database that you wanted your site visitors to be able to query,and it was OK with me because you had a MOVIE database that I wanted MY site visitors to be able to query, Could we swing this? what is the name of this process? remote process serving? remote database access? relay exchange process server? IF it exists,,where are all the tutorials and docs on it? 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] remote database exchange
I am not familiar with Oracle, but by looking through the PHP docs, it appears that you can't connect remotely to an Oracle server... Am I wrong about this, or is it a limitation of the Oracle library, or is Oracle not built to allow remote connections? -Original Message- From: CC Zona [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 7:34 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] remote database exchange In article 012601c10e4a$6c7a2ec0$b943500c@zeospantera, [EMAIL PROTECTED] (Ken Sommers) wrote: Suppose I Need to get Vendor prices from a very large remote (Oracle) price list . They probably don't have PHP installed. If... -you have PHP installed, -AND you have Oracle support compiled in to that install, -AND you have connection info (username/password/hostname) for an account on that Oracle system that has been granted access to vendor prices, -AND you know how to use PHP's Oracle functions, -AND you know how to query an Oracle database ...then you're set. Whether they have PHP installed or not is irrelevant. -- CC -- 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] remote database exchange
Great, thanks for a complete answer I love it.. I ran mysql show variables; to see if my host server has Oracle support,, I don't see anything about Oracle or any other DBMS,, any way to tell without asking them? ken - Original Message - From: CC Zona [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 16, 2001 4:33 PM Subject: Re: [PHP-DB] remote database exchange In article 012601c10e4a$6c7a2ec0$b943500c@zeospantera, [EMAIL PROTECTED] (Ken Sommers) wrote: Suppose I Need to get Vendor prices from a very large remote (Oracle) price list . They probably don't have PHP installed. If... -you have PHP installed, -AND you have Oracle support compiled in to that install, -AND you have connection info (username/password/hostname) for an account on that Oracle system that has been granted access to vendor prices, -AND you know how to use PHP's Oracle functions, -AND you know how to query an Oracle database ...then you're set. Whether they have PHP installed or not is irrelevant. -- CC -- 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] remote database exchange
In article 001b01c10e52$0c08e060$3c41500c@zeospantera, [EMAIL PROTECTED] (Ken Sommers) wrote: I ran mysql show variables; to see if my host server has Oracle support,, sighMySQL is a DBMS. Oracle is a DBMS. Different products from different vendors. MySQL doesn't tell you if you have Oracle support. You can use the PHP function phpinfo() to see what options are compiled into your PHP install. But the information show there can look pretty cryptic until you compare it against the manual to find out what each option means. Simpler way: talk to your ISP. Ask them all these questions. I don't see anything about Oracle or any other DBMS,, any way to tell without asking them? Without asking who? And why would you want to avoid asking them? Your ISP should be a resource for you, not something to avoid. And if it's the database owner you don't want to talk to, let me repeat: you need to be granted access to an account on the database. -- CC -- 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]
