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


Picture of muabshir by muabshir - 7 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.


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


Picture of Manuel Lemos by Manuel Lemos Reputation 23115 - 7 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