v5:proxy:proxy_index
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:proxy:proxy_index [2017/07/10 19:16] – mnewnham | v5:proxy:proxy_index [2021/08/22 13:17] (current) – [ADOdb Proxy Server] deprecation in 5.22.0 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 5.22.0. It could be reinstated, if the community contributes with necessary security enhancements, | ||
+ | </ | ||
+ | |||
===== 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. | ||
+ | </ | ||
===== 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. |
<code php> | <code php> | ||
Line 58: | Line 67: | ||
* Create an SQL command | * Create an SQL command | ||
*/ | */ | ||
- | $SQL = " | + | $sql = " |
/* | /* | ||
Line 66: | Line 75: | ||
while ($r = $result-> | while ($r = $result-> | ||
print_r($r); | print_r($r); | ||
+ | |||
+ | |||
</ | </ | ||
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 |
* 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.1499706971.txt.gz · Last modified: 2017/07/10 19:16 by mnewnham