PHP Classes

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

Recommend this page to a friend!
     
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 56%Total: 1,003 This week: 1All time: 3,642 This week: 36Up
Version License PHP version Categories
data-pivot 1.0Free for non-comm...5.0HTML, Databases
Description 

Author

Andry Zulfikar

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: 46
All time rank: 236236 in Indonesia Indonesia
Week rank: 44 Up3 in Indonesia Indonesia Up
Innovation award
Innovation award
Nominee: 1x

Recommendations

Pivot creation via front-end
Need a package for Pivot creation via front-end

Pivot table
Convert SQL Query results to pivot table

Screenshots (1)  
  • screenshot.jpg
  Files folder image Files (5)  
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 (5)  /  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

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
Downloaddata-pivot-2012-03-09.zip 45KB
Downloaddata-pivot-2012-03-09.tar.gz 45KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,003
This week:1
All time:3,642
This week:36Up
User Ratings User Comments (1)
 All time
Utility:83%StarStarStarStarStar
Consistency:75%StarStarStarStar
Documentation:-
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:56%StarStarStar
Rank:1770
  

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.