PHP Classes
elePHPant
Icontem

Data Grid Object: Display MySQL query results in HTML tables

Recommend this page to a friend!
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2006-11-29 (9 years ago) RSS 2.0 feedStarStarStar 48%Total: 2,638 This week: 3All time: 1,398 This week: 377Up
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

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  
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

 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,638
This week:3
All time:1,398
This week:377Up
User Ratings User Comments (1)
 All time
Utility:58%StarStarStar
Consistency:75%StarStarStarStar
Documentation:41%StarStarStar
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:48%StarStarStar
Rank:2207