db_view is a MySQL compatibility DB class for views and triggers in PHP. It provides an abstraction class and helpers for multi-tabled MySQL data (init, select, select_row, count, insert, update, and delete), atomic multi-table updates, inserts, and deletes (e.g., update items, month set items.price=month.price where items.id=month.id), primitive non-atomic (=insecure) rollbacks, Functions, Triggers, and Defaults per action (select, update, insert, delete; before or after), and rich logging and debugging facilities.
Meunity is a Web-based community system that uses PHP. It is object oriented, so it is easily extendible. Its database abstraction layer allows it to be compatible with multiple databases. It is easily configurable, and includes content management systems and advanced administration.
phpSQLGen provides functions for generating SQL queries, HTML tables, and XML documents. It consists of two classes and a set of utility functions. SQLGen provides PHP functions for generating SQL query strings from arrays, and TableMaker generates an HTML table or XML document from an ADOdb result set or an array. Since the output of each SQLGen method is a SQL query string, the library is compatible with ADOdb, PEAR DB, PHPLib, and any other database abstraction layer that can execute SQL query strings. This is useful for constructing complicated SQL queries that vary according to the situation. Different if-then clauses can push items onto from the argument array - SQLGen will take care of inserting commas and "ands" into the query string as necessary. This can be used together with the ability to populate an array directly from a form for the automatic generation of SQL queries from form variables.
Error Handler provides a custom interface to error handling in PHP. Several report formats can be used to reveal what circumstances led to a certain error. One for logging, one for display, and one for redirection. It captures the errors and captures (to a customized level) the context and variables surrounding the source of the error and neatly organizes them as a series of reports.
DBX works using XML files as its native format. The database can be queried using standard SQL queries. DBX is the smallest, platform independent DBMS, and is extremely easy to migrate to. For small databases, it is a good substitute for MySQL, Oracle, etc. The added advantage is that it saves the data as neat, readable, XML files, allowing easy compatibility.
PHP Comment Class is a simple, reusable comments engine which utilizes the PHP Table and Form classes. Backing into a MySQL database (or any other persistent store provided by Table or Form), it provides a set of Form and Table children which, when called, generate a comments engine with input validation and stylesheet support.
PHP Table class is a simple but powerful table renderer that consists of data aquisition and rendering components. It allows you to easily display the results of an SQL query or a PHP array as a formatted HTML table with stylesheet support, ordered columns, and numeric totals. A powerful class inheritance method provides a great deal of flexibility. It is also possible to output tab-separated records.