phpMyEdit-report extension is provided for easy table report creation. There is often a need for selecting particular fields from table with applying specific filter options and finally write out chosen subset of data (report) to HTML page.
Navigation is easy to use. Field selection menu would be displayed if
fields_select parameter is passed by GET or POST HTTP method
to PHP script and it has non-empty value. This field selection menu contains
list of checkboxes connected with columns, list of filtering input fields and
also button for report creation. Every report page has ability to return back
into field selection. It is possible to specify amount of records on report
page, what is by default set to unlimited.
Extension can completelly work without cookies. However it uses cookies to have a memory, where last selected report is stored. When user leaves report PHP script and comes back after some time, a last selected report should be predefined in checkboxes and input fields on fields selection screen. Detection for cookie usage is done automatically. If HTTP headers was already sent, cookies are not used, because they will cause an ugly warning. Otherwise cookies are used for described kind of memory.
To use this extension simply include
extensions/phpMyEdit-report.class.php file and call
new phpMyEdit_report($opts) instead of common phpMyEdit class
file. Extension specific configuration parameters currently do not exist, thus
all table columns are allowed to be selected in final report. This will surely
change in future, because table could have columns that need to be
unselectable for final report (such as password column or similar).