Grid 4 PHP Framework is ready to use with Bootstrap5. Roll-out your next web-application with combining power of responsive PHP Data Grid and Bootstrap5 UI design.
Licensed customers can request free upgrade using update link.
To purchase license, you can visit this link.
Welcome to the August 2021 release (version 2.8). There are many updates in this version that we hope you will like. It contains PHP 8 compatibility, UI Design Optimizations, Performance Optimizations, Security updates and Bug fixes. It also contains some new demos for better usability of data grid in your application. Highlights mentioned below.
Data Grid in Accordion Control
Now you can have multiple data grids inside accordion control. It’s best suited for multiple step process and to organize multiple modules on a single page.
Custom HTML Listing Layout
This feature allow you to display each record with customized layout with html code and fields placeholders.
Improved Database Table Editor
This tool enables you to quickly perform DML operations on a database defined in the code configuration.
RSS Reader using DataGrid
This demo loads the RSS feed into an array to be used as a data-source of data grid.
Data Import Progress Bar
Progress bar was a demanding feature when we importing large dataset.
Open Street Maps Integration
Like Google maps, you can also use Open Street maps and use the parameters of lat/lng from database using field placeholders.
Improved Tree Grid
This also contains over 70 reported bug fixes and updates.
Integration with Code Igniter 4.0 and Laravel 8.0 is also in testing phase and will be released soon as a separate update.
Active License Subscription customers can get free upgrade using this link.
PHP 8 has been released some time ago and had some breaking changes. We’ve been hard at work behind the scenes to provide support for all our libraries so that upgrading to PHP 8 with Grid 4 PHP Framework is easy.
The licensed version update is available now and free version packaging is in progress which will be published soon.
Active License Subscription customers can get update using this link.
As popularity of WordPress is growing really fast, we’ve published a new simplified tutorial on how to integrate Grid 4 PHP 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:
Updated 20-Oct-2020: New revised tutorial support data-grid custom event handlers as well.
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/
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 & admin_footer hook along with others.
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.
Hello,
Now you can a new option in lookup dropdown without going on other screen (via lookup datagrid and popup). See screencast below.
The working demo can be checked online and full version package in demos/appearance/dropdown.
Live: https://www.gridphp.com/demo/demos/appearance/dropdown.php
Next Actions:
Active License Subscription customers can get free upgrade using this link.
Hello All,
For small screen/mobile devices, we have further optimized responsive data-grid view.
You can also have customized way to show row data in single column on small screens. You can change it’s layout with HTML/CSS code and use placeholders e.g. {unit_price} to show field names content where you want to display.
If any column is hidden by responsive behavior (screen size detection) of data-grid OR manually set to be hidden on certain screen size, then a last column with ellipsis “…” will be displayed to show hidden details.
Active License Subscription customers can get free upgrade using this link.
PS: Special thanks to our customer Robert Childers for suggestions & feedback.
Hello Everyone!
This is Abu from PHP Grid Framework. An important update for all customers / developers, With a new season we’re re-branding our product. Now it will be called ‘Grid 4 PHP Framework‘ with a new logo designed as well. Our new logo will be used now in support forum and payment pages.
Our domain name will also be updated from
www.phpgrid.org … to … www.gridphp.com.
These changes will be in transition and old systems will keep working till complete shift.
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.
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);
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.
To do exact search in global search, you can enclose your query text in double quotes “…”.
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.
For working demo, refer demos/search/search-template.php in your downloaded package or online demos.
Refer these links for more details:
With each column, you can now set custom tooltip / help text. E.g.
$col["tooltip"] = "Custom Tooltip for Company Name";
In dialogs of Add or Edit, you can add column headers in multi-column layout mode.
On mobile devices, it will show toolbar options on multiple lines when increased.
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.
– 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.
Active License Subscription customers can get free upgrade using this link.
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. No need to buy Pro Version.
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
For Joomla 4, Paste the code below immediately before this line:
// Run the application – All executable code should be triggered through this file
require_once dirname (__ FILE__). ‘/includes/app.php’;
and For Joomla 3 or before, Paste the code before this line:
$app->execute();
This is the code to paste in index.php:
// Joomla will read the REQUEST array and the router gets confused when data grid posts data
// the data is still in the POST array so removing it this does no harm to Grid PHP
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.
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.
Desktop view:
Mobile View:
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.
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;
Removed action icons for xs devices and added fullscreen support that gives native app experience.
– 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.
Active License Subscription customers can get free upgrade using this link.