AJAX data listings engine for Scripts Publisher's description
from ionix Limited
AJAX data listings engine can be used to list data in any mySQL table.
The system is written in PHP and can be used to list data in any mySQL table, all you do is specify the mySQL database details and the engine will automatically generate a data listings table as per the configuration.
The ten input flags can be used:
Specify the mySQL database table name.
Separated by pipe delimeters, enter the field names in the order they should be shown. e.g. FIELD_NAME_1|FIELD_NAME_2|FIELD_NAME_3
Default 1 - true. 0 - false. When true the column headers will be shown and column sorting features will be available.
Default blank - display all results on one page. Two values are required seperated by pipe delimeter, number of records to display and whether or not to display pagination options to view next pages. e.g. 20|1 will display 20 records per page and will allow you to navigate through pages. 10|0 will display 10 records but will not enable you to view other pages.
Default blank - sort as returned from database. Two values are required seperated by pipe delimeter, field name to sort by and sort order. e.g. FIELD_NAME_3|ASC will order results by the values of FIELD_NAME_3 in ascending order. Alternatively DESC will sort in descending order.
DISPLAY SELECT OPTIONS
Default blank - no selection options. Two values are required seperated by pipe delimeter, select method type and position. e.g. 0|1 would display radio buttons to the left of each record, 1|2 would display checkbox fields to the right of each record.
Default blank - no custom query. Enter a mySQL query statement (to be inserted after WHERE in SQL statement) to select specific records. e.g. FIELD_NAME_2 = 'VALUE' Or more multiple values, e.g. FIELD_NAME_2 = 'VALUE' AND FIELD_NAME_3 LIKE 'ANOTHERVALUE%'
HTML or text to be displayed after column headers but before records.
HTML or text to be displayed after records but before page listings row.
HTML or text to be displayed instead of 'Page 1 or 2' text.
System Requirements:No special requirements.
Program Release Status:
Program Install Support: Install and Uninstall