MySQL Table Editor 1.0.6

MySQL Table Editor is a PHP 4 and 5 library to allow easy and user-friendly editing of MySQL tables. This is a library and not an application. It will be of no use unless you do some coding .

This is not meant to be an alternative or replacement to phpMyAdmin. This is something you can provide to users to manage tables without them happily destroying your database.

Features:- Easy setup. Give it a connection resource and a table name and it will work most things out by itself.
- Search functionality (albeit basic MySQL LIKE). Can be disabled (default), and limited to certain fields only. Advanced Search can be used to search specific fields only, or with various operators (LIKE, =, >, >=, <, <=).
- View/Add/Copy/Edit/Delete functionality, any or all of which can be disabled.
- CSV download for selected rows, current page or entire table. Can be disabled.
- Cusomisable header/footers.
- Common functionality such as date/time/timestamp catered for in dropdowns (see add/edit pages in demo). Also supports adding new such functionality.
- Fields can be hidden from display, editing or both.
- Ordering by any column supported.
- Default values for fields can be set for when adding rows.
- Callbacks can be assigned to fields for pre-display manipulation (Eg. cutting long strings down).
- Callbacks can be assigned to any/all of add/edit/delete actions (Eg. for logging user actions).
- Can assign predetermined values to fields (Eg. showing "nicer" values for foreign keys). These values can be supplied as an array, or from the results of an SQL query.
- Multiple deletes at once support.
- Paging support. Number of rows per page is configurable.
- Data filter support, to allow only showing of certain rows.
- Data validation callback to allow custom checking and/or manipulation of data before being added/updated.
- Custom field types: password - provides a familiar two input process for setting passwords (ie. password and password confirmation input boxes), email - automatically checks the data matches an email address format, date, time and datetime - automatically sets the default value to the appropriate current value, and adds a "now" link next to the input for setting the current value during add/copy/edit.
- Required field support, to ensure certain fields are filled in during add/edit actions.
- Caching of table data structure (so it not worked out on every page refresh).