Login   Register  
PHP Classes
elePHPant
Icontem

Data Pivot: Query MySQL a database to display a data pivot

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 (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2012-03-09 (2 years ago) RSS 2.0 feedNot enough user ratingsTotal: 636 This week: 2All time: 4,572 This week: 790Up
Version License PHP version Categories  
data-pivot 1.0Free for non-commercial...5.0HTML, Databases
Description Author  

This class can query MySQL a database to display a data pivot.

It can execute queries to a given MySQL database table retrieve data for a pivot view given the table name, base field, pivot field, summary field and an optional order field.

The class returns the pivot data in an array.

Innovation Award  
PHP Programming Innovation award nominee
March 2012
Number 3


Prize: One downloadable copy of Komodo IDE
Pivot tables are useful to display tabular information and summaries that help the user to have a good view of relevant aspects of the table data in aggregate.

This class provides a solution for generating pivot table views from data stored in MySQL database tables.

Manuel Lemos
Picture of Andry Zulfikar
Name: Andry Zulfikar <contact>
Classes: 1 package by
Country: Indonesia Indonesia
Age: 36
All time rank: 265644 in Indonesia Indonesia
Week rank: 732 Up12 in Indonesia Indonesia Up
Innovation award
Innovation award
Nominee: 1x

Screenshots  
  • screenshot.jpg
  Files folder image Files  
File Role Description
Files folder imageclass (2 files)
Plain text file config.php Conf. config file
Plain text file index_class.php Example example file

  Files folder image Files  /  class  
File Role Description
  Plain text file db.php Class class for connect database, describe table and fetch data
  Plain text file pivot.php Class class for data pivot

 Version Control Unique User Downloads Download Rankings  
 0%Total:636All time:4,572
 This week:2This week:790Up
 User Comments (1)