Reputation: 534
Does there exist any php/mysql framework/product that helps you to build same kind of data tables as known from pivot tables in Excel?
Upvotes: 1
Views: 3811
Reputation: 407
Is an old question but, there is an excelent article about it. http://www.ibm.com/developerworks/library/x-excelpivotphp/ basically, create your pivot in excel, save as xml, you may have 2 files: one with the data and another with the pivot structure. Then create the data xml with php at anytime and open the pivot table. Sweet.
Upvotes: 3
Reputation: 21
You can use any of the Pivot Table components. E.g. here's a showcase of connecting one to php/mysql simply via CSV http://www.flexmonster.com/blog-connect-database
Upvotes: 0