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.

 

 

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.

 

 

PHP Database Table Editor v2.0

On various occasions, we want instant access to see or edit our database tables without having time to write a whole module with add, edit, delete, list, search (CRUD) operations. Whether your database is SQL Server, Oracle, DB2, MySQL or PGSQL — PHP Grid provides you easy solution that takes database credentials in config and provide table access in form of lightweight and rich featured PHP Grid. It will provide you complete functions within your existing application admin interface.

This lightweight, yet power-featured PHP Grid Database Editor is developed by very simple code OR we can say by just configuration. In main code logic, we simply passed the dropdown value of selected table in $g->table attribute, and that’s all!

$g = new jqgrid();
// set few params
$grid["caption"] = "Grid for '$tab'";
$grid["autowidth"] = true;
$g->set_options($grid);
// set database table for CRUD operations
$g->table = $tab;
// render grid
$out = $g->render("list1");

You can extend this code to incorporate Access Control (ACL), Exporting Data (PDF, CSV, XLS) and several other features to make a powerful tool. We omitted them to show the code simplicity. This demo is based on MySQL, but you can have same function for MS SQL Server, Oracle, PgSQL databases.

Features in v1.2:

  • Selection of tables and fields for editing
  • Show/Hide particular fields in runtime
  • Bulk Editing data with multiselection
  • Grid Persistance (Column Resizing, Filters, Sort etc)

PHP Grid comes with free version and a licensed version. With Free version you can connect with others databases like MySQL, MS SQL Server, Oracle, PgSQL,DB2. Licensed version also supports many advance features which you can integrate in your application.

Complete code for this demo can be accessed from this link.

You can download and start saving your time now!

Releases:

v2.0 – May 19 2016
v1.2 – Apr 25 2015
v1.0 – Apr 8 2014

Announcing PHP Grid v2.0

Today, we are glad to announce the release of PHP Grid v2.0.
Adding a lot of features, updates, optimizations and fixes. Thanks for all who contributed in evaluation.

Major Highlights:

  • Overall User Interface Enhancement, New Glyph Icons, Cozy Spacing Layout enabling it to be used on mobile devices easily.  Bootstrap3 is also supported now. This version comes with 3 layouts, i.e. Cozy, Bootstrap and Classic (old slick version).
    basic
  • New Professional Themes (Dark, Light, Colored). Metro Color Themes light/dark/black are recently added. You can also rollover your custom color theme using jQueryUI.
    themes
  • Integration with jQuery Plugins. Now you can connect plugins like datetime, autocomplete, select2, fancybox, ckeditor, jscolor and many others with simple process, enabling endless possibilities in features.
    3rdparty
  • Added support for many missing database engines
    db
  • And finally, all such features gave same experience on modern browsers.
    Browsers

Technical Change-log:

  • Added support for PHP v5.0+ to v7.0
  • PDO and MySqli Drivers support
  • New Glyphicon (Iconset) / Bootstrap3 support
  • Muliple File Uploading Support
  • Support for SQLite and Firebird databases
  • Advanced Search Conditions (Search in Groups)
  • Exporting selected rows and columns
  • Session data based grid (with add/edit/del)
  • Exporting Master Detail PDF
  • Image auto-embed support in PDF export
  • Select2 plugin support for data entry and search form
  • Over 200+ fixes and updates.

Next Actions:

Active license customers can request free upgrade using this link.

Get a complete Features Tour by vising our website.

 

 

Logo, Faqs & Theme Redesigned!

Hello Everyone!

This is Abu from PHP Grid. As written in post title, we have rolled out several changes through out the website. Just wanted to give some quick updates:

  • Logo is redesigned. Our new flat logo will now be used in support forum and checkout page.

  • New responsive theme is rolled out for website.

new-home-pic

  • Howtos & Faqs page is redesigned for fast lookup of your query. We’ve tons of faqs so make sure you review them before waiting for answer. Support forum search is also there for help.

What’s coming next … we’re working hard in rolling out new version of PHP Grid (v1.6) with lots of updates and new features, so stay tuned.

Documentation is Updated!

I recently updated online documentation page to make it developer friendly, fast and each to navigate. The previous version was very unorganized, and honestly speaking, i usually didn’t use it for my development (instead i preferred Ctrl+F in markdown file — docs.txt).

Now, in updated version on right side, there is a list of complete table of contents for easy access. It also contains a new ‘Using’ section that dictates the steps required to implement certain feature.

The new section of documentation is kept simple with focus on:

1) Steps to Use
2) Code Snippet / Picture
3) Full Code / Live demo

The future updates are also planned to be in same format, and i believe it’s just what a developer like in documentation. Copy > Paste > F5!

Visit documentation page.

docs-v2

Support Center Launched

We recently launched a new brand service center for community issues. All previous channels are closed now. We’ll try to migrate useful thread from our last discussion forum. Just in case some one need an urgent resolution, he can post thread from support center link

Also there is a FAQ article posted along articles section. More helping articles like tutorials, general integrations in frameworks are inshaAllah likely to be posted there in near future.

Just in case, you need premium support and more quick response, try connection with gtalk on [email protected] for live chat.