Browse Edit

This class displays results of sql statements in a browseable and editable format akin to a excel or Access. Easy, editable displays of columnar data.

Version 4.1 adds database abstraction via the PEAR DB class and in-class filtering methods. Please review the README. Including Multiple table SQL statements and identical field names has required some important modifications. The following features are included:

Columns have headers that allow sort order to be changed by clicking on them
Display may be editable or read only
SelectBox (drop down list)
CheckBox
Hideable columns
Editable title bar and footer allowing any html
Line numbers (optional)
Column title aliases
Validate entries withjavascript
Paging (optional)
Alternating row colors (optional)
Table formatting
Action columns for buttons, links and javascript
Javacript action on select radiobutton or checkbox
Sort order will reverse if column header is clicked again
TextArea
Date or DateTime column format with drop down lists for Year, Month, Day, and Hour, Minute with complete integration to MySQL
Radio button or Checkbox select column
(NEW V3) script defined function columns
(NEW V3) dynamic selectBox values (this a read-only column)
(NEW V3) script defined column sequence
(NEW V3) row pre-selection
(NEW V3) sorting arrow path customization
(NEW V3) set character code
(NEW V3) adustable column and text input window size
(NEW V4) MULTIPLE TABLE SELECT,UPDATE,DELETE
(NEW V4) checkboxi, stores data as 1 and 0
(NEW V4) Alternate text on mouse hover on column headers
(NEW V4) Customizable background color for disabled fields
(NEW V4) In Class filtering function with <CTRL> click on column headers