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
Next revisionBoth sides next revision
v5:proxy:proxy_index [2017/07/10 19:16] mnewnhamv5:proxy:proxy_index [2020/01/04 16:39] – Deprecated per discussion in PR #444 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.
Line 27: Line 31:
  
 ===== 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 62:
 * Create an SQL command * Create an SQL command
 */ */
-$SQL = "SELECT * FROM employees";+$sql = "SELECT * FROM employees";
  
 /* /*
Line 66: Line 70:
 while ($r = $result->fetchRow()) while ($r = $result->fetchRow())
   print_r($r);   print_r($r);
 +
 +
  
 </code> </code>
Line 72: Line 78:
   * 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