6.9 Archives | phpGrid - PHP Datagrid

Drag and Drop Grouping

Wed, 15 Jun 2016 12:06:07 +0000

* Please note this feature is only available in commercial licenses.

You can enable drag & drop a column header to group by that column with a single function call to “enable_dnd_grouping()”. Once it’s enabled, you can drag a column header and drop above the grid where it says “Drop column headers here”.

1
2
3
4
5
6
7
8
9

[cc lang="php"]
// Always include namespace and conf.php on TOP of the script.
use phpCtrl\C_DataGrid;
require_once("/file/path/to/conf.php");

$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
$dg->enable_edit('INLINE');
$dg->enable_dnd_grouping(true);
$dg -> display();

Launch Demo!

The post Drag and Drop Grouping appeared first on phpGrid - PHP Datagrid.

Persist State of the Sort Order and Page On Page Reload

Thu, 09 Jun 2016 19:22:49 +0000

Sometimes you need the datagrid to be able to remember sort order and current page. For that, it requires only a single function call to “enable_persist_state()” function to enable this feature. It stores current page, sort name, sort order, and even filter information in the HTML5 “localStorge” automatically. This is different from Cookie or Session because the data stored in localStorage has no expiration time.

When you need to clear what’s int the localStorage for the current datagrid, click the “refresh” icon in the footer.

Note it does not support subgrid.

1
2
3
4
5
6
7
8

use phpCtrl\C_DataGrid;
require_once("/file/path/to/conf.php");

$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
$dg->enable_edit('INLINE');
$dg->enable_search(true);
$dg->enable_persist_state(true);
$dg->display();

Launch Demo!

The post Persist State of the Sort Order and Page On Page Reload appeared first on phpGrid - PHP Datagrid.

Copy Row

Sat, 28 May 2016 09:12:48 +0000

You can now clone a row by simply calling “enable_copyrow()” function. Once it’s enabled, select a row and then in “Copy Row” button in the footer. It will duplicate the selected row in the database table and even return the auto-incremented ID.

1
2
3

// Always include namespace and conf.php on TOP of the script.
use phpCtrl\C_DataGrid;
require_once("/file/path/to/conf.php");

Note that this feature requires the primary key is an auto-increment type.

1
2
3
4

$dg = new C_DataGrid("SELECT `orderNumber`, `orderDate`, `requiredDate`, `shippedDate`, `status`, `comments`, `customerNumber` FROM `orders`", "`orderNumber`", "orders");
$dg -> enable_edit("FORM", "CRUD");
$dg -> enable_copyrow(true);
$dg -> display();

Launch Copy Row Demo!

The post Copy Row appeared first on phpGrid - PHP Datagrid.