ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


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
index [2020/01/14 11:21] – Change titles/subtitles level, move Announcements section further down the page dregadindex [2024/01/24 08:14] (current) – [Thanks] updated URL for JetBrains open source licenses dregad
Line 1: Line 1:
 ====== ADOdb - Database Abstraction Layer for PHP ====== ====== ADOdb - Database Abstraction Layer for PHP ======
  
-ADOdb is a fast, easy to use, popular database abstraction layer for [[wp>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 [[https://github.com/ADOdb/ADOdb/graphs/contributors|community contributors]]. ADOdb contains components for querying and updating databases, as well as an Object Orientated [[v5:activerecord:activerecord_index|Active Record]] library, schema management and performance monitoring. It also contains the following standalone extensions:+<WRAP right>[[https://github.com/ADOdb/ADOdb|{{:github-mark-64px.png?45|ADOdb Project on GitHub}}]]</WRAP>
  
-  * A [[v5:datetime:datetime_index|Date/Time]] library to handle dates outside of the normal PHP limits.+ADOdb is a fast, easy to use, popular database abstraction layer for [[wp>PHP]]. It allows the same code to be used when accessing a [[v5:database:supported|wide range of databases]].  
 + 
 +It has been actively maintained since 2000 by the project's founder, John Lim, who decided to retire in 2013. Damien Regad and Mark Newnham took over the project, with the help of numerous [[https://github.com/ADOdb/ADOdb/graphs/contributors|community contributors]].  
 + 
 +ADOdb contains components for querying and updating databases, as well as an Object Orientated [[v5:activerecord:activerecord_index|Active Record]] library, schema management and performance monitoring. It also contains the following standalone extensions: 
 + 
 +  * A (deprecated) [[v5:datetime:datetime_index|Date/Time]] library to handle dates outside of the normal PHP limits.
   * A [[v5:session:session_index|Session Management]] library that extends the normal PHP functionality to allow storing of session management data in a database, or in encrypted values   * A [[v5:session:session_index|Session Management]] library that extends the normal PHP functionality to allow storing of session management data in a database, or in encrypted values
  
 Note that ADOdb is not a replacement for the [[http://php.net/manual/en/refs.database.php|native PHP database extensions]], but is built on top of them. This means that the corresponding driver(s) must be installed and correctly configured for ADOdb to work. Note that ADOdb is not a replacement for the [[http://php.net/manual/en/refs.database.php|native PHP database extensions]], but is built on top of them. This means that the corresponding driver(s) must be installed and correctly configured for ADOdb to work.
  
-<WRAP right 380px box round>+<WRAP right 340px box round>
 <wrap> <wrap>
-[[http://sourceforge.net/projects/adodb/files/latest/download|{{:download-big.png|Download the latest version}}]]</wrap> +[[https://sourceforge.net/projects/adodb/files/latest/download|{{:download-big.png|Download the latest stable release from SourceForge}}]]</wrap> 
-<wrap padding-left:10px> **Current Production Release**+<wrap padding-left:10px> **Stable Release**
 </wrap> \\ </wrap> \\
 <wrap> <wrap>
-[[https://sourceforge.net/projects/adodb/files/Documentation/|{{:download-big.png|Download the latest documentation}}]]</wrap> +[[https://sourceforge.net/projects/adodb/files/adodb-php5-only/adodb-5.21/|{{:download-big.png|Download the previous Stable release from SourceForge}}]]</wrap> 
-<wrap padding-left:10px> **Latest Documentation**+<wrap padding-left:10px> **Legacy Release** 
 +</wrap> \\ 
 +<wrap> 
 +[[https://sourceforge.net/projects/adodb/files/Documentation/|{{:download-big.png|Download the documentation from SourceForge}}]]</wrap> 
 +<wrap padding-left:10px> **Documentation**
 </wrap> </wrap>
 +
  
 == Current Status == == Current Status ==
 ^ Description                 ^ Version                                                                        ^ ^ Description                 ^ Version                                                                        ^
-Earliest Supported Release 5.20.13                                                                       | +Stable Release [[https://github.com/ADOdb/ADOdb/releases/latest|5.22.7]]                     
-| Current Production Release  | 5.20.16                                                                       | +Legacy Release((This is the earliest supported release - **Security and critical bug fixes only**)) | [[https://github.com/ADOdb/ADOdb/releases/v5.21.4|5.21.4]]                    
-| Development Track           | [[project:version_5_development|Version 5]]                                   +Older, unsupported Releases | [[https://sourceforge.net/projects/adodb/files/adodb-php5-only/|SourceForge]]  
-Development Track           | [[project:version_6_development|Version 6]]                                   +| Production Track            | [[project:version_5_development|Version 5]]                       | 
-Prior Releases              | [[https://sourceforge.net/projects/adodb/files/adodb-php5-only/|SourceForge]] | +| Development Track           [[project:version_6_development|Version 6]]                       |
-<php> +
-print '<div style="width:100%;text-align:center"> +
-<a href="https://twitter.com/ADOdb_announce" class="twitter-follow-button" data-show-count="false" data-size="large">Follow @ADOdb_announce</a></div> +
-'; +
-print " +
-<script type='text/javascript'>/*<![CDATA[*/!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document, 'script', 'twitter-wjs'); +
-/*!]]>*/</script> +
-+
-+
-</php>+
  
 +<WRAP center 80%>
 +<wrap left>
 +[[https://twitter.com/ADODB_announce|{{:2021_twitter_logo_-_blue.png?50|Follow @ADODB_announce on 
 +Twitter}}]]
 +</wrap>
 +Follow us on Twitter \\
 +**[[https://twitter.com/ADODB_announce|@ADODB_announce]]**
 </WRAP> </WRAP>
 +
 +<WRAP center 80%>
 +<wrap left>
 +[[https://phpc.social/@adodb|{{:mastodon-logo.svg?50|Follow @adodb on Mastodon}}]]
 +</wrap>
 +We are also **[[https://phpc.social/@adodb|@adodb]]** \\
 +on Mastodon's //phpc.social// community.
 +</WRAP>
 +
 +</WRAP>
 +
  
 ===== Installation ===== ===== Installation =====
  
-==== System requiremetns ====+==== System requirements ====
  
-ADOdb runs on all active versions of PHP including [[v5:php7_status|PHP 7]].+ADOdb is compatible with and supported on all [[https://www.php.net/supported-versions|active versions of PHP]] (>= 7.4 as of this writing), including PHP 8.2.  
 +See [[v5:php_compatibility_status]] for further details.
  
-==== Installation Via Composer ==== +It is expected to work as well on earlier, legacy PHP versions per table below, but this is not officially supported or tested. 
-=== Production === + 
-''composer require adodb/adodb-php ^5.20'' + 
-=== Development === +<WRAP left> 
-''composer require adodb/adodb-php dev-master''+ADOdb version  ^ Earliest PHP version 
 +5.22           | 7.0                   | 
 +| 5.21           | 5.5.9                 | 
 +| 5.20           | 5.3.2                 | 
 +</WRAP>
  
 ==== Manual Installation ==== ==== Manual Installation ====
-Download and unpack into the directory of choice.+ 
 +Download the software using the links on the right, and unpack it into the directory of your choice. 
 + 
 +==== Installation Via Composer ==== 
 + 
 +This is the recommended installation method. 
 +ADOdb is available on [[https://packagist.org/packages/adodb/adodb-php|Packagist]]. 
 + 
 +<WRAP clear></WRAP> 
 + 
 +=== Current Production Release === 
 +  composer require adodb/adodb-php ^5.22 
 +   
 +=== Latest Development Branch === 
 +  composer require adodb/adodb-php dev-master 
  
 ===== Support ===== ===== Support =====
  
 ==== Project Location ==== ==== Project Location ====
-The source code and bug tracker are located at [[https://github.com/ADOdb/ADOdb|Github]]. +<WRAP right>[[https://github.com/ADOdb/ADOdb|{{:github-mark-64px.png|ADOdb Project on GitHub}}]]</WRAP> 
-See also the [[https://sourceforge.net/projects/adodb/|SourceForge project page]].+ADOdb'source code and bug tracker are located at [[https://github.com/ADOdb/ADOdb|Github]]. 
 + 
 +See also the legacy [[https://sourceforge.net/projects/adodb/|SourceForge project page]], where you can download the official release zip / tarballs.
  
 ==== How To Ask For Help === ==== How To Ask For Help ===
Line 73: Line 114:
   * [[https://gitter.im/ADOdb/ADOdb|gitter]], community adodb/adodb    * [[https://gitter.im/ADOdb/ADOdb|gitter]], community adodb/adodb 
  
- 
------------------------------ 
  
 ==== Why Don't You Support Earlier Versions? ==== ==== Why Don't You Support Earlier Versions? ====
  
-We have limited resources, and unfortunately can't afford to maintain the older versions in parallel with the current stable releases and the development track. +We are a very small team with very limited resources, and unfortunately can't afford to maintain the older versions in parallel with the current stable releases and the development track.
  
-Version 5.20.0 was released in November 2015you should be at least to that point, and we strongly recommend to apply the latest hotfix release.. +For the same reason, we decided to drop [[v5:php_compatibility_status|compatibility with old PHP versions]] as it was getting increasingly difficult to maintain it while adapting to the latest changesThis allows us to leverage new language features, make use of 3rd party libraries, and reduce maintenance effort at the same time.
  
 +We strongly recommend that you **always run the [[https://github.com/ADOdb/ADOdb/releases/latest|latest stable release]]**, which is the only one that is actively maintained; this includes bug fixes and compatibility updates for newer PHP versions.
 +
 +Legacy version 5.21.0 was released in February 2021, and only receives **security and critical bug fixes**. If you are still running an older version, you should at the very least upgrade to that, and we actually strongly advise to apply the latest hotfix release ([[https://github.com/ADOdb/ADOdb/blob/v5.21.4/docs/changelog.md|5.21.4]]). 
  
 ==== Our Community ==== ==== Our Community ====
-The ADOdb user base is large, with an average of 300 downloads a week. We have put together a short [[project:user_base|list of some current projects]]. + 
 +The ADOdb user base is large, with an average of 300 downloads a week. We have put together a short [[project:user_base|list of some current projects]]. See also the [[https://github.com/ADOdb/ADOdb/network/dependents|dependencies]], i.e. the list of GitHub repositories require ADOdb in their //composer.json// file.
  
 You are welcome to contribute to the project and help the Open Source community: You are welcome to contribute to the project and help the Open Source community:
  
-  * Share your experience+  * Share your experience, e.g. on Twitter [[https://twitter.com/ADOdb_announce|@ADOdb_announce]]
   * [[https://github.com/ADOdb/ADOdb/issues|Answer user questions in the issue tracker]]   * [[https://github.com/ADOdb/ADOdb/issues|Answer user questions in the issue tracker]]
   * Submit your bug fixes, enhancements or new features via [[https://github.com/ADOdb/ADOdb/compare|GitHub pull requests]]   * Submit your bug fixes, enhancements or new features via [[https://github.com/ADOdb/ADOdb/compare|GitHub pull requests]]
Line 96: Line 139:
 ===== Announcements ===== ===== Announcements =====
  
-Follow us on **[[https://twitter.com/ADOdb_announce|@ADOdb_announce]]** on twitter. We post notices of new releases and important bug fixes first there.+Follow us on **[[https://twitter.com/ADOdb_announce|@ADOdb_announce]]** on Twitter. We post notices of new releases and important bug fixes first there.
  
-| 12/01/2020  | ADOdb version 5.20.16 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.16/docs/changelog.md|Full Changelog]]  +^ Date        ^ Description                                                                                                                                                                            ^ 
-| 24/11/2019  | ADOdb version 5.20.15 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.15/docs/changelog.md|Full Changelog]]  +| 04/11/2023  | ADOdb version 5.22.7 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.22.7/docs/changelog.md|Full Changelog]]                                                      | 
-| 06/01/2019  | ADOdb version 5.20.14 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.14/docs/changelog.md|Full Changelog]]  +| 11/06/2023  | ADOdb version 5.22.6 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.22.6/docs/changelog.md|Full Changelog]]                                                      | 
-| 06/08/2018  | ADOdb version 5.20.13 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.13/docs/changelog.md|Full Changelog]]  +| 03/04/2023  | ADOdb version 5.22.5 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.22.5/docs/changelog.md|Full Changelog]]                                                      | 
-| 30/03/2018  | ADOdb version 5.20.12 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.12/docs/changelog.md|Full Changelog]] \\ Note that 5.20.11 has been withdrawn due to a bug on PHP 5.x | +| 28/10/2022  | ADOdb version 5.22.4 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.22.4/docs/changelog.md|Full Changelog]]                                                      | 
-| 08/03/2018  | ADOdb version 5.20.10 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.10/docs/changelog.md|Full Changelog]]  +| 06/09/2022  | ADOdb version 5.22.3 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.22.3/docs/changelog.md|Full Changelog]]                                                      | 
-| 21/12/2016  | ADOdb version 5.20.9 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.9/docs/changelog.md|Full Changelog]]  +| 08/05/2022  | ADOdb version 5.22.2 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.22.2/docs/changelog.md|Full Changelog]]                                                      | 
-| 17/12/2016  | ADOdb version 5.20.8 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.8/docs/changelog.md|Full Changelog]]  +| 30/03/2022  | ADOdb version 5.22.1 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.22.1/docs/changelog.md|Full Changelog]]                                                      | 
-| 20/09/2016  | ADOdb version 5.20.7 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.7/docs/changelog.md|Full Changelog]]  +| 08/02/2022  | ADOdb version 5.22.0 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.22.0/docs/changelog.md|Full Changelog]]                                                      | 
-| 31/08/2016  | ADOdb version 5.20.6 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.6/docs/changelog.md|Full Changelog]]  +| 22/01/2022  | ADOdb versions 5.20.21 and 5.21.4 are available. [[https://github.com/ADOdb/ADOdb/blob/v5.21.4/docs/changelog.md|Full Changelog]]                                                      | 
-| 10/08/2016  | ADOdb version 5.20.5 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.5/docs/changelog.md|Full Changelog]]  +| 31/10/2021  | ADOdb version 5.21.3 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.21.3/docs/changelog.md|Full Changelog]]                                                      | 
-| 09/04/2016  | ADOdb version 5.20.4 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.4/docs/changelog.md|Full Changelog]]  +| 22/08/2021  | ADOdb version 5.21.2 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.21.2/docs/changelog.md|Full Changelog]]                                                      | 
-| 01/01/2016  | ADOdb version 5.20.3 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.3/docs/changelog.md|Full Changelog]]  +| 15/08/2021  | ADOdb version 5.21.1 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.21.1/docs/changelog.md|Full Changelog]]                                                      | 
-| 27/12/2015  | ADOdb version 5.20.2 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.2/docs/changelog.md|Full Changelog]]  +| 27/02/2021  | ADOdb version 5.21.0 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.21.0/docs/changelog.md|Full Changelog]]                                                      | 
-| 06/12/2015  | ADOdb version 5.20.1 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.1/docs/changelog.md|Full Changelog]]  |+| 02/02/2021  | ADOdb version 5.21.0-rc.1 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.21.0-rc.1/docs/changelog.md|Full Changelog]]                                                      | 
 +| 31/01/2021  | ADOdb version 5.20.20 available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.20/docs/changelog.md|Full Changelog]]                                                                  | 
 +| 20/12/2020  | ADOdb version 5.21.0-beta.1 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.21.0-beta.1/docs/changelog.md|Full Changelog]]                                                      | 
 +| 13/12/2020  | ADOdb version 5.20.19 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.19/docs/changelog.md|Full Changelog]]                                                                  | 
 +| 28/06/2020  | ADOdb version 5.20.18 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.18/docs/changelog.md|Full Changelog]]                                                                  | 
 +| 31/03/2020  | ADOdb version 5.20.17 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.17/docs/changelog.md|Full Changelog]]                                                                  | 
 +| 12/01/2020  | ADOdb version 5.20.16 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.16/docs/changelog.md|Full Changelog]]                                                                  
 +| 24/11/2019  | ADOdb version 5.20.15 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.15/docs/changelog.md|Full Changelog]]                                                                  
 +| 06/01/2019  | ADOdb version 5.20.14 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.14/docs/changelog.md|Full Changelog]]                                                                  
 +| 06/08/2018  | ADOdb version 5.20.13 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.13/docs/changelog.md|Full Changelog]]                                                                  
 +| 30/03/2018  | ADOdb version 5.20.12 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.12/docs/changelog.md|Full Changelog]] \\ Note that 5.20.11 has been withdrawn due to a bug on PHP 5.x  
 +| 08/03/2018  | ADOdb version 5.20.10 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.10/docs/changelog.md|Full Changelog]]                                                                  
 +| 21/12/2016  | ADOdb version 5.20.9 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.9/docs/changelog.md|Full Changelog]]                                                                    
 +| 17/12/2016  | ADOdb version 5.20.8 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.8/docs/changelog.md|Full Changelog]]                                                                    
 +| 20/09/2016  | ADOdb version 5.20.7 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.7/docs/changelog.md|Full Changelog]]                                                                    
 +| 31/08/2016  | ADOdb version 5.20.6 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.6/docs/changelog.md|Full Changelog]]                                                                    
 +| 10/08/2016  | ADOdb version 5.20.5 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.5/docs/changelog.md|Full Changelog]]                                                                    
 +| 09/04/2016  | ADOdb version 5.20.4 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.4/docs/changelog.md|Full Changelog]]                                                                    
 +| 01/01/2016  | ADOdb version 5.20.3 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.3/docs/changelog.md|Full Changelog]]                                                                    
 +| 27/12/2015  | ADOdb version 5.20.2 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.2/docs/changelog.md|Full Changelog]]                                                                    
 +| 06/12/2015  | ADOdb version 5.20.1 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.1/docs/changelog.md|Full Changelog]]                                                                    | 
 +| 28/11/2015  | ADOdb version 5.20.0 is available. [[https://github.com/ADOdb/ADOdb/blob/v5.20.0/docs/changelog.md|Full Changelog]]                                                                    |
  
 ===== Miscellaneous ===== ===== Miscellaneous =====
Line 118: Line 182:
 ==== Tags ==== ==== Tags ====
 ~~TAGCLOUD~~ ~~TAGCLOUD~~
 +
 +==== Copyright ====
 +
 +2000-2013 (c) John Lim\\
 +2014 (c) Damien Regad, Mark Newnham & The ADOdb Community
 +
 +ADODb is dual-licensed under the BSD and Lesser GPL license, with the BSD License having priority.
 +
 +{{htmlmetatags>metatag-keywords=(php, programming, database, abstraction, layer, mysql, microsoft,sql,server, oracle, ibm, db2, firebird, interbase, postgres, postgresql, linux, ibase, code, simplicity, portable, sap, maxdb, adaptive, informix, odbc, XML, active, record, session, management, date, time, library, active, record)}}
 +{{htmlmetatags>metatag-description=(ADOdb is a database abstraction layer for PHP. Compatible with most supported databases, it provides an easy way to use the same code against all databases, Portable code can be written that runs unchanged. It also simplifies PHP database access, and includes an extended date/time library, database managed session control, XML database management, and an active record library)}}
 +{{htmlmetatags>metatag-robots=(INDEX,FOLLOW)}}
  
 ==== Thanks ==== ==== Thanks ====
Line 126: Line 201:
 </WRAP> </WRAP>
 <WRAP> <WRAP>
-The ADOdb team would like to thank [[https://www.jetbrains.com/|JetBrains]] for their valued support to the project, in the form of free [[https://www.jetbrains.com/buy/opensource/?product=phpstorm|PHPStorm IDE]] licences.+The ADOdb team would like to thank [[https://www.jetbrains.com/|JetBrains]] for their valued support to the project, in the form of free [[https://jb.gg/OpenSourceSupport|PHPStorm IDE]] licences.
 </WRAP> </WRAP>
 </WRAP> </WRAP>
  
-==== Copyright ==== 
- 
-2000-2013 (c) John Lim\\ 
-2014- (c) Damien Regad, Mark Newnham & The ADOdb Community 
- 
-ADODb is dual-licensed under the BSD and Lesser GPL license, with the BSD License having priority. 
- 
-{{htmlmetatags>metatag-keywords=(php, programming, database, abstraction, layer, mysql, microsoft,sql,server, oracle, ibm, db2, firebird, interbase, postgres, postgresql, linux, ibase, code, simplicity, portable, sap, maxdb, adaptive, informix, odbc, XML, active, record, session, management, date, time, library, active, record)}} 
-{{htmlmetatags>metatag-description=(ADOdb is a database abstraction layer for PHP. Compatible with most supported databases, it provides an easy way to use the same code against all databases, Portable code can be written that runs unchanged. It also simplifies PHP database access, and includes an extended date/time library, database managed session control, XML database management, and an active record library)}} 
-{{htmlmetatags>metatag-robots=(INDEX,FOLLOW)}} 
index.1578997301.txt.gz · Last modified: 2020/01/14 11:21 by dregad