Although there are PHP-based grid controls available, they lack the feature set that developers can get with grid controls for non-Web applications. JomiTech has attempted to fill this void with their new PHP grid control, PlatinumGrid.
If the PlatinumGrid website (https://www.platinumgrid.com) is anything to go by, it packs an impressive feature set. In this review, we’ll take a look at some of them. Although PlatinumGrid is designed to support all PHP applications and frameworks, we’ll naturally be reviewing PlatinumGrid in the VCL for PHP framework.
PlatinumGrid displaying InterBase sample database
One big key item for web grid controls is performance. Grids have to be fast. Because PlatinumGrid only processes the smallest amount of data that it needs to show to the user, it can handle large datasets rapidly. Paging through a 300,000 record dataset is extremely fast, with the grid returning the page in less than a third of a second.
Using AJAX and reducing the number of postbacks performed is an important part of enhancing web application performance. PlatinumGrid has built-in support for AJAX, just flip the UseAjax property to “true” on your page and the grid becomes 100% AJAX enabled.
An intriguing feature is the master-detail view support in PlatinumGrid. This grid can embed another PlatinumGrid instance inside a row at runtime, to show the detail view for that row. This is done without writing any code, just drop another PlatinumGrid component on the page, connect it to the detail data source, and set the 3 Detail View properties on the master grid. Everything else is handled automatically.
PlatinumGrid displaying detail view of sample database
Other codeless features include sorting and filtering. With sorting enabled, clicking on any column header will automatically sort by that column. Clicking again on the column header will reverse the sort order.
PlatinumGrid sorting on 2 columns
For applications which need complete control over what the grid is doing, PlatinumGrid provides 16 server side, and 5 client side events. These events allow the application to control everything from the SQL generated for retrieving the result set to the data that is finally shown in the grid.
PlatinumGrid is sold as a subscription for $129 USD, and if you’re an existing JomiTech Components For PHP Full subscriber, you can get it at a 30% discount.
In conclusion, PlatinumGrid definitely packs the features that developers need. Although we weren’t able to look at all of the features, even the ones we did manage to look at demonstrated amazing power. PlatinumGrid definitely provides the PHP developer with a grid that can handle any application’s needs.
PlatinumGrid from JomiTech
Delphi for PHP from Embarcadero Technologies