Guriddo PivotGrid for PHP inherits the jqGrid for PHP class, so you can use most of the features you are already familiar with: column resizing, formatter, cell renderers, row/cell events etc. The PivotGrid can be used when you want to get summation and pivot features that aren’t provided in the Guriddo jqGrid PHP. This component is included as a part of Guriddo jqGrid PHP and is a bonus to the package.
Guriddo TreeGrid PHP is written in pure PHP. This means that the class can be integrated in any PHP framework including Zend, Cake PHP, Doctrine PHP and much more.
The PHP component automatically handles data retrieval. No need for custom code – you can have a fully functional pivot grid with just a few lines of PHP
Up to the moment Guriddo PivotGrid PHP Supports the following Databases: AdoDB wrapper, Array data, IBM DB2, MongoDB, Microsoft SQL Serrver, MySQLi, ODBC, Oracle, PDO (with MySQL, PostgreSQL, SQLite, SQL Server)
Browser support is an important part of our grid. Guriddo support all modern mobile and desktop browsers including the iPhone/iPad and Internet Explorer from version 8. Browser support reference is tested regularly with all major browsers.
Basic pivot require minimal settings. To break down the dataset into simple summary, you just have to configure the xDimention object.
Multiple levels are supported, so you can just specify them in the y and x Dimensions. Grouping the rows and/or columns is done automatically when two or more levels are set in xDimension and/or yDimension. Now that you broke down the dataset on the y and x Dimension, it’s time to aggregate the cell values. Several kinds of aggregations are available including: sum, min, max, count etc. Future release will provide your own aggregation function.