ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
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:09] – 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 =====
   * 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>
Line 73: 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
   * 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