eclipxe13/engineworks-pivot - PHP Pivot (dynamic tables)
Use this library to retrieve a pivot table (aka dynamic table) from a database.
The pivot allows you to define a source (a table, a view or a query), source fields, filters, rows and columns to group by and aggregators to operate (like sum, average, count, standar deviation...). All this pivot structure can be stored and loaded in xml files and modified at runtime.
After a pivot structure has been set, you can query the database for the results and receive a organized information no navigate. The library includes a formatter helper class to create an XHTML Table based on a query result.
Use composer to install this library
composer require eclipxe/engineworks-pivot