Many cool people are using this database wrapper library for PHP to ensure that their programs are database independent. Here is a list of software applications using ADODB. If you have any application using ADOdb, email me (heyjohnlim#yahoo.com) to be added to this list. Also see the testimonials.
phpLens is a commercial data grid component that allows both cool Web designers and serious unshaved programmers to develop and maintain databases on the Web easily. Developed by the author of ADOdb.
The Artekopia Netjuke is web based Audio Streaming Jukebox designed to provide a centralized and searchable repository of music to individuals, and/or small communities (family, company, school, hotel, etc.).
BlackNova Traders is a web-based, massively multi-player space exploration/trading, turn based game inspired by the popular BBS game of TradeWars.
Gallery is a slick web based photo album written using PHP. Easy to install (it includes a config wizard), it provides users with the ability to create and maintain their own albums in the album collection via an intuitive web interface. Photo management includes automatic thumbnail creation, image resizing, rotation, ordering, captioning, searching and more. Albums can have read, write and caption permissions per individual authenticated user for an additional level of privacy.
Quantum Star SE is a browser based space strategy game with Mining, Trading, Clans, and Space Warfare played in real time. Developed as an easy-to-install web based game, and requiring no user downloads, Q-S is developed to run on most PHP enabled servers.
Kabal Invasion is an epic open source, space themed, web based, turn driven, massively multiplayer game inspired by the BBS door game "Ultimate Universe".
Analysis Console for Intrusion Databases (ACID): PHP-based analysis engine to search and process a database of security incidents generated by security-related software such as IDSes and firewalls (e.g. Snort, ipchains). By Roman Danyliw.
PHP Lib Login passable php security... for the lazy. Php_lib_login is a library for php written in php designed to allow web site developers to add login and password protection functionality quickly and easily. basic login functionality including email-based, question-protected password reminding, user-creation of accounts, password changing and selected page protection can be implemented with about 15 lines of code. if you hate futzing about with sessions and databases calls and all that to "roll your own" password protection, php_lib_login will provide decent functionality for near-zero effort.
phpGACL PHP Generic Access Control List is an integrated set of PHP functions giving web developers a simple, yet immensely powerful "drop in" permission system to their current PHP based applications.
Enterprise Network Monitoring They are using ADODB in the browser interface for the Enterprise Network Monitoring System which checks the health of any Internet ready device in the areas of content, database applications, performance, and more. Current customers include Verio Corporation's enterprise division where they are monitoring 110 of the enterprise level devices (routers, fire walls, switches, load balancing hardware, database servers, email servers, and web servers), Johns Hopkins University, and What Helps.
SLOP (Server Logging Operations Platform) is an engine for the collection of and reporting on logs from various network based devices such as firewalls, switches, and Web servers. It includes support for Checkpoint Firewall-1 firewalls and Cisco 2900 and 3500 series switches. It features storage of logs in an SQL database, dynamically generated Web-based graphic reports of statistics from devices, Web-based viewing of raw logs, with sorting and color highlighting, and an object-oriented framework for adding "modules" to support other devices.
Portals and Frameworks
PostNuke is a Weblog / Content Management System (CMS). It offers full CSS support, HTML 4.01 transitional compliance throughout, an advanced blocks system, and is fully multi-lingual enabled. PostNuke is a fork of Francisco Burzi's PHP-Nuke. Read more to find more about PostNuke and what a CMS is. Very popular!
DBForm If you have been a Web Database Developer for even a short time you will realise that most of your work is creating web forms and most of those forms do basically one action: updating records in a single database table. Well after several years as a Web Database Developer I knew what the answer was, create a class to build the form based on a database table.
Portunity provides a complete commercial Portal solution: The Portalsuite 2002 is the product line of the Portunity GmbH for creating and operating interactive internet presentations, portals and e-business solutions.
Dark Portal DarkPortal is a project founded to create a web portal system similar in scope to projects similar to PHPNuke and PHPJ00K. DarkPortal is based on the user interface style of PHPNuke, using a new modular core as a base for adding pluggable modules to facilitate content creation and management.
Wild Web is a open source web framework. It provides a complete set of core services to web aplications such as HTML/code separation through an advanced Template system, database abstraction, rich set of functions to automatically construct browsers, filters and (include|delete|update) forms to any table, a powerfull API to build custom forms with validation, etcetera.
EasyPublish CMS EasyPublish CMS is a commercial content management system for managing information and integrated modules on your internet, intranet- and extranet-sites. From Norway.
INDEXU Portal Creation System. INDEXU will help you maintain your portal and handle almost all of the back end tasks, such as creating categories, validating new link submissions, as well as front end user interaction such as the web interface, search facility, and new links.
Core is a web application platform by the developers of phpshop. Core simplifies the task of creating web applications, by providing the most common aspects of the application.
Publish Button is an innovative Web Content Management System designed for print and web publishers. Its focus is the separation of content from graphic design and web page logic. Publish Button, in addition to providing visual management of content, allows web applications using your content to be created through its sophisticated, web-based layout and logic editor.
MyPHPblog is a weblog application using MySQL and PHP4 for those wanting a free and easy way to create their own 'blogs'. MyPHPblog allows for the collaboration of many users into a single blog and creation of multiple blogs.
openPHPNuke is a CMS based on myPHPNuke.
Moodle is a course management system for producing Internet-based courses for distance education, offering a Free alternative to commercial software such as WebCT and Blackboard. Moodle has been designed to support modern pedagogies based on social constructionist theory, and is easy to install and use.
Moregroupware is a web-based groupware app that features contact management, web-mail, calendaring, todo management, news, project management, skins.
PHlexDB is not a traditional PHP CMS -- in that we are not providing a portal creation tool or an out-of-the-box template-driven website of any kind. What PHlexDB does provide is a comprehensive toolkit for administering your site's content and for getting that content onto your site, this includes: completely customizable form generation & commit classes, authentication classes, metadata classes, content search & retrieval classes, a web-based site configuration tool, and a web-based content administration tool.
Interact is an Online Learning and Collaboration platform developed by the Christchurch College of Education. It is an open source alternative to commercial systems like WebCT and Blackboard. It is designed with the intention of making it easy for students and lecturers to interact online, based around constructivist and vygotskian views of teaching and learning.
Vortex Portal is a content management solution for gaming websites.
cattaDoc. Hi John, I have been using ADOdb since before version 1.0 and I am happy to be able to inform you that I now also use ADOdb in [this] open source document management solution -- Erik_Maaløe
TurboPHP is a Windows application that provides an extendable, Borland Delphi-style component system for rapid development of PHP and MySQL based web programs.
PHAkt: PHP Extension for DreamWeaver Ultradev allows you to script PHP in the popular Web page editor. Database handling provided by ADODB. There is also a commercial version with more features. Also see this configuration tutorial.
Also from the developers of PHAkt is Krysalis which is an open-source PHP development platform, based on the XML/XSLT core. It is inspired from Cocoon, which proved to be smart enough to inspire Krysalis but is technologically different.
QuB (Query Builder) from InterAkt manages your SQL queries for MySQL, PostgreSQL and Access databases. Visual query editing is finally available to Ultradev users (PHP only version). QuB centralizes the SQL queries in a single repository, provides a graphical interface for editing them and has tight integration with Ultradev 4 (PHAkt and ImpAKT).
LiquidClassifieds is a commercial classified ads program. phpSQLGen is an open-source code library for generating SQL statements and creating HTML tables from ADOdb result sets. LiquidMarkets, a provider of financial data, uses ADOdb extensively.
ADODB_SQL Permits migrating your code using DB_Sql format (PHPLIB) to another DB engine, ADODB.
phpHtmlLib is a set of PHP classes and library functions to help facilitate building, debugging, and rendering of XML, HTML, XHTML, WAP/WML Documents, and SVG (Scalable Vector Graphics) images as well as complex html 'widgets' . It includes a very nice recordset pager class that supports ADOdb. An example, and the source code. Works with PEAR DB too!
Administration and Management
Webodex is a web-based mailing list management application allowing users to add, delete, edit and search listings, store them in user-defined groupings, send group email and generate printable envelope and mailing label documents in Rich Text Format. webodex is a "skinnable" application, meaning it's appearance can be changed to suit end users' needs easily.
RSA Software provides a web-based accounting system using ADOdb for database operations. Built on a core of "open-source" technology, RSA Business Solutions combines the speed, functionality, accuracy and stability of traditional LAN based accounting/business software with the usability, accessibility, cost-of-ownership savings and "hard ROI dollars" of a true ASP.
NOLA is a full featured accounting, inventory, and job tracking application. It is licensed under the GPL, and developed by Noguska.
BugIn BugIn' is a PHP/MySQL powered bug/issue tracking system. It is intended to be powerful, but lightweight enough that it doesn't need constant modification, or a full-time DB administrator.
BugPort is an open-source, freely available, web-based system to manage tasks and defects throughout the software development process.
IPplan is a web based, multilingual, IP address management and tracking tool based on php 4, simplifying the administration of your IP address space. IPplan can handle a single network or cater for multiple networks with overlapping address space. Supports MySQL, PostgreSQL, Oracle and other databases.
OpenRealty OpenRealty is a free, open source real estate listing manager. Intended to be both easy to install and easy to administer, OpenRealty uses PHP to drive a database backend, thus creating a tool which is fast and flexible.
IBES provides a easy end-to-end solution to customer account management. From a customer setup/registration disk down to the e-commerce gateway, IBES is a complete billing solution for ISPs which is virtually maintenance free, cuts hardware costs and most importantly greatly increases your efficiency at doing business.
Weather Plotter Polls the US Nation Weather Service HTML page for weather data for the city you are interested and plots the data.
GiftWeb is an application for entering wish lists and allowing other users to select which items they have purchased. The recipient can't see what has been purchased for them, and you can even add an item to another user's list that will also be hidden from them.
http://www.designcurve.net is a site powered by ADOdb.
Tom Salter - webmaster#20twentyfans.com
Many thanks for ADOdb which I am now using in place of a rather old version of PHPLIB. Whilst 95% of my work uses MySQL, I first saw an application for ADOdb in a situation where I was using both MySQL and Access 200 dbs. With minor tweaks, the same code works for both - the differences are in the db internals rather than in the higher level access methods.
Wesley Jordan, DesignWrite Software
Every time that I think that it can't get any better, you prove me wrong. Thanks for making the ADOdb such an amazing product. I also want to thank you for you responsiveness. I was hired as a consultant not too long ago by a company here in Salt Lake to build a shopping cart for their website. They were using a mssql backend and I built all of the connectivity using the ADOdb library. The problems started after the code was built and the dev lead started benchmarking it. The ADOdb library turned out to be horrible on the bench. Well you may or may not remember this, but the dev lead sent you an email detailing the problems and in the very next release you wrote about the problem with the code optimization and you had even gone back and optimized all of the ADODB code dealing with mssql connectivity. How cool is that! In my book, youâ€™re the man. That is top rate customer service for a product whose only revenue is pride.. And you should be d@mn proud. Keep up the Good Work.
I'm using the ADODB library in my package for OpenRealty. I love it!!! Thanks a lot for creating such a cool thing
UberGoober in comp.lang.php:
I've been making some apps for our company, and I've been really up in the air over which database connector to standardize on. Pear's DB, and ADODB are really different in terms of functionality, and even documentation. I started with Pear's DB, found there were several things I was kinda unhappy with, then tried ADODB, and loved it.
in the comp.lang.php newsgroup.
David wrote this article on PHP and PostgreSQL Open Sesame. In the article, Tom Clarke talks about using ADOdb to build web-sites, specificly Sesame Street's "Sesame Workshop" web-site.
Hans Lellelid (PHlexDB developer) hans#clicknet.cc
I've been really impressed with the ADOdb project. What I love about ADO is the drive to make truly portable code SQL. I take advantage of the SelectLimit and date/time functions in ADOdb to minimize the extent to which I will need to build RDBMS-specific SQL libraries
Tom Wilcoxen tomwilcoxen#yahoo.com
Just a quick note of thanks for adoDB. I tried using Pear DB for a day and finally got it working. But I'm not very confident in it being portable to other systems, and it seems a little fragile. I downloaded adoDB and had it working in about ten minutes. I appreciate the great debugging messages produced by adoDB, and the clear, easy to follow docs.
Valter Mazzola. valter#sitidinamici.com
Hello i'm the developer of zBlogger.com an online open source based blogging tool, i've used ADOdb everywhere.
Patrick Brady patrick.brady#kpmg.ie
I am a developer of Quantum Star SE, a game project which has only recently began making open source releases after almost a year in development.
Just to let you know that after a lot of consideration, my project has been altered to use ADOdb. In the past the game has relied entirely upon the PHP MySQL function set, and had no built in support for other database solutions. Dreading hours of work to make the switch, I was pleasantly surprised to find that the change to ADOdb was actually quite simple, given that QS uses some simple functions which encapsulate the MySQL PHP functions in the code.