phpGrid 7.2.9This is a bugsfix release. +Bugfix:     * Added missing .map files for Safari    * Returning proper empty JSON with 'die' in masterdetail, or 'undefined' error message shows up that overlays the master detail grid    * Upgraded jQuery Migrate 3.0.1 from 1.21    * Removed ending PHP closing tags    * Updated file upload script to be compatible with jQuery 3+Demos:    * Multiple datagrid to take approx 1/4 of the screen height. phpGrid 7.2.8+ Features:* Datepicker, Datetimepicker, Timepicker are now automatically used based on the type returned from ADOdb Mysqli driver. Before it was only Datepicker by default. * Ready-made apps (Enterprise PLUS)+ Enhancements:* Updated to the latest ADOdb* Replace jQuery migrate 3 with 1.2.1 for better compatibility+ Bugfix:* The detail grid loses initial filter and displays everything. Fixed.* Removed extra padding around autocomplete in form display* In edit type, set the select type empty value to literal ‘null’ ONLY when the column is NOT required so it converts to database null.* Master detail function has a warning message to overlay the page. Fixed.* PHPExcel is no longer supported by OOS. However, still fixed a bug due to UTF-8 to delay finding an alternative library. * Fixed a bug in PHPSqlparser due to PHP 7 more restrict rule on function signature. + Demos:* New connection settings "sqlsrv" for Azure SQL server & native SQL Server support. This is the new recommended database type for SQL server on Windows & Azure.* Local array data source with total* Auto scrollphpGrid 7.2.7+ Features:    * Added Timepicker support. Requires column with SQL Time data type. For database has no TIME type support, you can use Sql Datetime type and choose to show time only+ Enhancements:    * Updated to jQuery 3.3.1 with migration file 3.0.1+ Bugfix:    * Fix a bug in PHPSqlParser for PHP 7 due to mixing arguments    * Updated demo db orders table to add logTime as ’TIME’ data type    * Trim single quotes for date comp in adv search    * Fixed bug in when exporting filter “date range”    * Added open and close brackets to sqlWhere after the filter or global search will break+ Demos:    * New demo that use a column to display text and hyperlink in another    * Enhanced date demo to include timepickerphpGrid 7.2.6+ Features:    * CELL edit mode for Excel-like behaviro+ Enhancements:    * Ability to handle very large datasets! Demo included.    * Set “url” to the current executing script to address variable scoping.    * Much improved Tabbed datagrid demo    * CSS white-space set to nowrap in cell edit mode    * Added NULL sellection support in dropdown option+ Security:    * Set property “autoencode” to prevent XSS + Theme:    * Enhanced Bootstrap theme+ Bugfix:    * Set a new theme at run-time did not overwrite a property when the original theme is "bootstrap". Fixed.    * Added child grid object validation when echo subgrid and master detail debug info. + Security:+ Demo:    * Tagging with autocomplete    * Excel edit (with keyboard navigation)    * Minor update to HTML Edit Control demo    * Load from large dataset (3M records!)    * Enhanced master detail demos    * Tagged grids demo improved with a separate loaderphpGrid 7.2.5+ Features:    * New JOOMLA module (tested on 3+)    * New constant to check upload file extension        define('UPLOADEXT', 'gif,png,jpg,jpeg');+ Enhancements:    * Change datetimepicker interval from default 1 hour to 30 min    * enable_autowidth to resize to body.width instead of window.width    * Set theme footer style    * updated to the latest ADODB5 library+ Theme:    * "bootstrap" - this adds official Twitter Bootstrap support!  jqgrid   guiStyle is changed to ‘bootstrap internally (guiStyle = ‘bootstrap’)    * Ability to use Bootstrap theme + Bugfix:    * Added foreign non-ASCII character utf-8 encode in data.php for MSSQL    * SET default height and width to ‘auto’. It fixes the bottom margin issue.    * Only to include bootstrap CSS file when theme name is ‘bootstrap’    * Columnchooser now works again (broken in 7.2 dueo to wrong ui.multiselect.js and .css)    * datetimepicker chinese locale fix by mappding 'cn' to 'ch'    * Added array boundary check that fixes "undefined in foreach().."" in cls_util.php+ Security:    * Run key through the whitelist to prevent SQL injection in subgrid.php, edit.php, ajaxfileupload.php, ajaxfiledelete.php    * New prepare statement support in database class+ Demo:    * Action column custom buttonsphpGrid 7.2+ Features:    * CDN support. Default is false in conf.php     * Added Bootstrap support    * Added Fontawesome icon support    * Drag and drop rows between datagrids+ Enhancements:    * Reduced Lux theme td padding and gap for subgrid    * Increase datagrid default height from 200px to 400px    * Update save selected row demo wording+ Bugfix:    * Hide horizontal scroll bar when enable_autowidth is set to true    * set_caption to convert blank to  + Demo:    * Load custom form from an iframe in the Modal window    * Display remaining characters used in a field on edit form    * Drag and drop rows between grids demo. Users must implement custom save function    * Bulk edit save sample code updatedphpGrid 7.1.5+ Features    * jQuery rating supported (custom editing is WIP)+ Enhancements    * Subgrid add new populates linking key value autmoatically from the parent.     * set_col_hidden() can take an array of string separated by comma.     * New static $load_ajaxComplete flag to ensure the javascript ajaxComplete is only fired once.+ Bugfix    * Added missing comma in file upload javascriptphpGrid 7.1+ Enhancement:    * set_masterdetail now has a 3rd parameter as the master foriegn key. Linking keys no longer need to be the same name!    * Pivot grid to handle large data set    * 5th parameter in set_group_properties to hide group details+ Bugfix:    * display_style internal function is now rendered after output buffer starts so styles won’t injected above HTML tag.+ Demo:    * Change calendar week start day    * Database administration demophpGrid 7.0+ Form-only mode    * Blank form    * Load form from existing record    * Theme support    * Group header    * Tooltip    * Redirect after submit- Wysiwyg color picker support- CRUD success/error status display- Session Manager- Joomla! 3.x ready (FRAMEWORK)- ADOdb 5.20 + Bugfix:     * Add new row in inline edit - New tabbed datagrid demophpGrid 6.9+   Features    *   Drag and Drop grouping support!    *   Clone selected row    *   PHP namespace full support!    *   Persist column settings    *   New conditional formatting with custom javascript demophpGrid 6.7.10+   Features    *   Added 2nd parameter in set_multiselect() so pagination will not clear selected row when set to true.   +   Bug fixes:    *   Column sorting is working again    *   INLINE edit to set focus on selected cell+   Demo udpate:    *   Complex query support using array+   Framework update    *   jqGrid 4.10.0phpGrid 6.7 +   Features    *   PHP 7 support!    *   PDF class updated to support PHP 7    *   Native Excel export (requires PHPExcel)    *   ADOdb 5.20 data access library update for PHP 7 supportphpGrid 6.6+   Features    *   Column auto resize based on contained contents    *   Pivot grid support + new pivot grid example!    *   Zend Framework, DB2 Support (new downloaded added to member portal)    *   Virtual column positioning    *   New date format (date-format.php) example    *   New header tooltip function set_col_headerTooltip    *   Footer icon now wraps when the width is too small+   Framework update    *   jqGrid 4.9.2 - https://github.com/free-jqgrid/jqGrid+   Bug fixes    *   Nested dropdown bugs. It’s now fully supported in both FORM and INLINE edit mode.    *   Datepicker locale support     *   OTHER MINOR ONESphpGrid 6.53+   Features    *   PDF export now support logo through enable_export 2nd parameter.+   Demo    *   Complex query through local array+   Bug fix    *   File upload field displays Delete button when adding a new record.    *   Nested dropdown child select missing selected value during editing. Fixed.    *   MS SQL composite key WHERE clause is handled differently to confirm to its syntax.    *   CSS update to address ever expanding in edit form    *   Remove inital horizontal scroll bar enable_autowidth() by calling setTimeout;    *   Substract 18 from auto height instead of 10 so entire bar is revealed initallyphpGrid 6.52+   Features    *   Added set_col_datetime() method for datetime picker support+   Example    * Updated custom event handler example to show how to obtain auto-generated ID     * Prefill filter in toolbar search demo: Integrated_search_prefilled_filter.phpphpGrid 6.52b+   Features:    *   Added 2nd parameter to in enable_search() for Excel like auto filter (local array data source only)    *   Nested dropdown is now supported in FORM edit.+   Bug Fixes    *   Added $this->jq_gridName to javascript function names in imageFormatter and imageUnformatter    *   Required fields now display red * automatically+   Examples:    *   Google Spreadsheet integration example!    *   phpGrid and CodeIgniter Integration!phpGrid 6.51+   Features:    *   New phpGrid session class for custom session handling.    *   Integrated search is now available in detail grid.+   Exmaples    *   Bootstrap integration example    *   Laravel framework integration examplephpGrid 6.5+   Core grid library has been updated to jqGrid 4.6.+   New Features:    *   Global text search (not the same as full-text search)    *   Math operation support such as column sum, avg. etc.+   New theme:     *   Introducing Ņcobalt-flatÓ. ItÕs flat and itÕs awesome!+   Bug Fixes:    *   Fixed a bug in CSS that causes the inline edit text box height to go beyond visible height in the new flat theme    *   Added $this->jq_gridName to javascript function name imageFormatter/imageUnformatter.+   New example    *   Externalize search    *   Math operation     *   Global searchphpGrid 6.5b+   New Features and Enhancements:    *   Supports single level, multiple subgrid. This is an internal update. No new method was introduced. Use set_subgrid() to create multiple subgrids of the same master grid. Previously the later subgrid would overwrite the previous one.     *   Select and Autocomplete  edit types now support read only fields during edit, and only during edit. It doesn't affect during insert new row.+   Bug Fixes:    *   Foreign key filter is now also applied during export master detail grids. This fixes bug that produces the entire details grids when export.    *   Fix a bug that cause width resize to go crazy. It was changed from "100%" to '1000' so that subgrid width is stretched to fit the parent grid. It turns out it's more trouble than it worths.     *   New mobile example+   Misc.:    *   Modified local_array.php to include sort type.    *   Update inline action column, virtual column examples    *   Reverted FORM edit trigger event back to "ondblClickRow" from "onSelectRow" as requested by usersphpGrid 6.2+   Updated advanced example to include date comparison.+   Added set direction function+   Added a better datetimepicker jquery library to pick both date AND time.+   Page now reloads automatically as soon as a selection made in master grid by using ŅsetSelectionÓ.+   add tooltip using jQuery+   Conditional formatting now works with local array!!+   single quote in search and master detail join key value will break the grid. Fixed.+   New example - master detail layout side by side.+   Auto generate SERVER_ROOT value. When NOT using Apache alias directive or IIS virtual directory, phpGrid can successfully generate SERVER_ROOT value using the following script in conf.php. You donÕt need to do anything. However, you should set SERVER_ROOT manually when use Apache alias directive or IIS virtual directory. phpGrid 6.1A bug in client side grid object referencing was fixed by using a unique jQuery selector ID and grid object variable name to avoid a naming collision. A 4th parameter was added to the grouping method to hide the grouping column by default. The grid IIS now auto reloaded on FORM edit after submitting. file_upload JavaScript was updated to display corresponding Ajax response in the debug console. A problem where required scripts were not included in an internal function due to execution orders between master and detail grids was fixed. The debug window is now toggled off by default. Two new code samples were added. You can now integrate phpGrid, phpChart and phpAutocomplete seamlessly in your solution! The integration sample code is now available online. phpGrid & phpChart Integration http://phpgrid.com/example/phpgrid-phpchart-integration-with-live-example/ phpGrid & phpAutocomplete Integration http://phpautocomplete.com/examples/phpgrid-integration-experimental/phpGrid 6 This is a major release with many new features and enhancements. New features: composite primary key support, autocomplete control, sortable row, nested/drill-down editable subgrid, a column chooser, Excel mode, global theme and debug, two new great looking premium themes, a new row level permission function, and many bugfixes. The master detail feature has been massively enhanced. In the back-end, this release adds an SQL Server Native driver and DB2 DSN-less connectivity support.- enable_editAdded a 3rd parameter for user defined edit script file name other than the default "edit.php" file. Note that the user defined edit file is NOT automatically passed to detail and subgrid. In most cases, you do not need to use your own edit script rather than simply modify edit.php (requires Enterprise or Universal license for source code).- set_col_dynalinknow works with local array- cls_database.phpdb2-dsnlessNow supports DB2 DSN-less as database type. Thanks, Jon Paris!odbc_mssql_native"odbc_mssql_native" DB_TYPE for SQL Server Native ODBC driver"odbc_mssql" should be used for ***DSN-only connectivity *** on *nix, OS X using unixODBC through FreeTDS.unixODBC requires environment variables in conf.php  putenv("ODBCINSTINI=/usr/local/Cellar/unixodbc/2.3.1/etc/odbcinst.ini");  putenv("ODBCINI=/usr/local/Cellar/unixodbc/2.3.1/etc/odbc.ini");unixODBC is DSN connection only with the following .conf and .ini files. I used Amazon RDS MSSQL instance during testing.   /usr/local/Cellar/freetds/0.91/etc/freetds.conf   # server specific section    [global]    # TDS protocol version    ; tds version = 4.2    # Whether to write a TDSDUMP file for diagnostic purposes    # (setting this to /tmp is insecure on a multi-user system)    ; dump file = /tmp/freetds.log    ; debug flags = 0xffff    # Command and connection timeouts    ; timeout = 10    ; connect timeout = 10    # If you get out-of-memory errors, it may mean that your client    # is trying to allocate a huge buffer for a TEXT field.    # Try setting 'text size' to a more reasonable limit    text size = 64512    [phpgridmssql]    host = phpgridmssql.cbdlprkhjrmd.us-west-1.rds.amazonaws.com    port = 1433    tds version = 7.0   /usr/local/Cellar/unixodbc/2.3.1/etc/odbc.ini   [phpgridmssql]    Description = MS SQL Server    Driver = FreeTDS    Server = phpgridmssql.cbdlprkhjrmd.us-west-1.rds.amazonaws.com    TraceFile = /tmp/sql.log    UID = mssqluser    PWD = PASSWORD    ReadOnly = No    Port = 1433   Database = sampledb   /usr/local/Cellar/unixodbc/2.3.1/etc/odbcinst.ini   [FreeTDS]    Description = FreeTDS    Driver = /usr/local/Cellar/freetds/0.91/lib/libtdsodbc.so    Setup = /usr/local/Cellar/freetds/0.91/lib/libtdsodbc.so    FileUsage = 1    CPTimeout =    CPResuse =    client charset = utf-8- SQL ServerThe cells with NULL value repeat the value from the previous row has been fixed due to a bug in ADOdb (server/adodb5/adodb.inc.php), our database abstract class library.- before_script_end public variableAdded public variable 'before_script_end'. It can be 'hooked' into the display when ALL the DOM elements are ready.- priviate cust_prop_jsonstr (known as ud_params pre-version six)example: filter_grid_on_pageload.phpNote that the filters must be passed as string to data.php via POST, so not possible to use set_grid_property function which takes only array paramsExample:$dg->cust_prop_jsonstr = 'postData: {filters:                            \'{"groupOp":"AND","rules":[{"field":"status","op":"eq","data":"Shipped"}]}\'},';- set_grid_propertyParameters:$grid_property: An array represents grid property. The property will add to or overwrite existing properties already defined by phpGrid.Description:Advanced method. Set custom datagrid properties. The parameter must be an array. You must be rather familiar jqGrid API in order to take advantage of this method effectively. In most cases, you do not need to use this method. Note that this method is not the same as set_grid_method, another advanced phpGrid method.Example:$dg -> set_grid_property(array('search'=>true));- set_grid_methodIt now takes variable arguments. The changes make the function more flexible with different jqGrid methods with variable arguments. Super useful. :)- INLINE edit improvement:checkbox now display as checkbox,new blank row when add.auto refresh grid after add.WYSIWYG support- set_edit_conditionSet row-level edit condition for edition permission.Note:1. that this works for INLINE ONLY by hiding the edit icons using javascript, CSS2. For that reason, developers should still validate user permission at the database or on the server side.3. In more complicate condition, it's recommended to create your condition at run-timeParameter:     array(column => compare_operand, '&& OR ||', column2 => compare_operand, '&& OR ||'.....)Usage example:     $dg->enable_edit('INLINE', 'CRUD')->set_edit_condition(array('status'=>'!="Shipped"', '&&', 'customerNumber'=>'==129' ));Example of generated javascript conditon:     if $column = "status", $compare_operand = " == 'Shipped'", then it ouputs: if($("#orders").jqGrid("getCell", rowId, "status") == "Shipped"){Example file: custom_edit_conditon.php- Composite PK support (Enterprise+)This is a major feature in version 6. Lots of development resources devoted to support composite PK, and yet making it simple at the same time. In stead of passing a single string variable in the constructor as the primary key, you can now pass an array of strings as the composite primary key. For a single primary key, you can still use a string or an array with a single string value. e.g.http://phpgrid.com/example/composite-primary-key-support/Note that composite PK is not supported for foreign key referencial in master/detail and subgrid.- set_col_edittypeUse index number 0 and 1 instead of column name to retrieve data value in "select" edit type. This allows more complex SQL statement such as CONCAT.- Conditional formatFixed bug in subgrid due to "+" column- set_masterdetailThe 2rd parameter is finally working as intended. It no longer has to be the same name as the master primary key. It was never implemented.ƨ- New premium themes! (Enterprise+)aristocobaltretroYou gonna like it!- global theme supportTHEME global constant in conf.php to set theme for all the grids. The global theme can be overwriten with set_theme- load error displayadded primvate loadError property. The error occurred during load will be displayed.- set_sortablerowactivate sortable row. drag and drop row to sort.- toolbar searchChanged default value from "equal" to "contain"- jqGrid 4.5.2 supportUpdated with latest jqGrid library- SubgridNow support nested/drill-down subgrid!!- FORM & INLINE editrespects edit_options flags- Autocomplete support!- enable_columnchooser- enable_autoheightautomatically resize based on window width - one step closer to an Excel-like editor.- enabled_autoheightSupported!- datepickerDisplay changeMonth and changeYear dropdown- DEBUG globally constantServer error now displays when DEBUG is true in conf.php- conf.php (last one toAdd "PHPGRID" to prefix all DB constant to avoid potential name collisons with other systems and frameworks. eg. Wordpress uses DB_NAME variable.phpGrid 5.5.5This release addresses a few bugs and added a number of new features. The ODBC generic driver is now supported, as it works better in Unix environments for some databases such as MS SQL. A set_grid_method function was added. jqGrid 4.4.5, jQuery 1.9.0, and jQuery UI 1.10 are now supported. Column freeze is now supported. File upload can now be activated with a double click on a row in form edit mode. Minor bugs were fixed. phpGrid 5.5.2File uploading now works when adding new a record. Conditional format is now working with rows without a preexisting cell format. Subgrid now supports filter methods.phpGrid 5.5.1This is a patch release. It fixes an array index out of bound bug in the set edittype function. It removes control validation logic for master/detail INLINE mode since this is no longer a limitation. It removes a redundant include statement in the datagrid class that was causing unnecessary errors in some systems. phpGrid 5.51. advanced search is now supported in detail grid2. now support array parameter in set_col_dynalinks.It's also backward compatible.    $dynaParam (old $idName) can be a string or an array width dynamic value    $addParam are parameters with static value3. display_script_includeonce scope is now public (better MVC framework compability)    $dg->display_script_includeonce(true);4. better Oracle database support    define(PHPGRID_DB_TYPE, 'oci805');5. updated to latest ADOdb library 5.1.86. added toolbar search dropdown support7. phpChart integration example added!8. PDF, CSV export format are now supported by requests!9. performance optimzation with large datasets10. now supports virtual columns, AKA caclulated field!11. added support for custom validation by requests!    set_col_customrule12. array data source is now (finally) supported!    export, subgrid and master detail grids are not supported13. bug fix: Master Detail INLINE edit not working in master grid due to mulitple onSelectRow event handler.14. bug fix: $grid not defined15. bug fix: Only variable can have & since PHP516. bug fix: set_col_edittype now works with non-integer key17. bug fix: conditional format when multiple select is truephpGrid 5.00. upgrade to jqgrid 4.41. added column format type: date and checkbox    date attribute        $dg->set_col_format('orderDate', "date",             array('srcformat'=>'Y-m-d','newformat'=>'n/j/Y'));        //or        // 3rd is the datepicker dateformat. Note the format is different        $dg->set_col_date("orderDate", "Y-m-d", "n/j/Y", "m/dd/yy");    checkbox         $dg->set_col_format('isClosed', "checkbox");    // should only used for read only grid2. added sqlite driver 3. chained methods for:    setters     enablers.4. advanced methods:    set_col_property    add_event (new exmaple added)5. set_col_edit_dimension    e.g. $dg->set_col_edit_dimension("comments", 50, 10);    e.g. $dg->set_col_edit_dimension("status", 40);    example: column_text_edit_dimension.php6. file upload (beta)    edit must be enabled    FORM mode only    fiel system upload only, no BLOB    the file folder must allow write permission    One file upload supported per form    file name column should be able to allow NULL value7. WYSIWYG example added8. Search bug fix (OR operator)9. 10 new custom themes, and old theme enhancement!10. updated them roller example with dropdowns to change theme11. Now support ability to call JavaScript function from hyperlink    Added "hyperlink_click_event" example: hyperlink onclick to call javascript function 12. set_col_img    Added 2nd parameter to set base image URL. Only a single image base url is supported per grid