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.
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.
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.
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.
neo-Portal is a data presentation and delivery system. When data is output in DHTML, it behaves like a portal. It features full i18n localization support, OS, Web server, and database independence, support for WSDL Web services, and output in XHTML, PDF, RSS, TXT, RTF, WML, and more.
TinyButStrong is a template class for PHP that allows you to generate XML/HTML pages and any other files based on text source. The engine gives facilities to work with any databases, including in native PDO, MySQL, PostgreSQL, SQLite, PHP arrays, and more. It is possible to design templates using any visual editor (like Dreamweaver or FrontPage), and thus to make templates that are compatible with W3C standards for example. It features simple block management, useful display formats, conditional displaying for blocks and locators, remote XML/HTML attribute modification, a cache system, and the ability to include sub-templates and execute associated scripts. Plug-ins are supported since version 3.0.
LAN Management System (LMS) is a set of database-driven applications capable of managing multiple networks of computers and customers. It uses a Web UI and either a multipurpose daemon written in C or a set of Perl scripts that perform scheduled tasks and configure your system services. It was designed to organize small self-financed networks, but is mature enough to suit the needs of medium sized ISPs. Support for multiple databases and languages are included, and a template system allows it to blend in with your existing infrastructure.
The PHP SQL Toolkit is a PHP class system for abstracting database calls. Using classes or functions, it abstracts the underlying database structure into data sources in a manner similar to ODBC. Data sources are defined in one file and a standardized syntax is used for connecting to all databases. This is useful for portable code or for referencing multiple databases on multiple platforms all at the same time.
CodeKit is an interface to a universal database code table. It takes all of the programming work out of maintaining multiple database code definition sets. A single code administration page lets you define new virtual code tables and enter all codes and their descriptions. Perl and PHP classes retrieve the code descriptions and automatically generate HTML code selection elements.