PHP Classes

Data Grid Object: Display MySQL query results in HTML tables

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 46%Total: 2,655 All time: 1,441 This week: 488Up
Version License PHP version Categories
datagrid_object 1.0.0The PHP License5HTML, Databases
Description 

Author

This class can be used to display MySQL query results in HTML tables.

It is based on another class originally written by Carlos Miguel Guevara.

This version includes several enhancements:

- The code no longer issues warnings with E_STRICT error reporting enabled
- Produces XHTML compliant HTML
- Present all the information in the HTML table, including pagination
- Provide Javascript callback functions to manipulate the data like for instance deleting record
- Support additional query string parameters for the navigation links

Picture of Atasa Rossios
Name: Atasa Rossios <contact>
Classes: 1 package by
Country: Greece Greece
Age: ???
All time rank: 119712 in Greece Greece
Week rank: 195 Up4 in Greece Greece Up

Details

DataGrid Object PHP Class By Atasa Rossios This class is a cuntinuation of a class made by Carlos Miguel Guevara. (http://www.phpclasses.org/browse/package/2599.html) I keep him informed about the changes I do. I was looking for a Datagrid class similar to Flash Datagrid. I like the way you can customize it, clean and simple. From what I have seen here, Carlos Class was near about. The reason I uploaded, is to play around with some other people, exchenge ideas, and make a real good component. So the Functionality of this class is, bind a mysql query to a html table. Here are the Details 1. Description According to Carlos: This class can be used to display MySQL database query results in HTML tables. The class executes a given SQL query and generates an HTML table that displays the query results. The class can associate a query result column with a given text that is used to display as title of the table as column header. The class may also generate navigation links to split the query results table listing in multiple pages with a limited number of results per page. 2.Customization Just Edit the Css file to your taste. I am not going to say somenting else about css 3. Enhancements I have add a. Reorganize the class, It now validates under E_STRICT b. Produce clean XHTML code c. Bind all the information in the html table it self, includig Paging etc d. Add Javascript Callback functions support [deleteRecord('id','Params')] e. Add Optional extra query string additions on the links [page.php?id=1&action=delete)] 3. Instalation Very Simple. You will have to bind a SQL query against any SQL Table you have, to see the results 4. Contact I am open to any additions, enhancements, ideas to implement. So feel free to contact me at atasa.rossios@gmail.com Atasa Nick Rossios

  Files folder image Files (4)  
File Role Description
Plain text file datagrid.class.php Class the class file
Accessible without login Plain text file example.php Example An example file
Accessible without login Plain text file README.txt Doc. Some notes to you
Accessible without login Plain text file style.css Data The style Customization File

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,655
This week:0
All time:1,441
This week:488Up
User Ratings User Comments (1)
 All time
Utility:56%StarStarStar
Consistency:68%StarStarStarStar
Documentation:43%StarStarStar
Examples:68%StarStarStarStar
Tests:-
Videos:-
Overall:46%StarStarStar
Rank:3234