Excel, HTML, PDF, or CSV Export

phpGrid currently supports export in native Excel format and HTML format. When the export feature is enabled, phpGrid displays an export icon in the footer. Also see enable_export().

PDF and CSV formats are now supported (Available to Professional License and up) !

export_icons

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
// change column titles
$dg->set_col_title("orderNumber", "Order No.");
$dg->set_col_title("orderDate", "Order Date");
$dg->set_col_title("shippedDate", "Shipped Date");
$dg->set_col_title("customerNumber", "Customer No.");
// hide a column
$dg->set_col_hidden("requiredDate");
// change default caption
$dg->set_caption("Orders List");
// EXCEL export
$dg->enable_export('PDF');
$dg->display();


$dg2 = new C_DataGrid("select * from customers", "customerNumber", "Customers");
// PDF export
$dg2->enable_export('EXCEL');
$dg2->display();

See Live Example!

Tags: , , ,

Top