Free – JQGrid PHP Control

Download :: Screenshots :: Changelog :: Support :: Comments

php-ajax-datagrid-jqgrid

Download Latest Release

with usage example

For Live Support, Add in Gtalk

gridphp@gmail.com

For Community Support

Visit Support Forum

Generate JQGrid based PHP Ajax Datagrid with just configuration (No complex Javascript). Enabling Add, Edit, Del, Search, Sort, Page, Themes etc. Fed up by repetitive operations every time? Significantly reduce time and cost by using this jqgrid php component. Ideal for prototyping Admin interfaces and quick setup tables. PHP Datagrid Control is customizable using parameters & custom events. Supports major databases including Mysql, PGsql, SQL Server, Oracle … etc.

UPDATE (26th Mar, 2015):

A lot of exciting new features are added in this product. The magic is it’s all transparent using PHP Class. You can need to switch on/off the feature with no backend complex jqgrid/php coding.

Search with Multiple Group Conditions

This enables the more advanced search dialog allowing to add any number of complex group conditions. The user can now add or delete an unlimited number of conditions to perform the search as shown in screenshot.

search-group

Visit www.phpgrid.org/updates and subscribe to RSS / G+ or Twitter feed.

UPDATE (19th Nov, 2014):
We have rolled out several features that we wish our visitors to be aware of.

1) Multiselect Filter:
Added a new filter option, that let you filter columns having a dropdown with checkboxes to select multiple items. It also support textbox to quickly search your desired item within filter options. This is similar to excel like auto filtering.
Live Demo: http://www.phpgrid.org/demo/demos/integrations/multiselect-filter.php

2) Select2 Integration:
Now you can use ‘Select2‘ control with PHP Grid’s Add or Update operations. Select2 is a jQuery based replacement for select boxes. It supports searching, with in your large select box data items. It gives behavior similar to ‘Combo-box’ control of Microsoft development tools.

3) New Additions to Form Layout Design:
We have made several additions in our customized dialog layout feature.
1) You can have 2, 4, 6 column layout in your Add or Edit dialog forms of PHP Grid.
2) You can also Add sections (sub-titles) within form to separate input data group.
3) A field can span to several columns where required. (e.g. Id)
4) Custom form buttons are also supported. (e.g. Load Default)

Visit official  website for more www.phpgrid.org/ -> Updates

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.phpgrid.org.

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.phpgrid.org.

Italia: Genera pienamente funzionale griglia PHP in soli 7 linee di codice. Aggiungi abilitanti, Modifica, Del, Ricerca, Ordina, Page, temi ecc PHP Ajax DataGrid di controllo si basa sulla jqGrid.

This piece of code will result in fully functional JQuery Ajax-ified PHP Datagrid with:

  • Adding record
  • Editing record
  • Delete record
  • Auto-filter Search
  • Sorting the Data
  • Pagination (customizable)
  • Grouping Display By Column (with aggregate summary)
  • Date-picker Integration
  • Custom Display Formatter (dropdown/checkbox/image/password/link etc)
  • Multilingual Support (Italian, French, German, Arabic, Chinese etc)
  • RTL Support and UTF8 Support
  • Customizable Themes (using ThemeRoller)
  • No time limit in Free version
  • — Premium Features —
  • Integration with all Major Databases (mysql,pgsql,mssql … and odbc support)
  • Master-Detail Subgrid (multi-level hierarchy) *
  • Custom Events for own Add/Update/Delete implementations *
  • Inline Row Addition
  • Export to Excel *
  • Export to PDF (with Custom PDF formats) *
  • Source Code (neat clean with comments) *
  • Technical Support in Integration *
  • Free Upgrades (on request)*
  • Advance Search *
  • Excel like Navigation *
  • Unlimited Developers Usage License
  • Unlimited Production Website License
  • Unlimited Themes Support (Theme roller)

Here is the PHP Code …

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 ...

<div><?php echo $out?></div>

Need Customization or Full Source Code?

– Full source code is flexible and new custom features can be added easily

– Full source code can be given after payment of $50 of appreciation

– Technical Support for component integration (on need basis)

– Free Upgrades & Bug fixes (on request)

– If interested Contact Me

Free version has no time limitation, but source code is encrypted and some marked (*) features are not allowed.

Download Latest Release

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.phpgrid.org.

UPDATE (11th Nov, 2012): New featured examples include Multiple grids, Master-detail non hierarchical grid, Custom validation, Bar graph with updated documentation. Visit official  website for more www.phpgrid.org.

UPDATE (31st July, 2012): New featured examples include Postgresql integration samples, Conditional Display of Buttons / Data in Rows. Product now got a new home www.phpgrid.org with a new version 1.4.6. Refer this site for all future updates.

Technical support in paid package for Intergation with CakePHP, CodeIgnitor, Zend Framework & WordPress. CakePHP & Jqgrid integration is now easier than never before using our PHP Grid library. No need to go in complex JQgrid Javascripts. Just utilize this component and release quickly.

Roadmap:

– Bulk Updates

– Custom JS validation

– Excel view like google-docs (auto refresh, row/cell lock)

UPDATE: Version 1.4.5 is available  (February 12, 2012) – for paid members

– support for all major databases (mysql,pgsql,mssql,sybase … and odbc support) (db-layer.php)

– inline row addition (excel_view.php)

– pdf export custom template sample (export-pdf.php)

– export to pdf/excel in same grid

– fix for non integer primary key

– fix for mysql keyword based column name

– Fix for non-integer PK column

– multiselect fix in lib jqgrid 4.3.1

UPDATE: 21st December, 2011

Version 1.4 is available

Features:

– Datepicker integration

– Group by field

– Runtime change “group by” field

– Password mask formatter / edittype

– Excel export support for numeric columns

UPDATE: 21st July, 2011

Version 1.3 is available

Features:

– PDF export feature (export-pdf.php)

– Multiple fonts in pdf export

– External link with grid data (external-link.php)

– Export filtered/all data option

– Export specific columns (export-pdf.php, $col[“export”] = false;)

Fixes:

– persist where filter in export option

– Jquery fix for IE

– utf8 encoding fix

– json fix for php 5.1

– slashes fix

UPDATE: 31st December, 2010

1. Version 1.2 is available

– Several bug fixes (with thanks to all reporters)

– Support for Subqueries

– Must review README.txt when migration from previous implementations

– Get latest version from above link

2. Image Formatter

Introduced image formatter to display image in grid, if URL is fetched from DB.

$col[“formatter”] = “image”; // format as image — if data is image url e.g. http://<domain>/test.jpg

$col[“formatoptions”] = array(“width”=>’20’,”height”=>’30’); // image width / height etc

3. Excel like Navigation

– Navigate through arrow keys

– Enter to Edit / Save

– Include Intrinsic Operations

—-

UPDATE: 2nd November, 2010

Several fixes and 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

—-

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
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);

—-

Technical FAQs / issues available here

  • Custom Display Formatter (dropdown/checkbox/image/password etc)
  • RTL Support and UTF8 Support

Genera pienamente funzionale griglia PHP in soli 7 linee di codice. Aggiungi abilitanti, Modifica, Del, Ricerca, Ordina, Page, temi ecc PHP Ajax DataGrid di controllo si basa sulla jqGrid.

UPDATE (6th June, 2012): Product now got a new home ‘www.phpgrid.org‘ with a new version 1.4.6. Refer this site for all future updates.

207 Responses to “Free – JQGrid PHP Control”

  1. Ashwin Says:

    Hello,I want to Add a custom button to header of jggrid

  2. Fred Says:

    Hello, i’m using phpgrid 1.4.6 with php PHP Version 5.4.4 but i get blank result.

    i’m using the demo, so for sure the database isn’t empty.

    It works great with php 5.3.x

  3. marcobuttignon Says:

    Hi I have a problem passing a variabile in $select_command
    $g->select_command = “select * from corsi_users_single where segreteria=1 and ID_utente=”.$_POST[‘user’];
    doesn’t work, but
    $g->select_command = “select * from corsi_users_single where segreteria=1 and ID_utente=1″;
    works.

    $_POST[‘user’] is a parameter from a form.
    How can i resolv it?

    Thanks

  4. marcobuttignon Says:

    Hi, very complimets for your work.
    I have a problem: i get some parameters by $_POST for compose my query.
    Here the code

    if(isset($_POST[‘user1′]) || isset($_POST[‘year1′])){
    if($_POST[‘user1′] -1 && $_POST[‘user1′] == -1){
    $user=$_POST[‘user1′];
    $g->select_command = “select * from corsi_users_single where segreteria=1 and ID_utente={$user}”;
    }
    elseif($_POST[‘year1′] -1 && $_POST[‘user1′] -1){
    $year=$_POST[‘year1′];
    $user=$_POST[‘user1′];
    $g->select_command = “select * from corsi_users_single where segreteria=1 and ID_utente={$user} and data_inizio LIKE ‘%”.$year.”%’ “;
    }elseif($_POST[‘year1′] == -1 || $_POST[‘user1′] == -1){
    $g->select_command = “select * from corsi_users_single where segreteria=1 and data_inizio LIKE ‘%”.$year.”%’ “;
    }
    }else{
    $g->select_command = “select * from corsi_users_single where segreteria=1″;
    }

    If there’re no parameters, the query is $g->select_command = “select * from corsi_users_single where segreteria=1″;
    But when there’re one or two parameters, I get only the result as the last query, even if there’re no parameters.
    Is a problem by mi code or a jqgrip problem?

    Thanks

  5. Essam Says:

    Hi,
    I use free version when i open example it gives me only the columns headers with no data.

  6. Andrés Zuleta Says:

    Hi azghanvi, i would like to know if there’s a way to encrypt the password when it is been editted?. How could i save it in md5 ?
    Thanks in advance.

    • azghanvi Says:

      By encryption, do you mean ****** or md5 related thing.
      for masking, just change $col[“edittype”] = “password”;
      for md5, you need to write custom update/insert code, which is a part of paid package. For details contact gridphp@gmail.com

    • azghanvi Says:

      It is available in latest build.
      $col[“edittype”] = “password”;

  7. kidsofts Says:

    I am trying to use as i stated below but the grid fill the old value how can i use from a form value with out sorting
    if(isset($_post[‘txtClintId’]))
    {
    $g->select_command = “SELECT * FROM (SELECT i.id, invdate , c.name,
    i.note, i.total FROM invheader i WHERE i.client_id”.$_post[‘txtClintId’].”) o”;
    }
    else
    {
    $g->select_command = “SELECT * FROM (SELECT i.id, invdate , c.name,
    i.note, i.total FROM invheader i) o”;
    }

    • kidsofts Says:

      in other word

      if(isset($_post[‘txtClintId’]))
      {
      $query = “SELECT * FROM (SELECT i.id, invdate , c.name,
      i.note, i.total FROM invheader i WHERE i.client_id = ”.$_post[‘txtClintId’].”) o”;
      }
      else
      {
      $query = “SELECT * FROM (SELECT i.id, invdate , c.name,
      i.note, i.total FROM invheader i) o”;
      }

      $g->select_command = $query;

    • azghanvi Says:

      You need to use session variable here.
      Refer faqs: how to post data from other page.

  8. Nitin Says:

    Thanks for wonderful Grid …
    I downloaded v 1.4 after completing installation Grid loaded with Columns but empty rows can you please help what I am missing…
    Thanks again.


Share your thoughts & feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 31 other followers

%d bloggers like this: