On various occasions, we want instant access to see or edit our database tables without having time to write a whole module with add, edit, delete, list, search (CRUD) operations. Whether your database is SQL Server, Oracle, MySQL or PGSQL — PHP Grid provides you easy solution that takes database credentials in config and provide [...]
I just added a new feature, that allow you to have multiple subgrids at same level.
Usage is pretty easy, just define 2 grids as detail grid and it’ll be there when expanded.
Active licensed customers can request latest build & demo files via email (firstname.lastname@example.org)
New How-tos have been added based on our valuable customer’s feedback.
Q) How to add custom buttons in add/edit dialogs?
Q) How to post data using JS code?
Q) How to do grouping on more than 1 field?
Q) How to reload parent after new record added in subgrid ?
At instances, we wish to perform an operation on all selected rows at once. For e.g.
– Changing the Status from pending to approved for all selected rows
– Or you may want to send email to all selected records
For such cases, I’ve updated the library to enable the bulk update [...]
I’ve added a most requested feature, after which we’ll have more control on the fields (columns) on grid. After that, grid can easily to integrated with any ACL (access control list).
1) If you want a column to be editable on ‘Add Record’ but readonly on Grid Listing and Edit dialog, Set it readonly, in [...]
Most awaiting feature of File Upload support is added to the latest build of PHP Grid Control. With just little config settings, you can upload file to a folder on your server. You can also use on_insert / on_update callbacks to store the uploaded content in database or email as per your need.
Following settings [...]
Now you can have a grouped headers in phpgrid control. It would help in categorizing your related columns. See screenshot.
The grid configuration is fairly simple, by calling following function with desired parameters.
// group columns header $g->set_group_header( array( “useColSpanStyle”=>true, “groupHeaders”=>array( array( “startColumnName”=>’name’, // group starts from this column “numberOfColumns”=>2, // [...]
I’ve added twitter bootstrap support with PHP Grid Control. Now you can integrate it seemlessly in Twitter Bootstrap based UI layouts based . Here are few highlights.
You can see sample live demo here. This is currently available with premium version. Existing [...]
Just added new formatting feature, Column Color Formatting, which enables you to set color and css style of some specific column of grid just like we do in excel.
// if nothing set in ‘op’ and ‘value’, it will set column formatting for all cell
$f = array();