Read Me

SOAP-SQL Project

Overall Description:
Most commercial database systems (Oracle, DB2, SQL Server) have features that publish functionality of their databases as web service WSDLs. 
Currently, open source databases like MySQL have no such features, and small-to-medium sized businesses are left to implement this on their own.
SOAP-SQL provides an extremely simple API to generate a WSDL service based on standard SQL statements. The code is pure PHP, and depends only on NuSOAP (also pure PHP) and PEAR MDB2 abstraction library.
SOAP-SQL allows a developer or administrator to quickly create a web service from their existing database information, helping accelerate the web service movement.

Features include:
1) Database type agnostic
2) Supports database queries (selects) and modify-style web service functions
3) Capability to auto-generate WSDL callback functions, or use custom functions.
4) Includes security token support.
5) Automatically quotes and escapes SQL input to help protect against injection attacks.
6) Works with PHP 4 and 5


Demo files description:

client_helper.php:	 Helper file used by the client demos.
test_nusoap_client.php:	 Simple client test demonstrating NuSOAP client API.
test_nusoap_server.php:	 Simple server test demonstrating NuSOAP server API.

test_soapsql.php:	 The main SOAP-SQL server test demonstrating the simplicity and flexibility of SOAP-SQL.
test_soapsql_client.php: The client test exercising the server-side test.

To run SOAP-SQL in addition to the demos, you will need:

1) Database software such as MySQL installed.
2) PHP support extensions installed for your database type (e.g. 'php_mysql.dll').

See INSTALL for installation details.