Metabase is a DBMS-independent PHP API to access SQL databases. It supports MySQL, PostgreSQL, Oracle, Microsoft SQL server, Microsoft Access, ODBC, Interbase, Informix, MiniSQL, and SQLite. It supports nested transactions, blobs, and prepared queries. It can install database schemas defined in a DBMS independent XML format that describe tables, indexes, primary keys, and auto-increment sequences. It is also able to upgrade a database to a new schema without affecting the data that was stored since it was installed or upgraded for the last time. There is also schema reverse engineering support.
Phormation is a set of PHP functions which provide a framework for developing any HTML form connected to a database backend (currently PostgreSQL, MySQL, and ODBC are supported). It allows you to write and make use of reusable widgets so you can develop Web sites more quickly. Phormation has more than 10 widgets including text field, date, file upload, and foreign key select, and is easily extensible. It has good documentation.
PostgreSQL Session Handler for PHP is a custom session save handler for PHP4 that uses PostgreSQL as the session cache. This allows multiple Web servers to share a common session storage container, and is useful for allowing Web users to move between machines while maintaining their session state.
The Query result table display class outputs a table with the data from the result rows of a database query. It features database independence, splitting the display of the result rows into multiple pages, arbitrary column display, automatic alignmnent of columns according to their data types, configurable colors for the table headers, and data alternating between even and odd rows.
Database access class is a PHP class for interchanging data between databases and forms. Features include inserting a new row into a database table with data from forms, loading form fields from database table row, updating database table rows from form fields., deleting database table rows with criteria defined by values from form field, building list in an array suitable for defining "select" type form fields from specified database table values. and database independent support for the data types of fields: TEXT, INTEGER, BOOLEAN, FLOAT, DATE, TIME, and TIMESTAMP.
PHP/Toolbox is designed to make the process of creating database-powered Websites easier. It utilizes the iterative, or step-by-step development paradigm. It therefore enables you to create fully-functional Web interfaces for an arbitrary set of DB tables within minutes. Any changes you make in these tables after the test driving will be handled automatically. You can then adjust this automatic interface in an iterative manner to suit your specific needs.
Dataxi is a database access system that uses a single form to query, view, and modify data spread to one or more tables in a true relational manner. In addition, Dataxi provides a platform to build database-oriented applications of any size that can be accessed through a Web interface.
WebAbility is an advanced Web development platform that contains WebFlow, a content management system (CMS), a security advanced system (SAS), a powerful workflow engine, and Web site wrappers. It supports multiple database connections, multiple languages, multiple presentation templates, page, script, and library versioning, XML and Web Services integration, and advanced security management. It uses plugins to extend the software for tasks such as e-commerce, portals, intranets, and editorial systems.
phpMysqlConnection is an interface class to be used with the PHP programming language to help projects connect to a MySQL database server and perform queries. The methods of this class prevent the programmer from having to memorize all the different steps needed to connect to the database, perform a query, and retrieve results.
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.