- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

adodb_index

# ADOdb

ADOdb is a fast, easy to use, popular database abstraction layer for PHP. It allows the same code to be used when accessing a wide range of databases. It has been actively maintained since 2000 by the project's founder and numerous community contributors. ADOdb contains components for querying and updating databases, as well as an Object Orientated Active Record library, schema management and performance monitoring. It also contains the following standalone extensions:

- A Date/Time library to handle dates outside of the normal PHP limits.
- A Session Management library that extends the normal PHP functionality to allow storing of session management data in a database, or in encrypted values

Current Production Release

### How To Ask For Help

You can post an issue in the Github issue tracker.

To help with quick resolution:

- Try running the code with Debug Mode enabled
- Give the version of ADOdb you are using. Please check the top of this page for the earliest release that is supported by the community.
- Give the version of PHP you are using, the operating system, the driver and the database version.
- Provide a code snippet, and if possible a description of what you are expecting to receive from a function

You can also ask questions on

- Stack Overflow using a tag of adodb-php
- gitter, community adodb/adodb

## Copyright

2000-2013 © John Lim
2014- © Damien Regad, Mark Newnham & The ADOdb Community

ADODb is dual-licensed under the BSD and Lesser GPL license, with the BSD License having priority

## Page Index

# ADOdb

- ADOdb
- ADOdb
- project
  - Documentation
  - Change Log
  - Include File Guide
  - Coding Standards
  - The ADOdb User Base
  - ADOdb Version 5 Development
  - ADOdb Version 6 Development
- Resources
- v5
  - ADOdb Active Record
    - Active Record Tutorial
    - ADOdb Active Record
    - belongsTo
    - classBelongsTo
    - classHasMany
    - Setting the Database Connection
    - ActiveRecord Code Sample
    - $_dbat
    - Active Record eXtended
    - find
    - getActiveRecords
    - getActiveRecordsClass
    - getAttributeNames
    - hasMany
    - ADOdb Active Record
    - lastInsertId
    - load
    - loadRelations
    - $lockMode
    - $_quoteNames
    - replace
    - save
    - set
    - setDatabaseAdaptor
    - $_table
    - tableBelongsTo
    - tableHasMany
    - tableKeyBelongsTo
    - tableKeyHasMany
    - $_where
  - Unsupported Addons
    - Unsupported Addons
    - Unsupported Addons
    - The xmlrpc interface
  - ADOdb XML Schema
    - adoSchema
    - AXMLS Function Reference
    - ADOdb-xmlschema
    - continueOnError
    - convertSchemaFile
    - convertSchemaString
    - destroy
    - executeInline
    - executeSchema
    - extractSchema
    - ADOdb XML Schema
    - parseSchema
    - parseSchemaFile
    - parseSchemaString
    - printSql
    - removeSchema
    - removeSchemaString
    - saveSql
    - schemaFileVersion
    - schemaStringVersion
    - setPrefix
    - setUpgradeMethod
  - Index Of Database Drivers
    - Microsoft Access
    - ADO
    - The Connection Matrix
    - CSV File
    - Feature Comparison Matrix
    - Firebird & Interbase
    - Frontbase
    - IBM DB2
    - Index Of Database Drivers
    - IBM Informix
    - LDAP
    - Microsoft SQL Server
    - MySQL
    - ODBC
    - ODBTP
    - Oracle
      - bind
      - executeCursor
    - Oracle
    - PDO
    - PostgreSQL
    - SAP Advantage Database Server
    - SAP Adaptive Server Enterprise
    - SAP MaxDB
    - SAP SQLAnywhere
    - SQLite Database
    - Plain Text
    - Visual Foxpro
  - ADOdb Date/Time Library
    - adodb_date
    - adodb_date2
    - $ADODB_DATE_LOCALE
    - adodb_getdate
    - adodb_gmdate
    - adodb_gmmktime
    - adodb_gmstrftime
    - adodb_mktime
    - adodb_strftime
    - adodb_time
    - ADOdb Date/Time Libaray
    - ADOdb Date/Time Library
  - Data Dictionary
    - actualType
    - addColumnSql
    - adoFieldObject
    - alterColumnSql
    - changeTableSql
    - Dictionary Column Attributes
    - createDatabase
    - createIndexSql
    - createTableSql
    - The Data Dictionary
    - dropColumnSql
    - dropIndexSql
    - dropTableSql
    - executeSqlArray
    - getCommentSql
    - getTableCasing
    - Data Dictionary
    - metaColumnNames
    - metaColumns
    - metaDatabases
    - metaForeignKeys
    - metaIndexes
    - metaPrimaryKeys
    - metaProcedures
    - metaTables
    - metaTransaction
    - metaType
    - renameColumnSql
    - renameTableSql
    - serverInfo
    - setCommentSql
    - setTableCasing
    - ADOdb-xmlschema
  - Performance Monitoring
    - clearSql
    - cpuLoad
    - expensiveSql
    - healthCheck
    - healthCheckCli
    - Performance Monitoring
    - invalidSql
    - logSql
    - Performance Monitoring
    - suspiciousSql
    - uI
  - Reference Manual
    - $ADODB_ANSI_PADDING_OFF
    - ADODB_ASSOC_CASE
    - $ADODB_CACHE_CLASS
    - $ADODB_CACHE_DIR
    - $ADODB_COUNTRECS
    - $ADODB_FETCH_MODE
    - $ADODB_FORCE_TYPE
    - $ADODB_GETONE_EOF
    - $ADODB_LANG
    - $ADODB_QUOTE_FIELDNAMES
    - Connection Reference Manual
      - addQ
      - adoNewConnection
      - affected_rows
      - autoExecute
      - beginTrans
      - bindDate
      - bindTimeStamp
      - blobDecode
      - blobEncode
      - cacheExecute
      - cacheFlush
      - cacheGetAll
      - cacheGetAssoc
      - cacheGetCol
      - cacheGetOne
      - cacheGetRow
      - cachePageExecute
      - cacheSelectLimit
      - charMax
      - close
      - commitTrans
      - completeTrans
      - concat
      - connect
      - createSequence
      - currentRow
      - dbDate
      - dbTimeStamp
      - dropSequence
      - errorMsg
      - execute
      - failTrans
      - fetchInto
      - fnExecute & fnCacheExecute
      - genId
      - getAll
      - getArray
      - getAssoc
      - getCol
      - getFetchMode
      - getInsertSql
      - getMedian
      - getOne
      - getRandRow
      - getRow
      - getRowAssoc
      - getUpdateSql
      - hasFailedTrans
      - ifNull
      - ignoreErrors
      - Connection Reference Manual
      - inParameter
      - insert_Id
      - isConnected
      - lastPageNo
      - metaError
      - metaErrorMsg
      - moveLast
      - moveNext
      - nConnect
      - offsetDate
      - outParameter
      - pageExecute
      - param
      - pConnect
      - po_recordCount
      - prepare
      - prepareSp
      - qStr
      - recordCount
      - replace
      - rollbackTrans
      - rowLock
      - rsFilter
      - selectDb
      - selectLimit
      - setCharSet
      - setConnectionParameter
      - setDateLocale
      - setFetchMode
      - setTransactionMode
      - sqlDate
      - startTrans
      - textMax
      - unixDate
      - unixTimeStamp
      - updateBlob
      - updateBlobFile
      - updateClob
      - userDate
      - userTimeStamp
    - Reference Manual
    - Recordset Methods Reference Manual
      - absolutePage
      - atFirstPage
      - atLastPage
      - fetchField
      - fetchNextObj
      - fetchObj
      - fetchRow
      - fieldCount
      - fields
      - fieldTypesArray
      - getMenu
      - getMenu2
      - getMenu3
      - Recordset Methods Reference Manual
      - maxRecordCount
      - move
      - moveFirst
      - nextRecordSet
      - numCols
      - numRows
    - Reference Manual
  - Session Management
    - Session Management
    - Session Management
    - Upgrading From V1 ADOdb Session Handling
  - User Guide
    - ADOdb Active Record
    - Maximum String Lengths
    - Debug Mode
    - Error Handling In ADOdb
    - Building Extensions
    - User Guide
    - Caching Result Sets
    - Memcached Setup
    - Tutorial
    - Author Credit
    - Tips on Writing Portable SQL Using ADOdb
    - Stored Procedure Example
    - Transaction Handling In ADOdb
    - ADOdb User Guide

adodb_index.txt · Last modified: 2016/01/13 16:27 by mnewnham

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top