PHP Classes

Pivot table: Convert SQL Query results to pivot table

Recommend this page to a friend!
  All requests RSS feed  >  Pivot table  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

Pivot table

Edit

Picture of muabshir by muabshir - 9 years ago (2016-03-21)

Convert SQL Query results to pivot table

This request is clear and relevant.
This request is not clear or is not relevant.

+6

I am looking a class that can get a SQL query and convert the selected columns and rows into pivot table like Microsoft Excel.

I want to use this in an online report system. Can any one please help?

Ask clarification

1 Recommendation

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

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.
This recommendation solves the problem.
This recommendation does not solve the problem.

+3

Picture of Manuel Lemos by Manuel Lemos Reputation 26695 - 9 years ago (2016-03-30) Comment

This class seems to do exactly what you ask. It executes queries to a MySQL database to retrieve data for a pivot view given the table and field parameters.

Recommend package
: 
: