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

  Author Author  
Picture of Andry Zulfikar
Name: Andry Zulfikar <contact>
Classes: 1 package by
Country: Indonesia Indonesia
Age: 35
All time rank: 268346 in Indonesia Indonesia
Week rank: 763 Up12 in Indonesia Indonesia Up
Innovation award
Innovation award
Nominee: 1x


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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.

  Classes of Andry Zulfikar  >  Data Pivot  >  Download Download .zip .tar.gz  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Data Pivot
Base name: data-pivot
Description: Query MySQL a database to display a data pivot
Version: 1.0
PHP version: 5.0
License: Free for non-commercial use
All time users: 606 users
All time rank: 4661
Week users: 2 users
Week rank: 863 Up
 
  Groups   Screenshots Screenshots   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image HTML HTML generation and processing View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes

  Files folder image Screenshots  
screenshot.jpg
File Role Description
Accessible without login Image file screenshot.jpg Screen screenshot view data pivot


  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

  User ratings  
Not enough user ratings

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

Install with Composer Install with Composer - Download Download all files: data-pivot.tar.gz data-pivot.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.