Resources
- Full support
- Partial support
User Tools
Sidebar
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
Latest Documentation 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
Recent Changes To Documentation
- PHP Compatibility Status [PHP 8] PHP 8.1 support
- releaseStatement Available since 5.22
- Reference Manual Prepared Statements table: added releaseStatement()
Page Index
ADOdb - Database Abstraction Layer for PHP
- Administration
- ADOdb
- project
- sidebar
- v5
- ADOdb Active Record
- ADOdb Active Record
- Active Record Tutorial
- belongsTo
- classBelongsTo
- classHasMany
- Setting the Database Connection
- ActiveRecord Code Sample
- $_dbat
- Active Record eXtended
- find
- getActiveRecords
- getActiveRecordsClass
- getAttributeNames
- hasMany
- lastInsertId
- load
- loadRelations
- $lockMode
- $_quoteNames
- replace
- save
- set
- setDatabaseAdaptor
- $_table
- tableBelongsTo
- tableHasMany
- tableKeyBelongsTo
- tableKeyHasMany
- $_where
- Unsupported Addons
- ADOdb XML Schema
- ADODb Connection Manager
- Index Of Database Drivers
- Microsoft Access
- ADO
- The Connection Matrix
- Feature Comparison Matrix
- Firebird & Interbase
- Frontbase
- IBM DB2
- IBM Informix
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- PostgreSQL
- SAP Advantage Database Server
- SAP Adaptive Server Enterprise
- SAP MaxDB
- SAP SQLAnywhere
- SQLite Database
- Sybase
- Plain Text
- Visual Foxpro
- Proxy
- Unsupported Drivers
- List of Drivers To Be Removed / Merged
- Supported Databases
- Legacy MySQL drivers
- 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
- metaColumnNames
- metaColumns
- metaDatabases
- metaForeignKeys
- metaIndexes
- metaPrimaryKeys
- metaProcedures
- metaTables
- metaTransaction
- metaType
- renameColumnSql
- renameTableSql
- serverInfo
- setCommentSql
- setTableCasing
- Structured Schema Management
- ADOdb-xmlschema
- setActualType
- getActualType
- learn_extensions
- extend_existing
- ADOdb Load Balancer
- Performance Monitoring
- Reference Manual
- $ADODB_ANSI_PADDING_OFF
- ADODB_ASSOC_CASE
- $ADODB_CACHE_CLASS
- $ADODB_CACHE_DIR
- $ADODB_COUNTRECS
- ADODB_DEFAULT_METATYPE
- $ADODB_FETCH_MODE
- $ADODB_FORCE_TYPE
- $ADODB_GETONE_EOF
- $ADODB_LANG
- $ADODB_QUOTE_FIELDNAMES
- Connection Reference Manual
- addQ
- The ADORecordSet_array Object
- 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
- day
- dbDate
- dbTimeStamp
- dow
- dropSequence
- errorMsg
- execute
- failTrans
- fetchInto
- fnExecute & fnCacheExecute
- genId
- getAll
- getArray
- getAssoc
- getCol
- getFetchMode
- getInsertSql
- getMedian
- getOne
- getRandRow
- getRow
- getRowAssoc
- getUpdateSql
- hasFailedTrans
- ifNull
- ignoreErrors
- inParameter
- insert_Id
- isConnected
- lastPageNo
- metaError
- metaErrorMsg
- month
- 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
- substr
- textMax
- transCnt
- transOff
- unixDate
- unixTimeStamp
- updateBlob
- updateBlobFile
- updateClob
- userDate
- userTimeStamp
- year
- Quote
- setCustomMetaType
- getCustomMetaTypes
- getCharSet
- Public Properties Of The Connection
- releaseStatement
- loadbalancer
- Recordset Methods Reference Manual
- Reference Manual
- Logging
- $ADODB_COMPAT_FETCH
- Session Management
- Session Management Reference
- $ADODB_SESSION_EXPIRE_NOTIFY
- adodb_session_regenerate_id
- $ADODB_SESS_CONN
- adodb_unserialize
- ADOdb_Session::clob
- ADOdb_Session::config
- ADOdb_Session::database
- ADOdb_Session::debug
- ADOdb_Session::driver
- ADOdb_Session::encryptionKey
- ADOdb_Session::expireNotify
- ADOdb_Session::filter
- ADOdb_Session::host
- ADOdb_Session::lifetime
- ADOdb_Session::optimize
- ADOdb_Session::password
- ADOdb_Session::persist
- ADOdb_Session::table
- ADOdb_Session::user
- Session Management
- Upgrading From V1 ADOdb Session Handling
- Session Management Reference
- User Guide
- ADOdb Active Record
- Maximum String Lengths
- Debug Mode
- Deprecated Functionality
- Error Handling In ADOdb
- learn_abstraction
- learn_bind
- learn_caching
- learn_dictionary
- learn_extensions
- learn_fields
- learn_multidatabase
- Caching Result Sets
- Memcached Setup
- Moving from MySQL to ADOdb
- ADOdb & Oracle
- Tips on Writing Portable SQL Using ADOdb
- Stored Procedure Example
- Transaction Handling In ADOdb
- User Guide
- proxy
- PHP Compatibility Status
- ADOdb Active Record
- Changes To ADORecordset_array
adodb_index.txt · Last modified: 2016/03/05 23:12 by mnewnham
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
