ADOdb Database Library for PHP 5.11

ADOdb Database Library for PHP

ADOdb Database Library for PHP is a PHP4 and PHP5 database abstraction library. Supports MySQL, PostgreSQL, Interbase/Firebird, Oracle (Oci8), MS SQL 7, ADO, Foxpro, Access, Sybase, Sybase SQL Anywhere, DB2, Informix, Frontbase, SQLite, LDAP, Netezza, SAPDB, generic ODBC/ODBTP, PDO etc. It is an OpenSouce PHP database project. ADOdb provides code to handle inserts and updates that can be adapted to multiple databases quickly.

A basic paginated grid is also provided, and support for database-backed session variables. Support for PHP5 iterators and exceptions included. Methods are provided for date handling, string concatenation and string quoting characters for differing databases. A metatype system is built in so that you can figure out that types such as CHAR, TEXT and STRING are equivalent in different databases. Able to create databases, tables, indexes portably using an xml schema or programatically. Also has sql performance monitoring and schema creation using XML.

Features of ADOdb Database Library for PHP:
- Designed for speed. It is probably the fastest open source database abstraction library available for PHP. See benchmarks.
- Provides extensive portability support such as date and type-handling and portable schema creation. See portable sql tips
- Support many enterprise features such as database backed sessions (with session expiry notification), SQL code generation, pivot tables, SELECT LIMIT emulation for all databases, performance monitoring.
- Easy to learn, especially if you have Window's programming experience, as it uses many ADO conventions.
- Extensive QA, every release is unit-tested on Access, MySQL, PostgreSQL, MS SQL, Oracle 11g.
- Mature, continiously developed since August 2000. Has a large community of users.
- Powerful Active Record support. See docs.
- Very reasonable licensing terms (BSD). This means that you can incorporate (and even compile) it into your software applications royalty-free without asking the author's permission, provided you include license.txt in your release.

Requirements:
PHP 5.0 or later

Installation:
- Unpack files into a directory.
- Try the above sample code, adjusting the connection parameters to suit your database server, and modify the sql to match your tables.

License type: BSD,LGPL
Date added: 3 years, 5 months 21 days ago | Last updated: 3 years, 4 months 3 days ago

More popular Database Management

Listing Files

xsl
  • remove-0.3.xsl
  • 1.4 KB
  • 06/25/2009 16:26:08
  • remove-0.2.xsl
  • 1.4 KB
  • 06/25/2009 16:26:08
  • convert-0.2-0.3.xsl
  • 7.5 KB
  • 06/25/2009 16:26:08
  • convert-0.1-0.2.xsl
  • 5.5 KB
  • 06/25/2009 16:26:08
  • convert-0.1-0.3.xsl
  • 6.0 KB
  • 06/25/2009 16:26:08
  • convert-0.2-0.1.xsl
  • 5.5 KB
  • 06/25/2009 16:26:08
datadict
List All Files