Class: Remote MySQL Query (xml mysql, mysql xml, XML to MYSQL, mysql to xml)

Supplied by:

Name:	Jeff Williams `<e-mail contact>`
Published packages:	5
Country:	United States - PHP professionals from United States looking for PHP jobs
Home page:	???
Age:	36
All time rank:	161
Week rank:	41

Browse this author's classes

Innovation Award:

PHP Programming Innovation award nominee

July 2007
Number 5

Sometimes it is necessary to perform queries to databases that are in remote servers. However, firewall rules prevent accessing those databases from outside the network where the respective server machines are located.

This package provides a solution that circumvents that restriction. It uses a PHP script as a proxy in the same machine as the remote MySQL database server to perform remote queries via the Web.

This way the remote database can be queried by client scripts from remote machines. To use this solution, the client scripts can be in PHP or any other language.

Manuel Lemos

Groups:

PHP 5	Classes using PHP 5 specific features	View top rated classes
Databases	Database management, accessing and searching	View top rated classes
Web services	Web data clipping, SOAP or XML-RPC clients and servers	View top rated classes

Detailed description:

Easily execute queries on a remote MySQL server using only HTTP.

It works by accessing a PHP script on the remote web server that executes queries based on passed in URL parameters.

The client passes a secret key to the remote script to prevent unauthorized access.

The remote script passes back the results to the requesting client using XML to marshal the data.

The class parses the results XML data returned by the server script and returns an array.

It, also, retrieves (into class variables) the number of records returned by the query and the time the query took to execute.

The server script may be used to execute MySQL queries that can be retrieved by programs written in other languages besides PHP.

User ratings:

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Perfect (100.0%)`	`Good (93.8%)`	`Sufficient (62.5%)`	`Sufficient (68.8%)`	`-`	`-`	`Sufficient (72.5%)`	84
Month:	Not yet rated by the users

Applications that use this class:

No application links were specified for this class.

If you know an application of this package, send a message to the author to add a link here.

Files:

File	Role	Description
`remote_query_server.php`	Aux.	Server file
`remotequery.class.php`	Class	Client class
`class_help.html`	Doc.	Help for class
`example.php`	Example	Example file

Download all files: remotequery.tar.gz remotequery.zip

NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

Class: Remote MySQL Query

Supplied by:

Innovation Award:

Groups:

Detailed description:

User ratings:

Applications that use this class:

Files: