Framework providing several types of functionality
This package is a framework of classes that provides several type functionality.
It provides classes for:
- Composing and sending e-mail messages
- Perform user authentication
- Manage files, directories and logs
- Generate and validate forms
- Manipulate images
- MySQL database access wrapper
- Paginate database query results
- Sort data in arrays
This class can be used to Edit MySQL data in a table using AJAX for updates.
It can connect to a MySQL database directly or using ADODB and executes a query to retrieve data from a given table.
The MySQL table fields to display in the data grid table columns are configurable. The data from certain columns be displayed as images, totals or values calculated according to a given formula.
The data may also be displayed as bar charts.
The listing may have links to sort, add, edit, delete, search and view individual table records. The listing colors may be alternated and the rows may be highlighted when the user drags the mouse pointer over them. The links may be displayed with given icon images. The presentation of several aspects may be defined using CSS styles.
The record rows may be selected using respective form checkbox inputs.
A form may be presented to search for records with user defined values in given columns.
The records being listed or edited in place may be updated using AJAX request to avoid page reloading in any type of browser.
It may also show links or a form select input to go to the other pages when the listing split into multiple pages.
The text messages shown with the listing can be displayed in multiple languages. Currently English, Dutch, German, Spanish, French, Italian, Czech and Portuguese are built-in supported idioms.
This package can be used to browse and edit data stored in a MySQL database.
It generates an AJAX Web based interface to edit, insert, search rows of MySQL database tables.
It can be used to update and delete multiple records at once. It may also prevent editing or deleting records by simultaneous users.
The class can handle submission of data in the form of files. Uploaded files are copied to specific folders, if the uploaded files not exist already.
The class and also list and search for records to be edited or deleted. Search fields support AJAX based auto-complete suggestions. Search results can be saved to CSV files or XML files for Excel/OpenOffice.
Search results are displayed with pagination links in tables with different colors or CSS styles for different rows. Search result columns can be linked to other pages.