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.
Following is the guide to integrate PHP Grid Framework with Laravel 5.5 (LTS)
Step1: Folder placements in Laravel.
There are 2 main folders in PHP Grid Framework package archive. You need to:
Copy the contents of lib/inc folder —> Laravel/app/Classes/phpgrid
Copy the contents of lib/js folder —> Laravel/js/phpgrid
The ‘app/Classes’ folder does not exist by default in laravel. You may create it for 3rd party class libraries.
Create another folder inside it with name ‘phpgrid’ and move all contents of ‘lib/inc’ in it. Final result will look like this:
In similar way, copy the files from lib/js to laravel/public/js/phpgrid. Final result should look like following:
Step2: Setting Controller code.
Here we included our library and rest code looks same as in our demos. Note the ” before class name while instantiating object. Finally we passed the output of render() function to view with a variable name ‘phpgrid_output’.
For demo purpose, we modified ‘laravel/app/Http/Controllers/WelcomeController.php’
Step2: Setting View code.
In view code, we included the JS/CSS files from the ‘js’ folder which we copied in step1.1
We also included a meta tag for ‘csrf-token‘, that is required by laravel for POST operations.
And using blade template variable output, we pushed the grid output in our desired place in html.
We also added a javascript code to pass CSRF-TOKEN in header request of ajax calls.
For demo purpose, we slightly modified ‘laravel/resources/views/welcome.blade.php’
Step3: Setting Routes
The Last step in this tutorial is to set the routes to our controller. We will use both GET and POST routes as our grid uses both methods.
Note: PHP Grid Framework does not utilize ORM model layer of Laravel. It uses it’s own backend libraries.
We’ve added support for visual representation of data using Sparklines in PHP Grid Framework. Sparklines charts can be used to show trends in a series of values, such as seasonal increases or decreases, website traffic, economic cycles, or to highlight maximum and minimum values.
Now you can have Line, Bar, Composite (Both line/bar), Pie, Discrete, Bullet, Won-Lost, Color Map and Box Sparklines along with your other information. Few of them are shown in demo screenshot:
Licensed customers can request free upgrade using update link.
To purchase license, you can visit this link.
PHP Grid Framework is ready to use with Bootstrap4. Roll-out your next web-application with combining power of responsive PHP Grid and Bootstrap4 UI design.
Licensed customers can request free upgrade using update link.
To purchase license, you can visit this link.
We’ve released ‘Import Data’ feature that will help customers who need to migrate from Microsoft Excel or Google Sheets or CSV File to their own web based solution using PHP Grid Framework.
– Import your external CSV file data in PHP Grid Framework.
– Migrating from Excel or Google Sheets to PHP Grid Framework.
– Selection to map imported data columns on database fields.
– Allow to Append OR Replace existing PHP Grid data.
Screencast below:
For How-tos, usage and technical details, refer updated documentation.
Existing customers can request update from this link.
To purchase license, you can visit this link.
After a long delay, we have enhanced responsive feature of PHP Grid, which support some really useful intrinsic features:
– Your custom column display selection based on screen size
– Auto-hiding of columns (from end) based on screen size
– Column display choice on runtime
– Better mobile transposed display of View, Add and Edit dialog forms
Screencast #1
Screencast #2
For How-tos, usage and technical details, refer updated documentation.
Active license customers can request free upgrade using this link.
Following is the guide to integrate PHP Grid Framework with Laravel 5.
Step1: Folder placements in Laravel.
There are 2 main folders in PHP Grid Framework package archive. You need to:
Copy the contents of lib/inc folder —> Laravel/app/Classes/phpgrid
Copy the contents of lib/js folder —> Laravel/js/phpgrid
The ‘app/Classes’ folder does not exist by default in laravel. You may create it for 3rd party class libraries.
Create another folder inside it with name ‘phpgrid’ and move all contents of ‘lib/inc’ in it. Final result will look like this:
In similar way, copy the files from lib/js to laravel/public/js/phpgrid. Final result should look like following:
Step2: Setting Controller code.
Here we included our library and rest code looks same as in our demos. Note the ‘\’ before class name while instantiating object. Finally we passed the output of render() function to view with a variable name ‘phpgrid_output’.
For demo purpose, we modified ‘laravel/app/Http/Controllers/WelcomeController.php’
Step2: Setting View code.
In view code, we included the JS/CSS files from the ‘js’ folder which we copied in step1.1
And using blade template variable output, we pushed the grid output in our desired place in html.
For demo purpose, we modified ‘laravel/resources/views/welcome.blade.php’
Note: PHP Grid Framework does not utilize ORM model layer of Laravel. It uses it’s own backend libraries.
We have recently added support for date-range picker control. Now you can filter date ranges (date-from and date-to) using quick search auto-filter. You can also filter with defined presets like last month, last week etc. See screencast for demo.
Active license customers can request free upgrade using this link.
Sometime we need custom Add or Edit forms for data entry purpose. With this feature it’s now doable to connect your HTML Forms with PHP Grid and it will use PHP Grid API for add/edit operations. See Screencast for more.
Active license customers can request free upgrade using this link.