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:09] mnewnhamv5:proxy:proxy_index [2019/12/28 03:51] mnewnham
Line 6: Line 6:
   * 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 27:
  
 ===== 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 58:
 * Create an SQL command * Create an SQL command
 */ */
-$SQL = "SELECT * FROM employees";+$sql = "SELECT * FROM employees";
  
 /* /*
Line 67: Line 66:
 while ($r = $result->fetchRow()) while ($r = $result->fetchRow())
   print_r($r);   print_r($r);
 +
 +
  
 </code> </code>
Line 73: Line 74:
   * 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