PHP-JQuery Datagrid Component

IMPORTANT UPDATES:

UPDATE (19th Oct 2018): Released 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
• And finally, great experience on modern 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.

Get it from main PHP Grid website.

UPDATE (17th July, 2016): New Feature Updates

• Custom Forms with PHP Grid July 12, 2016 – 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.
• PHP Database Table Editor v2.0 May 19, 2016 – n 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.
• Announcing PHP Grid v2.0 March 21, 2016 – 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.
• Multiple Files Uploading February 13, 2016 – Now PHP Grid support multiple file upload option. You can multi-select the files as in screenshot and upload to server.

Visit official  website for more www.gridphp.com.

See Video of New feature & Interface!

…

jqGrid is an Ajax-enabled JavaScript control that provides solutions for representing and manipulating tabular data on the web. Since the grid is a client-side solution loading data dynamically through Ajax callbacks, it can be integrated with any server-side technology, including PHP.

Here i’ve made a self-written PHP Ajax Data Grid component using JQGrid (based on JQuery). This library can generate fully featured CRUD application in record time.

include("jqgrid.php");

$g = new jqgrid();
$grid["caption"] = "My Sample Grid"; // set grid customizable params
$g->set_options($grid);
$g->table = "tags"; // db table for CRUD operations.

// You can also specify SQL query for displaying data (download code with examples)
// $g->select_command = "select f1,f2,f3 from tags";

$out = $g->render("my_grid_1"); // render grid

... and in HTML after including JS files ...

This code will result in fully functional Jquery Grid (JqGrid) with …

• Add
• Edit
• Delete
• Search
• Auto-filter
• Sort
• Pagination
• Export
• Multilevel Subgrid option (n-level)
• Events for Add/Update/Delete Custom implementation
• Multiple Themes (ThemeRoller)
• and almost all features available for FREE … which cost $299 on official commercial license.
• No time limitation

* Bold features are added in update of 5th October.

This component is highly customizable using option parameters, which can be added as needed.

UPDATE: 5th October, 2010

Following features are now incorporated in free version …

1. Sub-Grid/ Master Detail support

And it is available with all main operations … like search/add/edit/delete/sort/paging etc. You can have multi-level subgrids.

JQGrid Subgrid & Master Detail Example

2. Custom Events Support

Now you can write you own custom implementations on UPDATE / INSERT / DELETE.

E.g. code …

// params are array(<function-name>,<class-object> or <null-if-global-func>,<continue-default-operation>)

$e[“on_insert”] = array(“add_client”, null, false);

$e[“on_update”] = array(“update_client”, null, true);

$e[“on_delete”] = array(“delete_client”, null, true);

$grid->set_events($e);

UPDATE: 2nd November, 2010

Several fixes are incorporated in latest version. Please get your latest copy.

* Support for formatters e.g.

$col[“formatter”] = “date”; // format as date

$col[“formatoptions”] = array(“srcformat”=>’Y-m-d’,”newformat”=>’d/m/Y’); // format as date

* Cell editing navigation support,  like excel

* Table alias fields are fixed

* Enabled support for GROUP BY custom query

* Export excel fix for ? based url

Free version has no time limitation, but source code is encrypted or encoded.

Need Customization or Technical Support?

– You can get complete source code and subscription for priority support and updates from this link

Download free version with usage example

UPDATE (15th Jan, 2013): New featured examples include Custom toolbar button, Export to CSV, Date Time picker control, Open grid in edit mode by default, Added more themes (24 total), Add Data Grouping example + updated documentation. Visit official  website for more www.gridphp.com.

Product now got a new home ‘www.gridphp.com‘ with a new version 1.4.6. Refer this site for all future updates.