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

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
v5:proxy:proxy_index [2017/07/10 19:16] mnewnhamv5:proxy:proxy_index [2020/01/04 16:44] – [Introduction] security warning dregad
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 =====
Line 27: 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 58: Line 67:
 * Create an SQL command * Create an SQL command
 */ */
-$SQL = "SELECT * FROM employees";+$sql = "SELECT * FROM employees";
  
 /* /*
Line 66: Line 75:
 while ($r = $result->fetchRow()) while ($r = $result->fetchRow())
   print_r($r);   print_r($r);
 +
 +
  
 </code> </code>
Line 72: Line 83:
   * Access currently limited to http protocol   * Access currently limited to http protocol
   * No access to meta functions   * No access to meta functions
-  * No rollback control+  * No rollback or transactional control
   * No parameter binding allowed   * No parameter binding allowed
   * server.php must be modified in-situ   * server.php must be modified in-situ
  
v5/proxy/proxy_index.txt · Last modified: 2021/08/22 13:17 by dregad