No Images Added Yet

ADOdb Database Library for PHP

Rated4.8/5 (983 ratings)
Add to Favorites
Publisher
Database library for MySQL, PostgreSQL, MSSQL, Oracle, Interbase, Informix, ODBC, Access, VFP.
Product Details

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.

Report this Listing
Price
Free
Licence Type
Free
Views
59,406
Submitted on
7th September 2000
Last Updated
11th February 2009
Licence Type
BSD
License Price
0
Additional Info
LGPL also
Licence Type
BSD
License Price
0
Additional Info
LGPL also

You May Also Like

User Reviews

Please rate the listing and tell the world know what do you think about the listing.
(983 ratings)
Average User Rating: 4.8/5
Excellent Database Abstraction Library
Reviewed byAnonymousonTue, 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 byAnonymousonThu, 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)!
Displaying 1-2 out of 2 reviews
View All Reviews