A lot of exciting new features are added in this product. The magic is it’s all transparent using PHP Class. You can need to switch on/off the feature with no backend complex jqgrid/php coding.

Search with Multiple Group Conditions

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.

UPDATE (19th Nov, 2014):
We have rolled out several features that we wish our visitors to be aware of.

1) Multiselect Filter:
Added a new filter option, that let you filter columns having a dropdown with checkboxes to select multiple items. It also support textbox to quickly search your desired item within filter options. This is similar to excel like auto filtering.
Live Demo: http://www.phpgrid.org/demo/demos/integrations/multiselect-filter.php

2) Select2 Integration:
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.

3) New Additions to Form Layout Design:
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)

UPDATE (31st July, 2012): New featured examples include Postgresql integration samples, Conditional Display of Buttons / Data in Rows. Product now got a new home www.phpgrid.org with a new version 1.4.6. Refer this site for all future updates.

Technical support in paid package for Intergation with CakePHP, CodeIgnitor, Zend Framework & WordPress. CakePHP & Jqgrid integration is now easier than never before using our PHP Grid library. No need to go in complex JQgrid Javascripts. Just utilize this component and release quickly.

Roadmap:

– Bulk Updates

– Custom JS validation

– Excel view like google-docs (auto refresh, row/cell lock)

UPDATE:Version 1.4.5 is available (February 12, 2012) – for paid members

– support for all major databases (mysql,pgsql,mssql,sybase … and odbc support) (db-layer.php)

– inline row addition (excel_view.php)

– pdf export custom template sample (export-pdf.php)

– export to pdf/excel in same grid

– fix for non integer primary key

– fix for mysql keyword based column name

– Fix for non-integer PK column

– multiselect fix in lib jqgrid 4.3.1

UPDATE: 21st December, 2011

Version 1.4 is available

Features:

– Datepicker integration

– Group by field

– Runtime change “group by” field

– Password mask formatter / edittype

– Excel export support for numeric columns

UPDATE: 21st July, 2011

Version 1.3 is available

Features:

– PDF export feature (export-pdf.php)

– Multiple fonts in pdf export

– External link with grid data (external-link.php)

– Export filtered/all data option

– Export specific columns (export-pdf.php, $col[“export”] = false;)

Fixes:

– persist where filter in export option

– Jquery fix for IE

– utf8 encoding fix

– json fix for php 5.1

– slashes fix

UPDATE: 31st December, 2010

1. Version 1.2 is available

– Several bug fixes (with thanks to all reporters)

– Support for Subqueries

– Must review README.txt when migration from previous implementations

– Get latest version from above link

2. Image Formatter

Introduced image formatter to display image in grid, if URL is fetched from DB.

Hi I have a problem passing a variabile in $select_command
$g->select_command = “select * from corsi_users_single where segreteria=1 and ID_utente=”.$_POST[‘user’];
doesn’t work, but
$g->select_command = “select * from corsi_users_single where segreteria=1 and ID_utente=1″;
works.

If there’re no parameters, the query is $g->select_command = “select * from corsi_users_single where segreteria=1″;
But when there’re one or two parameters, I get only the result as the last query, even if there’re no parameters.
Is a problem by mi code or a jqgrip problem?

By encryption, do you mean ****** or md5 related thing.
for masking, just change $col[“edittype”] = “password”;
for md5, you need to write custom update/insert code, which is a part of paid package. For details contact gridphp@gmail.com

I am trying to use as i stated below but the grid fill the old value how can i use from a form value with out sorting
if(isset($_post[‘txtClintId’]))
{
$g->select_command = “SELECT * FROM (SELECT i.id, invdate , c.name,
i.note, i.total FROM invheader i WHERE i.client_id”.$_post[‘txtClintId’].”) o”;
}
else
{
$g->select_command = “SELECT * FROM (SELECT i.id, invdate , c.name,
i.note, i.total FROM invheader i) o”;
}