The Final Countdown - PHP

In this concluding article, find out about ADODB's advancedfunctions, with examples that demonstrate how ADODB can be used tooptimize multiple-run queries, commit and roll back transactions,improve performance by caching query results, and automatically writeHTML (ortext) files.

TABLE OF CONTENTS:

By: icarus, (c) Melonfire

Poor Best

Rating:

/ 8

July 31, 2002

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

And that's about it for the moment. Over the course of this two-part article, I introduced you to the ADODB database abstraction class and demonstrated how it could be used in your Web development efforts. I showed you the fundamentals - executing queries, iterating over resultsets, obtaining table and row information - and then moved on to more advanced material, illustrating how ADODB could be used to optimize multiple-run queries, commit and roll back transactions, improve performance by caching query results, and automatically write HTML (or text) files.

That isn't all, though - ADODB comes with a wealth of features, and is constantly being improved by its author, and the PHP community at large. For more information on what it can do, and how you can use it in your own PHP projects, take a look at the following links:

The ADODB home page, at http://php.weblogs.com/ADODB

The ADODB manual, at http://php.weblogs.com/ADOdb_manual

MySQL and ADODB, at http://php.weblogs.com/adodb_tutorial

Tips on writing portable SQL, at http://php.weblogs.com/portable_sql

Web services with ADODB, at http://php.weblogs.com/adodb_csv

As for me, I'm outta here. See you soon!

Note: All examples in this article have been tested on Linux/i586 with PHP 4.2.0, Apache 1.3.12 and ADODB 2.2.0. Examples are illustrative only, and are not meant for a production environment. Melonfire provides no warranties or support for the source code described in this article. YMMV!