PHP CRUD

0

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 CRUD datagrid website.

UPDATE (2nd May, 2013): New Feature Updates
New features include Autocomplete option for fast data lookup, Column based formatting, Clone Records, Twitter Bootstrap Integration, Grouping Headers and File Upload Option. Visit official  website for more www.gridphp.com.

UPDATE (4th Feb, 2013): Released version v1.4.8 (for premium customers)
New featured examples include HTML / WYSIWYG editor integration, FancyBox integration, Loading Grid from phpArray, Conditional formatting, Conditional Data display, Controlling multiple detail grids from master, Server side validation, Custom client side validation, MySQLi support added. Visit official  website for more www.gridphp.com.

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

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

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

Powered by Azgtech

Leave a comment