September 2019 Release (version 2.6.3)

Welcome to the release of this month. In this release which we have made several new updates and fixes on last version. Highlights mentioned below. It also contains important security updates.

Highlights:

Multiple Columns Sorting

In case of multi sort when first time clicked the sort is asc (or descending) the next click sort to
opposite direction the third click of the column remove the sorting from that column. Your first column must have
similar records to see the change of second level sorting and onwards.

It is disabled by default, you can enable it by:

$opt["multiSort"] = true;
// ...
$g->set_options($opt);

HTML Export

With this export option, you can use your data-grid data to be used in various other apps like Google Sheets, G-Docs, MS Word etc.
To enable it, refer export section in documentation.

Exact Match in Global Search

To do exact search in global search, you can enclose your query text in double quotes “…”.

Demo App: Simple RSS Reader

Added a basic RSS reader application which fetches RSS feed provided by user and show in data grid.

Refer demos/apps/rss-reader.php for working demo and code.

Filtered Results notification

For working demo, refer demos/search/search-template.php in your downloaded package or online demos.

Added How-To Guides to integrate in WordPress & Joomla

Refer these links for more details:

Custom Tooltip & Help hints for Columns:

With each column, you can now set custom tooltip / help text. E.g.

$col["tooltip"] = "Custom Tooltip for Company Name";

Vertical Column Headers Layout:

In dialogs of Add or Edit, you can add column headers in multi-column layout mode.

Optimized mobile menu layout

On mobile devices, it will show toolbar options on multiple lines when increased.

Debugging SQL Queries:

By enabling `debug_sql` or `debug_search` configuration, you will see SQL queries being sent to database in error message box.

In order to debug SQL queries, set:

$g->debug_sql = 1;

In order to debug Search queries, set:

$g->debug_search = 1;

You can also close error box by clicking ‘x’ and continue next debug step.

Notable Fixes & Updates:

– Additional security checks added for add/edit/delete operations.
– Fix for treegrid display in new version
– Excel mode checkbox, drodown ui fixed
– Skip global search in persistence filter search
– Override column chooser display on responsive autohide column
– Replaced rawgit -> jsdelivr links from demos
– Custom separator/delim for get_dropdown_values function
– Fixed import function in subgrid
– Mobile fix for top menu overlap
– Fixed file upload in direct add form
– Column header tooltip enabled for all
– Make responsive inner subgrid
– isnull (null) columns support added in import
– Auto scroll to top on next page
– Updated tooltip multilingual for row actions
– other 25 minor updates.

Next Actions:

Active License Subscription customers can get free upgrade using this link.

 

 

Using PHP Grid Framework in Joomla

We’ve published a new tutorial on how to integrate PHP Grid Framework with Joomla 3.9.8. It allows using all features of our Data Grid inside Joomla and with much simpler implementations. Steps required to integrate are following:

Step1: Download Free version or Buy package from  our website (if not already done) and move “lib” folder from package in your Joomla root directory, and rename “lib” folder as “phpgrid”.

Step2: Create a new file ‘demo.php‘ inside ‘phpgrid’ folder and copy paste joomla code snippet from here.

Step3: Install Joomla extension “Sourcerer (free version) By RegularLabs” from Here OR download from our Github Repository.

Step4: Now after installing this extension, edit the article where you want to display grid and include the demo.php file using sourcerer php syntax:

{source}
<?php require_once JPATH_ROOT.'/phpgrid/demo.php'; ?>
{/source}

Step5: A modifications which will allow PHP Grid to perform ADD and EDIT operations inside of Joomla. Edit Joomla ‘index.php‘ file in root folder and paste following code immediateley before the line: $app->execute();
which is just before the end of the file.

// Joomla will read the REQUEST array and the router gets confused when phpgrid posts data
// the data is still in the POST array so removing it this does no harm to PHPGrid
if (isset($_POST['id'])){
unset($_REQUEST['id']);
}

Result: Now Save the article and open it in browser, you will get the demo datagrid.

Next Actions: You can create more grid php files (like in step2) by copying code from package demos and include them using sourcerer syntax (step4) on your desired article of Joomla.

Let us know your feedback. If you have any questions, contact our support center.

Active License Subscription customers can get free upgrade using this link.

PS: Special thanks to Doug Lawson for his contribution in this tutorial.

Using PHP Grid Framework in WordPress

As popularity of WordPress is growing really fast, we’ve published a new simplified tutorial on how to integrate PHP Grid Framework with WordPress Sites. It allows using all features of our Data Grid inside WordPress and much simpler than previous implementations. Steps required to integrate are following:

Step1: Download Free version or Buy package from  our website (if not already done) and move “lib” folder from package in your WordPress root directory, and rename “lib” folder as “phpgrid”

and inside this folder the contents should be:

Step2: Install wordpress plugin “Code Snippets By Shea Bunge” from //wordpress.org/plugins/code-snippets/ OR download from Github Repository and install manually.

Step3: Goto admin panel and click Add Snippet as in image. Add any title you like and in code section, copy paste this Sample Snippet Grid Code in code section shown below:

Step4: In this code, we have created a shortcode here with name: [phpgrid-users] so we will now place it on page where we want to show our Datagrid.

Result: Now Save the page and open / preview it, you will get the datagrid.


Adding Grid in WordPress Admin Area
:

Following steps will be required to make shortcode available in admin area – plugin development.

Step1: Add admin_init hook along with template_redirect.

Step2: Select ‘Run Snippet everywhere’ after snippet code block.

Step3: Call do_shortcode() function where you want to show datagrid.

Result:

Next Actions: You can create more snippets a (step3) by copying code from package demos and assign new unique shortcode for each grid which can be placed on your page/post of WordPress.

Let us know your feedback. If you have any questions, contact our support center.

Active License Subscription customers can get free upgrade using this link.

Nov 2018 Release (version 2.6.2)

Welcome to the release of this month. This is a post release update of major build v2.6. In this release which we have made several updates and fixes on last version. Highlights mentioned below.

Highlights:

Demo App: Basic Todo List

Desktop view:

Mobile View:

Columns hide/show with URL parameter

Now you can hide or show certain column based on url parameter (?list1_showcols=id,invdate,note&list1_hidecols=total)

We already have URL based filtering support as explained in this link.

Numeric range autofilter ( >10 <20 )

Autocomplete force selection (combo-box)

If you want to use autocomplete but do not allow new entries and force selection from list (combobox style), then you can set:

$col[“formatoptions”][“force_select”] = true;

Optimized mobile layout

Removed action icons for xs devices and added fullscreen support that gives native app experience.

Notable Fixes & Updates:

– Moved default edit all rows button to toolbar
– Hotkeys added for first grid. a,e,d. (disabled by default, set $opt[“hotkeys”] = true)
– Removed export from readonly
– Performance issues fixed by disabling tooltip from ellipses (slow rendering for large dataset)
– Css fix mobile spacing button & pager bar auto height
– Removed binary data from database.sql & db script constraints
– Removed sortby check to allow complex sort in $opt[“sortname”], sqlsvr fix
– Reformat date after cancel
– Firefox dependent dropdown update
– Fix error msg spacing, promo fix, dialog mobile position fix
– New line fix for sql server limit query regex
– Fix multiselect css
– Fix multicolumn search when searchtype=global
– Optimized url based filters
– BOM character fix for all files

We’re working on couple of demo apps and most wanted pivot table feature which we plan to release in next build.

Next Actions:

Active License Subscription customers can get free upgrade using this link.

 

 

Demo Application: Todo List

To show some basic features of php grid framework, we created a very simple demo of “todo list” and following features are used:

  • Bootstrap 4 + Mobile sidebar filter menu
  • Conditional Formatting
  • Custom delete event callback for soft delete
  • External Search form (date range, text, priority filters)
  • Checkbox with default edit mode
  • Export to Excel

Desktop screen:

Mobile screen:

Next actions:

Basic Authentication for PHP Grid

On some cases, we just want to password protect our page without including the hassle of heavy frameworks (like Laravel, Yii, Symfony etc) and databases. This solution works without any database and have credentials hard-coded in authentication file. You can add or modify accounts by changing php array values. Refer comments inside file for configuration options.

Download basic authentication include file here.
(save it as auth.php)

Step 1) Include “auth.php” file on page which need to be password protected. Include before any output / echo and at start of code. Adjust include path accordingly where you place the file.

Step 2) Configure user/pass by editing auth.php – e.g. ‘username’ => ‘password’. You can also set after logout url. e.g. your login page url.

Result: Now when you access protected page, you will get following login screen. Entering user/password will allow you the access.

To Logout, access same grid page with logout=1 query-string param. e.g. //example.com/grid.php?logout=1
Feel free to change the appearance by modifying css files and hacking html code.

Download basic authentication include file here.
(save it as auth.php)

New Documentation Site

Another update for all, we just launched our new documentation section to improve usability and better understanding of our product (PHP Grid Framework). The new documentation site is categorized in content sections on left with a search box on top right. There is also a live chat / email message box on bottom right. To go to parent website use main site link on top.

The most impressive feature is ‘quick search’ which is super fast (powered by lunr-js) and fetch results from every section of documentation in no time.

Share you feedback and improvement suggestions as well.
Happy coding.

Announcing PHP Grid Framework v2.6

Welcome to the release of PHP Grid Framework v2.6. There are a number of significant updates in this version that we hope you will like, some of the key highlights mentioned below.

Highlights:

Overall User Interface Enhancement, Font-awesome Icons, Shaded border, Tooltips

Optimized for mobile devices

Automatic hiding of columns on small device breakpoints

Enhanced Excel Style navigation, just like Google Sheets & MS Excel with no saving delay.

Added Tooltips where required. Added ellipses (…) for long content.

Lookup search, Numeric Range search, Global search

Lookup edit type

and it will result following searchable lookup dropdown.

Exporting single row (e.g. Sales receipts)

Predefined Search Templates

URL based grid filtering (filters permalink)

Directly Open Add Form, instead of grid

Read-only preset of grid (e.g. Reports) + Dark-One theme

Optimized Database drivers supported
db

And finally, great experience on modern browsers.
Browsers

 

Notable Fixes & Updates:

  • Selecting specific field to map on imported CSV file
  • Updated Excel export library included
  • Updated PDF export library included
  • Updated Database Abstraction library included
  • Important Security Fixes (XSS, SQL injection)
  • Added set_titles function to override titles
  • Added rowheight property to increase row space
  • Security: File upload File Extension Filtering
  • Excel mode: On enter move down or next
  • Replaced CKeditor with Trumbowyg editor due to licensing limits
  • Auto remove uploaded image on close and cancel dialog
  • Excel view: Textarea shift enter for new line
  • Around 200 fixes and updates.

Last but certainly not least, a big Thank You! to our customers who helped to make our product even better.

Next Actions:

Active License Subscription customers can get free upgrade using this link.

 

 

Global Search feature

Hello,

We recently added global search feature in PHP Grid Framework that allows to search your term in all searchable fields of grid. It will save time and quickly filter your data.

Since v2.5+, you can enable this feature by setting:

$g = new jqgrid();
...
$opt["globalsearch"] = true;
...
$g->set_options($opt);

Active license customers can request upgrade using this link.
To purchase license, you can visit this link.

Happy Coding …

TreeGrid – Hierarchical Data Display

Hello,

We’ve updated a demo that support displaying parent-child relational data in form of tree grid. It is done by simple configuration on PHP Grid Framework where you define the parent and child fields of same table. For example in following example, EmployeeId is ID field and ReportsTo is Parent Relation field that makes this tree grid. This framework already support variety of database connections e.g. SQL Server, Oracle, DB2, Postgres, Mysql etc so you can have this Tree-grid in all supported databases.

Database Table:

Tree Grid Sample:

Next Actions:

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