ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:proxy:proxy_index

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
v5:proxy:proxy_index [2017/07/10 19:06]
mnewnham created
v5:proxy:proxy_index [2020/01/04 16:44] (current)
dregad [Introduction] security warning
Line 1: Line 1:
 ====== ADOdb Proxy Server ====== ====== ADOdb Proxy Server ======
 +<WRAP important>​
 +This functionality is deprecated as of ADOdb 5.21.0 and will be removed in a later release, unless the community contributes with necessary security enhancements,​ [[https://​github.com/​ADOdb/​ADOdb/​pull/​444|as discussed on Github]].
 +</​WRAP>​
 +
 ===== Introduction ===== ===== Introduction =====
 The ADOdb Proxy server provides a simple method of extending a database connection to provide a simple REST server via http. It provides a limited number of ADOdb commands that can be executed across an http channel against any supported database. The ADOdb Proxy server provides a simple method of extending a database connection to provide a simple REST server via http. It provides a limited number of ADOdb commands that can be executed across an http channel against any supported database.
 +
 +<WRAP alert>
 +**Security warning - use with extreme caution !**
 +Depending on how it is setup, this feature can potentially expose the database to attacks, particularly if used with a privileged user account. ​
 +</​WRAP>​
  
 ===== Server Side Usage ===== ===== Server Side Usage =====
   * The machine that acts as a database server must have a PHP configuration installed that allows it to serve PHP connections to the necessary database. ​   * The machine that acts as a database server must have a PHP configuration installed that allows it to serve PHP connections to the necessary database. ​
   * The http server must have a CGI configuration defined that allows it to serve PHP requests.   * The http server must have a CGI configuration defined that allows it to serve PHP requests.
-  * A single ​pr +  * A single ​program ​is provided that acts as a server side dispatcher, **//​server.php//​**. Up to ADOdb version 5.21, this program cannot be moved from the /adodb directory. This program must be modified in-situ to provide the database connection necessary.
-  * ogram is provided that acts as a server side dispatcher, **//​server.php//​**. Up to ADOdb version 5.21, this program cannot be moved from the /adodb directory. This program must be modified in-situ to provide the database connection necessary.+
  
 Modify the server.php as required to provide a database connection Modify the server.php as required to provide a database connection
Line 28: Line 36:
  
 ===== Client Side Usage ===== ===== Client Side Usage =====
-Configuration of the client side differs only slightly from the normal ADOdb configuration.+Configuration of the client side differs only slightly from the normal ADOdb configuration. ​For information about the client side driver, see [[v5:​database:​proxy|Proxy Client]]
  
 <code php> <code php>
Line 59: Line 67:
 * Create an SQL command * Create an SQL command
 */ */
-$SQL = "​SELECT * FROM employees";​+$sql = "​SELECT * FROM employees";​
  
 /* /*
Line 67: Line 75:
 while ($r = $result->​fetchRow()) while ($r = $result->​fetchRow())
   print_r($r);​   print_r($r);​
 +
 +
  
 </​code>​ </​code>​
  
 ===== Limitations ===== ===== Limitations =====
 +  * Access currently limited to http protocol
 +  * No access to meta functions
 +  * No rollback or transactional control
 +  * No parameter binding allowed
 +  * server.php must be modified in-situ
 +
v5/proxy/proxy_index.1499706418.txt.gz · Last modified: 2017/07/10 19:06 by mnewnham