RE: [PHP] Communicating with remote server
| From: | Webmaster | Date: | Mon, 17 Nov 2003 22:19:25 +0000 |
| Subject: | RE: [PHP] Communicating with remote server | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-170024@lists.php.net to get a copy of this message | ||
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:jmckeon@telaurus.com]
Sent: Monday, November 17, 2003 5:14 PM
To: Matt Palermo
Cc: php-general@lists.php.net
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