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

Recommend this page to a friend!
  Info   Screenshots   View files (4)   Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 976 This week: 1All time: 3,676 This week: 255
Version License PHP version Categories
data-pivot 1.0Free for non-comm...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.


Pivot table
Convert SQL Query results to pivot table

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: 42
All time rank: 236036 in Indonesia Indonesia
Week rank: 243 3 in Indonesia Indonesia
Innovation award
Innovation award
Nominee: 1x

  • screenshot.jpg
File Role Description
class (2 files)
config.php Conf. config file
index_class.php Example example file

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

 Version Control Unique User Downloads Download Rankings  
This week:1
All time:3,676
This week:255
User Comments (1)

For more information send a message to info at phpclasses dot org.