Kurzbeschreibung: Execute remote mysql queries across the Web

Veröffentlicht am: 12.07.2007

Gruppe(n):

• Databases


• PHP 5


• Web services

Beschreibung:

This class can be used to execute queries to a remote MySQL server using HTTP.

It accesses URL of a PHP script in a remote Web server that executes queries to a MySQL database passed as URL parameter.

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

The remote script returns the results back to the requesting client using XML to marshal the results array.

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 server 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.

Link: Remote MySQL Query