Login   Register  
PHP Classes
elePHPant
Icontem

Class: Remote MySQL Query

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Jeff Williams  >  Remote MySQL Query  >  Download .tar.gz .zip  >  Support forum Support forum (4)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Remote MySQL Query
Support forum Support forum
Base name: remotequery
Description: Execute remote MySQL queries across the Web
Related classes: , , , , , , ,
Version: 1.0
PHP version: 5.0
License: Freely Distributable
All time users: 3713 users
All time rank: 686
Week users: 14 users
Week rank: 202
Picture of Jeff Williams
Author: Jeff Williams <e-mail contact>
Packages: 5 Browse this author's classes Browse this author's classes
Country: United States United States - PHP jobs in United States
Age: 40
All time rank: 628 in United States United States
Week rank: 19 Up3 in United States United States Up
Innovation award
Innovation award
Nominee: 1x


  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.

 

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

  Rate classes User ratings   Applications   Files Files  

  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

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Perfect (100.0%)
Good (95.8%)
Sufficient (70.8%)
Sufficient (75.0%)
-
-
Sufficient (74.2%)
73
Month:
Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file remote_query_server.php Aux. Server file
Plain text file remotequery.class.php Class Client class
HTML file class_help.html Doc. Help for class
Accessible without login Plain text file 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.