If you don't care who sees your data, or you are operating behind a firewall, then the simplest solution has already been mentioned (described as http).
You basically code a script on your GTK app to perform an open (see fopen function) to a url on the server machine like "http://remotedbserver.com/phpfetchscript.php?var=foo&var2=bar"; where foo and bar specify the data selection criterion for your database script. On the database server, under the control of it's web server, the script phpfetchscript.php executes, referencing the parameters passed in the url $var1 = $_GET["var"]; $var2 = $_GET["var2]; the phpfetchscript.php on the server then runs the query and begins echoing the comma separated columns from the database, perhaps ending with a new line "\n"; Your GTK app now begins performing fgets reads against the data until fgets returns a false and does what it needs to do with the data, perhaps loading it into a grid control, or some such. The caviate is that anyone who can come up with the correct url (and can access your database machine), will be able to trigger the extract of data. If this is not acceptable, then you need to consider other options. good luck, Warren Vail -----Original Message----- From: Webmaster [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 5:31 PM To: Vail, Warren; 'Jeff McKeon' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Communicating with remote server Yes, both my server and the remote server have webservers with PHP installed. I have access to both servers to edit/modify/create files etc. I don't have SSH on the server's though. I have FTP access, so I can work with anything that way. I basically just need a relatively easy way to communicate back and forth between the servers. I just have no prior experience doing it so I need a little guidance. Thanks, Matt -----Original Message----- From: Vail, Warren [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 7:09 PM To: 'Webmaster'; 'Jeff McKeon' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Communicating with remote server Lot's of options. Will this access be across the internet, or behind a firewall? Are you concerned about securing your information from prying eyes? You seem to be focusing on a script that runs on the remote machine, does this machine have a web server as well, or will you be executing PHP as a standalone process? I am taking it for granted that you have PHP installed on the remote machine? Do you have access to commands like REXEC, RCP, RSH, SSH on your local machine, and are the required daemons running on the remote machine? What platforms are involved at each end? Just a few questions that may have an impact on your solution... Warren Vail -----Original Message----- From: Webmaster [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 2:19 PM To: 'Jeff McKeon' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Communicating with remote server Well, I know how to run MySQL queries and connect to the db and things like that. But I would like to be able to connect to a remote site (ex: http://my-site.com/functions.php). Here I would like to run functions from the remote functions.php file and have it connect to it's own server's db. Then I want to be able to have certain information sent back to me. Maybe sockets is the best way to do this, but I don't know much about them. Any advice anyone? Matt -----Original Message----- From: Jeff McKeon [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 5:14 PM To: Matt Palermo Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Communicating with remote server Matt Palermo wrote: > I am writing a desktop application using PHP-GTK. I would > like this program to be able to connect to a remote server, > call some functions that I specify, and return the right > information (most likely from a MySQL db). I have access to > the server, so I can create any and all functions that I > want, but I don't know how to connect to the remote server > page and get all the results. I am new to cross-server > comunication programming, so if anyone knows of a very > detailed and easy to learn tutorial please send me the link. > I would appreciate any help you are willing to offer. > > Thanks, > > Matt For mysql queries I use this... function db_connect($dbhost,$dbname,$dbuser,$dbpass) { global $MYSQL_ERRNO, $MYSQL_ERROR; $link = mysql_connect($dbhost,$dbname,$dbuser,$dbpass); if (!$link_id) { $MYSQL_ERRNO = 0; $MYSQL_ERROR = "Connection failed to the host $dbhost"; return 0; } else if(empty($dbname) && !mysql_select_db($dbname)) { $MYSQL_ERRNO = mysql_errno(); $MYSQL_ERROR = mysql_error(); return 0; } else return $link; } $link_id=db_connect(dbname,db_user_name,db_user_pass); Mysql_select_db(dbname, $link_id); $query="select * from tablename"; $result=mysql_query($query); While ($query_data=mysql_fetch_row($result)) { echo $query_data[0],$query_data[1],$query_data[2],etc } Jeff -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
