We recently added support for Firebird & SQLite Databases. These fast, slick and reliable databases will help in running portable apps with PHP Grid. Thanks to PDO library, it’s integration is very with little configuration changes.

// Database config for SQLite
$db_conf = array();
$db_conf["type"] = "pdo";
$db_conf["server"] = "sqlite:../../sampledb/northwind.sqlite";
$db_conf["user"] = "";
$db_conf["password"] = "";
$db_conf["database"] = "";
$g = new jqgrid($db_conf);

// Database config for Firebird
$db_conf = array();
$db_conf["type"] = "pdo";
$db_conf["server"] = "firebird:host=localhost;dbname=C:/sampledb/employee.fdb";
$db_conf["user"] = "SYSDBA";
$db_conf["password"] = "masterkey";
$db_conf["database"] = "";
$g = new jqgrid($db_conf);

Working demo code: http://www.phpgrid.org/demo/demos/loading/db-layer-firebird.phps

You will need to change database credentials and update tables/columns configuration as desired. Refer docs for help.

Licensed customers can request free upgrade using update link.
To download free license, visit download page.
To purchase license, you can visit this link.

Hello,

We’ve added most robust and efficient complex searching method in PHPGrid.

This enables the more advanced search dialog allowing to add any number of complex group conditions. The user can now add or delete an unlimited number of conditions to perform the search as shown in screenshot.

This will formulate following search query, “( … )” refers groups in search query:

(name LIKE "%An%" OR company LIKE "%Mar%") 
AND 
(name LIKE "%Fa%" OR company LIKE "%Far%") 
AND 
gender = "male" AND client_id < 25

Hope you like this feature. Customers with active subscription can get latest build + demo via email.
We also offer discounted renewal prices for customers with expired subscription.
For any case, contact on our support team at ([email protected]).

Now you can export selected rows and columns at runtime. This means no code change, Export selection options are now on accessible with grid operations toolbar.

Demo: http://phpgrid.org/demo/demos/export/export-selected.php

In demo, select columns using column chooser and rows by multiselect option, then click Export selected button. This will export PDF of selected rows/cols. As the grid exports PDF format, the data table can be printed by your favorite PDF reader.

When we have many columns in a grid with less amount of data in cells, there is a requirement to have vertical text in column headers to improve overall visibility. On several requests, this feature is added now. You can define text angle and other SVG attributes like font style etc.

Live demo: http://www.phpgrid.org/demo/demos/appearence/vertical-header.php

Based on several customer’s feedback, We’ve now integrated ‘Select2’ control with PHP Grid.

Now you can use ‘Select2‘ control with PHP Grid’s Add or Update operations. Select2 is a jQuery based replacement for select boxes. It supports searching, with in your large select box data items. It gives behavior similar to ‘Combo-box’ control of Microsoft development tools.

Active license holders can get their update by emailing [email protected]
One can also refer demos/integration/dropdown-select2.php demo.

We have made several additions in our customized dialog layout feature.

1) You can have 2, 4, 6 column layout in your Add or Edit dialog forms of PHP Grid.
2) You can also Add sections (sub-titles) within form to separate input data group.
3) A field can span to several columns where required. (e.g. Id)
4) Custom form buttons are also supported. (e.g. Load Default)

If you have some wishlist, feel free to share your suggestions with us at our support email address ([email protected]).