PHP Classes
elePHPant
Icontem

DataGrid: Display paginated MySQL query results in a grid

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   Screenshots Screenshots   View files View files (9)   DownloadInstall with Composer Download .zip   Reputation   Support forum (6)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2006-10-28 (8 years ago) RSS 2.0 feedStarStarStarStar 73%Total: 3,601 This week: 3All time: 874 This week: 394Up
Version License Categories  
datagrid_class 1.0.0FreewareHTML, Databases
Description Author  

This class can be used to display paginated MySQL query results in data grid.

It renders an HTML table with listings of data retrieved results of a given MySQL query.

The listings can be split between pages with a limited number of result rows per page.

The column names appear as links that can be clicked to sort the listing by the respective query results column.

The presentation details can be customized with CSS stylesheets.

Picture of samik71
Name: samik71 <contact>
Classes: 1 package by
Country: Israel Israel
Age: ???
All time rank: 8134 in Israel Israel
Week rank: 411 Up3 in Israel Israel Up

Details provided by the author  
It's very simple to get started!!!


1. Copy code_template.php file to needed directory on your server.

2. Copy folder named "datagrid" (with all includes files) in the same 
   directory on your server.

3. Create database on your database server.

4. Change the code in code_template.php file according to your needs: 
   4.1 Uncomment all needed lines commented by '//'. 
   4.2 Change all needed variable values on yours.

5. Rename code_template.php file according to your needs.

6. Enjoy!


-----------------------------------------------------------------------
See example code in example folder if you have any troubles

For more information visit: 
	site 	http://phpbuilder.blogspot.com or 
	forum 	http://www.phpbb88.com/phpbuilder/
 
Screenshots  
  • dgrid_example.JPG
  Files folder image Files  
File Role Description
Image file cal.gif Icon cal
Plain text file calendar.js Appl. calendar
Plain text file code_example.php Example code_example
Plain text file code_template.php Doc. code_template
Plain text file database_example.txt Example database_example(SQL)
Plain text file datagrid.class.php Class Class Source v.3.1.0
Plain text file documentation Doc. Documentation for PHP DataGrid v.1.x.x
Plain text file form.scripts.js Appl. javascript
Plain text file ReadMe.txt Doc. ReadMe

 Version Control Unique User Downloads Download Rankings  
 0%Total:3,601All time:874
 This week:3This week:394Up
 User Ratings  
 
 All time
Utility:100%StarStarStarStarStarStar
Consistency:75%StarStarStarStar
Documentation:75%StarStarStarStar
Examples:81%StarStarStarStarStar
Tests:-
Videos:-
Overall:73%StarStarStarStar
Rank:121