ADOdb Version 6

This description relates to prototype versions of ADOdb Version 6 and is subject to change

About ADOdb Version 6

ADOdb Version 6 is a major refactoring (not rewrite) of the main portion of the ADOdb code into a PSR Compliant codebase Its focus is on the main Database Extraction features, as well as Meta Functions, The Data Dictionary, and Session management. All of the additional addons and deprecated drivers have been removed, even though the product is generally backwards compatible with version 5.

Highlights

PHP Version

The minimum required version of PHP for this product is 8.3

Logging

The format of logging messages has changed, to replicate the standard syslog format. This means they can be consumed by log management applications.

Autoloading

ADOdb becomes a PSR level 4 autoload library. An appropriate autoloader class is required.

Data Quality

All methods are now type hinted, both on input and output variables. This allows us to eliminate unexpected return types. In addition, all internal methods are now protected.

Footprint

By moving the code of most of the methods from the core files into JIT loadable classes, the footprint of ADOdb becomes much smaller

Example Connections

Understanding Version 6 Connections

ADOdb Version 5

define('ADODB_FETCH_MODE',1);
define('ADODB_ASSOC_CASE',0);
 
include 'adodb/adodb.inc.php';
 
$db = newADOConnection('mysqli');
 
$db->connect('localhost','user','password','database');

ADOdb Version 6 Equivalent Connection

$definitions = new ADOdb\ADOConnectionDefinitions;
$definitions->driver = 'mysqli';
$definitions->fetchMode = $definitions::ADODB_FETCH_ASSOC;
$definitions->assocCase = $definitions::ADODB_ASSOC_CASE_UPPER;
 
$obj = new ADOdb\connector($definitions);
 
$db = $obj->connect('localhost','user','password','database');

Session Management Module

The session management module is now an integrated part of the ADOdb core object. It is now substantially easier to add additional modules such as compression or encryption. The session information can be me unserialized with standard PHP function. The session class itself can be extended much more easily. For more information, see Session Management With V6

Results Caching Service

The caching service supports connections via Memcache servers or APCu . Connections via disk service are no longer supported. For more information see V6 Caching Services

Methods removed in this release

  1. Anything to do with magic quotes
  2. Anything to do with file based caching. Only memcache is supported.
  3. ADOConnection::transpose()
  4. q() - use quote()
  5. errorNative() - use errorNo()
  6. nextId() - use genId()
  7. query() - use execute()
  8. limitQuery() use selectLimit()
  9. disconnect() - use close()
  10. unixDate() - No longer a static method
  11. escape() - use addQ
  12. commitLock() - use commitTrans()
  13. rollBackLock() - use rollBackTrans()
  14. getRows() - use getArray()
  15. free() - use close
  16. numRows() - use recordCount
  17. numcols() - use fieldcount
  18. absolutePosition() - use currentRow()
  19. setConnectionParameter - use ADOOemFlags class
  20. po_Insert_ID() - Also supported databases support insert_id()

Other Changes

  1. $transCnt and $transOff are no longer public, use getTransCnt/setTransCnt getTransOff/setTransOff instead
  2. undocumented constant ADODB_NEVER_PERSIST removed
  3. Pear compatibility removed
  4. Pear ADODB_COMPAT_FETCH removed

Pages in this namespace