AJAX data listings engine

Category: PHP - Database

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 NAME Specify the mySQL database table name. FIELD NAMES 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 COLUMN HEADERS Default 1 - true. 0 - false. When true the column headers will be shown and column sorting features will be available. PAGE LISTINGS 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 SORTING 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. QUERY 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%' HEADER HTML or text to be displayed after column headers but before records. FOOTER HTML or text to be displayed after records but before page listings row. BUTTONS HTML or text to be displayed instead of 'Page 1 or 2' text. Date: 06 March, 2012


Data Listings - Listings Engine - AJAX Data - Data - Listings - Ajax

Homepage: http://www.opencrypt.com

Developer: opencrypt.com

License: Artistic License, GNU General Public License (GPL)

Operating System: Windows, Linux, Mac OS, BSD, Solaris

Add a Comment

all are required fields

     
What do you think of this resource?

Select Your Rate:

Votes:0

 

Related Scripts Download

GNU ddrescue copies data from one file or block device (hard disc, cdrom, etc) to another, trying hard to rescue data in case of read errors.

developer Developer: Free Software Foundation, Inc.
license License: GNU General Public License (GPL)
operating systems Operating System: OS Independent


The Data Generator is a free, GNU-licensed, open source script written in JavaScript, PHP and MySQL that lets you quickly generate large volumes of custom data in a variety of formats for use in testing software and populating databases.

developer Developer: Benjamin Keen
license License: GNU General Public License (GPL)
operating systems Operating System: All


Create dynamic-easy-to-use data grid controls for your web site in seconds.

developer Developer: Mike Frank
license License: BSD License
operating systems Operating System: Any


Provider of data recovery software offers file rescue solution to retrieve lost, missed data from damaged storage media.

developer Developer: Data Recovery Reviews
license License: GNU General Public License (GPL)
operating systems Operating System: Not Available


Official site for LAN USB drive disabler tools that records each and every USB activities performed on client machine.

developer Developer: USB Port Blocker
license License: GNU General Public License (GPL)
operating systems Operating System: Not Available


Downloads available for file recovery tools that provide solutions for almost any data lost situation covering a variety of storage devices.

developer Developer: windows vista file recovery
license License: GNU General Public License (GPL)
operating systems Operating System: Not Available


Keylogger program records typed characters, digits, special symbols and any other data entered by keyboard in an encrypted text file.

developer Developer: Keylogger
license License: GNU General Public License (GPL)
operating systems Operating System: Not Available


Data Generator is a free, open source script written in JavaScript, PHP and MySQL that lets you quickly generate large volumes of custom data in a variety of formats for use in testing software, populating databases, and more.

developer Developer: generatedata.com
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows, Linux, BSD, Solaris


Epesi is a lightweight PHP/AJAX based framework for development of database driven web applications.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris