kDataGrid 1.2

kDataGrid project is a PHP component that is ideal for generating data-bound HTML grids.
kDataGrid showcases a comprehensive set of features, including automatic table mapping and pagination, AJAX edit-in-place, theming support, built-in quick-search, custom formatting rules, and data manipulation pages.
kDataGrid can be easily implemented into any Web site, Web application, or framework.
Main features:
Data mapping
- Map database tables or custom queries. Just point kDataGrid to a table in your database and youll have a complete paginated, editable and AJAXified grid.
Columns
- Custom formatting. Provide custom formatting rules for any column in a resultset; especially useful for formatting currency or e-mail fields.
- Custom lengths. Limit the maximum number of characters displayed for any field; useful for truncating links, street addresses or lengthy text descriptions.
- Sorting. Sort by any column in a result-set; no configuration necessary.
- Editable headers. Provide your own column headers; especially useful for tables with criptic column names.
- Column hiding. Hide specific fields from public display; such fields may include passwords or e-mail addresses.
Rows
- Automatic pagination. Paginate a table or query result without writing a single line of code; customize the number of rows per page.
- Alternate odd/even. Fully customizable odd/even coloring for improved readability.
- Highlight on click and hover. Fully customizable row highlighting for improved readability.
Edit-in-place
- Edit-in-place is a system for quickly editing text without requiring any page reloads. A simple double-click turns any cell intro an editable field. Upon completition, the new data is saved back in the database.
- Enabled by default.
- Automatically detects primary key columns and sets them to read-only.
- Can be disabled for any column in the result set.
- Preserves custom cell formatting.
Live search
- Typing in the quick-search text-box automatically triggers the live-search function.
- Provides visual feedback using an animated "Loading..." image.
- Checks all cells for the provided keywords.
- Does not required clicking, page reloads, or trips to the database.
Data Editing
- kDataGrid automatically generates the necessary pages to manipulate data in your database tables.
- Automatically generates pages to view, add, edit and delete records.
- Actions column. A data manipulating column called Actions is automatically added as the last column in the grid and can show links to view, edit and delete a record.
- Add record link added on the top strip.
- Available actions can be set using the show_actions() function.
- The look-and-feel of all data manipulation pages can be changed by editing a simple template file.
Enhancements:
- This release adds support for Oracle, SQL Server, and PostgreSQL.
- It is now possible to explicitly set column widths, change the CSS Id and Class attributes of the grid, and block specific actions (data-editing pages) from being displayed.
- A bug has been fixed with set_columns_maxlength() where lengths were not correctly parsed under some conditions.