phpGrid

What is phpGrid?

Create datagrids in minutes, not hours.

Create beautiful, editable and fully customizable PHP grids with just two lines of code.

• Build PHP CRUD applications
• Supports all major databases
• Editor WYSIWYG
• Master detail and subgrid
• Ajax file upload
• Composite key support
• CSV, Excel, PDF Export
• Conditional formatting

Master detail and subgrid

With just a simple function call, you'll have a grid or subnet of detailed data from the interactive master.

The main detail datagrid can be nested to show relationships for hierarchical data of multiple levels.

Advanced form elements for editing

phpGrid supports all HTML form elements for editing, such as text box, textarea, select, check box, password, autocomplete, and WYSIWYG!

After you turn on editing, set the types of data grid editing controls for any editable column.

Custom data validation

phpGrid supports automatic data validation based on the database data type, as well as user-defined validation javascript for more complex data editing rules.

Client-side validation

Users can use their own javascript validation function for more complex data editing rules.  You can even compare data between multiple columns. Once you have obtained the cell value, you can develop an even more complex JavaScript function to validate your data.

Server-side validation

For server-side data validation, in your javascript function, use jQuery.ajax.

Column grouping

Group data easily by simply setting the column name using the grouping method in your PHP datagrid.

phpGrid can group data by columns. Simply define a column name in which collation occurs. In addition to defining the grouping column, define the summary field by passing the column name and summary type, which can be sum, count, avg, min, or max.

Conditional formatting

By applying conditional formatting to a cell or row of the datagrid, you can quickly identify variations in a range with a quick look.

Ajax file upload

Enable file uploading to your datagrid with a single line of code.

A DataGrid Packed will make your applications shine.

With the ability to handle millions of records, a wide variety of features including CRUD, WYSIWYG, file upload, autocomplete, composite primary key and full export features.

System Requirements

phpGrid is independent of the operating system. It works on Windows and Linux as long as the following components are installed:

PHP 5.3 or later

Apache, Tomcat, or Microsoft IIS web server

Main relational database such as MySQL/MariaDB, PostgreSQL, SQL Server, Oracle, DB2, SQL Lite, Access etc.