AJAX data listings engine for Scripts 1.0

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 system supports AJAX column sorting and page listings and offers a search facility. The engine generates both AJAX and non-javascript versions of the data listings so older web browsers will still be able to use the column sorting, page listing and search facilities.The ten input flags can be used:TABLE NAMESpecify the mySQL database table name.FIELD NAMESSeparated by pipe delimeters, enter the field names in the order they should be shown. e.g. FIELD_NAME_1|FIELD_NAME_2|FIELD_NAME_3COLUMN HEADERSDefault 1 - true. 0 - false. When true the column headers will be shown and column sorting features will be available.PAGE LISTINGSDefault 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 SORTINGDefault 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 OPTIONSDefault 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.QUERYDefault 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%'HEADERHTML or text to be displayed after column headers but before records.FOOTERHTML or text to be displayed after records but before page listings row.BUTTONSHTML or text to be displayed instead of 'Page 1 or 2' text.

Requirements:	No special requirements
Platforms:	PHP
Keyword:	Ajax,  Ajax Data,  Blank,  Column,  Data,  Data L,  Data Listings,  Database,  Delimeter,  Display,  Displayed,  Engine,  Engine Scripts,  Field,  Headers,  Listings,  Listings Engine,  Mysql,  Order,  Records,  Required,  Scripts,  Seperated,  Sorting,  Statement
Users rating:	0/10