Interactive Datagrid Resizing

Thu, 16 Sep 2010 23:53:12 +0000

When enabled, the small triangle icon is displayed at the right bottom corner of the grid. The php grids can be resized by simply click and drag the icon using mouse. This is more convenient than setting the width and height in the code.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

// 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 products", "productCode", "productCode");
$dg ->set_col_title("productCode", "Product Code");
$dg ->set_col_title("productName", "Product Name");
$dg ->set_col_title("productLine", "Product Line");

// display static Url
$dg ->set_col_link("productUrl");

// dynamic url. e.g.http://www.example.com/?productCode=101&foo=bar
$dg -> set_col_dynalink("productCode", "http://www.example.com/", "productCode", '&foo=bar');

// column format
$dg -> set_col_currency("buyPrice");
$dg -> set_col_format("quantityInStock", "integer", array("thousandsSeparator" => ",",
"defaultValue" => "0"));
$dg -> set_col_format("MSRP", 'currency', array("prefix" => "$",
"suffix" => '',
"thousandsSeparator" => ",",
"decimalSeparator" => ".",
"decimalPlaces" => '2',
"defaultValue" => '0.00'));

// the above line is equivalent to the following helper function
$dg -> set_col_currency("MSRP", "$", '', ",",".", "2", "0.00");

// display image
$dg -> set_col_img("Image");

// enable resize by dragging mouse
$dg -> enable_resize(true);

$dg -> display();

See Live Example!

The post Interactive Datagrid Resizing appeared first on phpGrid - PHP Datagrid.

resize Archives | phpGrid - PHP Datagrid

Interactive Datagrid Resizing