ADOdb Database Library for PHP

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.

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.

Rated 4.78 out of 5 (983 rating(s))

Visit Publisher Site Download Read/Write Reviews

Version

4.60

Filed in

Scripts/PHP/Scripts & Programs/Database Tools

Submitted on

7th September 2000

Last Updated

11th February 2009

Publisher

John Lim Other listings by this publisher

LICENSE #1

License Type

BSD

Price

0.00

Additional Info

LGPL also

LICENSE #2

License Type

BSD

Price

0.00

Additional Info

LGPL also

Price Free
Views 58,895
Reviews 2 Member Review(s)
Posted On 7th September 2000
Last Updated On11th February 2009

Add to Favorites Report this Listing

User Reviews
Submit Your Review

Average Member Rating: 4.78/5

Excellent Database Abstraction Library

Reviewed by Anonymous on Tue, 10th September 2002

Rating: 5 - Excellent

This abstraction library goes well beyond the call of duty, it includes database abstraction for most database servers but it also includes database result set caching and more. I've found it very powerful and now use it even in some applications that don't require database abstraction because it provides a common interface to the server.

Save your precious time!

Reviewed by Anonymous on Thu, 19th June 2003

Rating: 5 - Excellent

Sure, you're using MySQL and PHP has built-in functions for MySQL... But a year from now you decide you want transactions and stored functions and you decide to go with PostgreSQL. Then you gotta take the time to re-write all you code for the new db. Save the grief and go with ADOdb! As a pleasant side effect you'll get a wonderful caching recordset object with all the methods you'll (likely) ever want and auto-generated SQL. The only bad thing about ADOdb is keeping up with all the frequent and useful updates (just package installs, not API changes)!

View All Reviews

Displaying 1-2 out of 2 reviews

By using this website, by posting any content, by posting any advertisement, and/or by browsing the contents of the site, you are agreeing to the terms and conditions of the website. Please Click Here to view the terms and conditions of the website.