Auto form is a PHP class that can be used to generate HTML forms to manipulate MySQL table records. It can take a list of MySQL table fields and generate HTML for forms to select, insert, update, and delete table records. The class can also perform given validations of specified fields and invoke given callback functions on certain form processing events.
Loomes' Nested Set is a class that can be used to manage a tree of information stored in a database. It can perform several types of operations to manipulate a hierarchy of nodes that are stored in a database as table records. Currently, it can insert a root node, insert a node that is child of a given parent, delete a branch of nodes under a given node, delete a single node, rename a node, move nodes, check whether the root node exists, and retrieve the whole tree of nodes.
TbsSQL is a small wrapper class for working with SQL databases within PHP scripts. It has few methods and two properties and it’s only one file per database for installation. Its most interesting feature is that it can protect and format values before merging them into the SQL statement. It has a cache feature, a trace mode, a debug console, and it can return data as arrays, standard objects, specific class objects, or clone objects. It can also delete PHP connection variables after making the connection.
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.
Xyndravandria Dyverath composes and executes MySQL database queries programmatically. It represents a database system with PHP classes. Other classes are available to compose other parts of the queries like conditions, fields, values, limit clauses, etc. A separate class can also query database table metadata like table fields and primary keys.