{"id":102675,"date":"2014-11-26T11:08:18","date_gmt":"2014-11-26T09:08:18","guid":{"rendered":"http:\/\/guriddo.net\/?page_id=102675"},"modified":"2014-12-07T14:06:16","modified_gmt":"2014-12-07T12:06:16","slug":"guriddo-php","status":"publish","type":"page","link":"http:\/\/guriddo.net\/?page_id=102675","title":{"rendered":"Guriddo jqGrid PHP"},"content":{"rendered":"<style type=\"text\/css\">\n.accordions dd p {\n    float: none;\n    width: auto;\n}\n<\/style>\n<h2 style=\"margin-bottom:30px\">Guriddo jqGrid PHP<\/h2>\n<p style=\"margin-bottom:25px;\">\nGuriddo jqGrid for PHP is a server-side component built on top of open and widely used standards such as jQuery, jQuery UI, ThemeRoller. It uses Guriddo jqGrid JS. This product is created for PHP developers and teams that radically decreases development time with Guriddo jqGrid JS and makes it fun and easy. All functionality Guriddo jqGrid JS has is supported in PHP \u2013 no need for tricky javascript \u2013 everything is handled in PHP.\n<\/p>\n<table style=\"width: 100%;\" border=\"0\">\n<tbody>\n<tr>\n<td width=\"25%\">\n<\/td>\n<td width=\"25%\">\n<a class=\"btn_l\" href=\"http:\/\/guriddo.net\/?page_id=103292\">Download<\/a><\/td>\n<td align=\"left\" width=\"25%\"><a class=\"btn_l\" href=\"http:\/\/guriddo.net\/?page_id=103495\">License\/Pricing<\/a><\/td>\n<td width=\"25%\">\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<dl class=\"accordions\"><br \/>\n<dt><h4>PHP ONLY FEATURES<\/h4><\/dt><dd><\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:left;margin-right: 2em;\"  href=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/12\/php-logo.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/12\/php-logo-300x157.jpg\" alt=\"php-logo\" width=\"180\" height=\"95\" class=\"alignnone size-medium wp-image-103045\" srcset=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/12\/php-logo-300x157.jpg 300w, http:\/\/guriddo.net\/wp-content\/uploads\/2014\/12\/php-logo.jpg 310w\" sizes=\"(max-width: 180px) 100vw, 180px\" \/><\/a><\/p>\n<p>PURE PHP<\/h4>\n<p><!-- Free --><br \/>\nGuriddo  jqGrid PHP is written in pure PHP. This means that the class can be integrated in any PHP framework including Zend, Cake PHP, Doctrine PHP  and much more.\n<\/p>\n<h4 style=\"margin-bottom:10px;clear:both; padding-top:1em;\" class=\"bord\">\n<a style=\"float:right;margin-left: 2em;\" class=\"lbp_primary\"  href=\"http:\/\/guriddo.net\/?page_id=102675\" title=\"Click to see details\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"180\" src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/phpgrid.png\" alt=\"Free\" \/><\/a><br \/>\nAUTOMATIC OPERATIONS<\/h4>\n<p>\nThe PHP component automatically handles data retrieval, paging, sorting, searching and all CRUD operations (create, read, update, delete). No need for custom code \u2013 you can have a fully functional grid with just a few lines of PHP<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:left;margin-right: 2em;\"  class=\"lbp_primary\"  href=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/database.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/database-300x130.jpg\" alt=\"database\" width=\"280\" height=\"120\" class=\"alignnone size-medium wp-image-103069\" \/><\/a><br \/>\nMULTIPLE DATABASE SUPPORT<\/h4>\n<p>\nUp to the moment Guriddo jqGrid  PHP Supports the following Databases: AdoDB wrapper, Array data, IBM DB2, MongoDB, Microsoft SQL Serrver, MySQLi, ODBC, Oracle,  PDO (with MySQL, PostgreSQL, SQLite, SQL Server)\n<\/p>\n<h4 style=\"margin-bottom:10px;clear:both; padding-top:1em;\" class=\"bord\">\n<a style=\"float:right;margin-left: 2em;\" class=\"lbp_primary\"  href=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/export.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/export-300x133.jpg\" alt=\"export\" width=\"300\" height=\"133\" class=\"alignnone size-medium wp-image-103072\" srcset=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/export-300x133.jpg 300w, http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/export.jpg 337w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nEXPORT TO MULTIPLE SOURCES<\/h4>\n<p>\nWe support exporting the result to : Excel, PDF and CSV. The component also export the filtered and the whole data set. The export have a lot of useful configuration  options.\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:left;margin-right: 2em;\" class=\"lbp_primary\"  href=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/search_toolbar_controls.png\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/search_toolbar_controls-300x145.png\" alt=\"search_toolbar_controls\" width=\"300\" height=\"145\" class=\"alignnone size-medium wp-image-103075\" srcset=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/search_toolbar_controls-300x145.png 300w, http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/search_toolbar_controls.png 651w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nBONUS COMPONENTS<\/h4>\n<p>\nIn the package we include two additional components at no cost. These are the Autocomplete and Datepicker. Both can be added and  integrated into Guriddo jqGrid PHP with only one line of code.  These two components can be used separately &#8211; i.e you can integrate it in any form.\n<\/p>\n<h4 style=\"margin-bottom:10px;clear:both; padding-top:1em;\" class=\"bord\">\n<a style=\"float:right;margin-left: 2em;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/addons.png\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/addons-300x159.png\" alt=\"addons\" width=\"300\" height=\"159\" class=\"alignnone size-medium wp-image-103078\" srcset=\"http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/addons-300x159.png 300w, http:\/\/guriddo.net\/wp-content\/uploads\/2014\/11\/addons.png 601w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nBONUS MODULES<\/h4>\n<p>\nAgain with the bonus components Autocomplete and Datepicker we provide a additionally two bonus modules &#8211; Guriddo TreeGrid PHP and Guriddo PivotGrid PHP. Both components handle automatically all server side operations and it is very easy to work with. Please visit the product pages and demo&#8217;s in order to get idea how is easy to work with it.\n<\/p>\n<p><\/dd><br \/>\n<dt><h4>Features supported from Guriddo jqGrid JS (Click)<\/h4><\/dt><dd><\/p>\n<h4 style=\"margin-bottom:10px;clear:both; padding-top:1em;\" class=\"bord\">\n<a style=\"float:left;margin-right: 2em;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/multibrwoser.jpg\" title=\"Multibrowser\" ><br \/>\n<img decoding=\"async\" loading=\"lazy\" width=\"160\" height=\"140\" class=\"lbp_primary\" src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/multibrwoser.jpg\" alt=\"Multibrowser\" \/><\/a><\/p>\n<p>MULTIPLATFORM<\/h4>\n<p><!-- Multiplatform --><br \/>\nBrowser support is an important part of our grid. Guriddo jqGrid support all modern mobile and desktop browsers including the iPhone\/iPad and Internet Explorer from version 8.  Browser support reference is tested regularly with all major browsers. <\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:right;margin-left: 2em;margin-top:25px !important;padding-top:20px !important;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/formatter.png\" title=\"Formatting\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/formatter.png\" alt=\"Formatting\" \/><\/a><br \/>\nFORMATTERS<\/h4>\n<p><!-- Formatters --><br \/>\nFormatter supports advanced formatting of the contents of cells.Formatter has predefined types like : integer, number, date, currency, links, check boxes and etc. The developer can define you own custom formatter.  Multilingual configuration allow us to make it flexible and used in any country\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:left;margin-right: 2em;margin-top:25px !important;padding-top:20px !important;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/inlineedit.png\" title=\"Inline editing\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/inlineedit.png\" alt=\"Inline editing\" \/><\/a><br \/>\nINLINE EDITING<\/h4>\n<p><!-- Cell edit  --><br \/>\nIn place editing allow you in easy way to update the cell content in particular row. We supporting  text, text area, check box, select, image, button types. We support definition of custom edit type and events which allow a great flexibility. With a build in  client side validation of the entered data we can filter the user input\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:right;margin-left: 2em;margin-top:25px !important;padding-top:20px;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/celledit.png\" title=\"Cell Edit\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/celledit.png\" alt=\"Cell edit\" \/><\/a><br \/>\nCELL EDITING<\/h4>\n<p><!-- Cell edit--><br \/>\nCell editing supports editing individual cells. We supporting of text, text area, check box, select, image, button types . Client side validation of the entered data make it easy to filter user input. Another great feature is    keyboard navigation with tab, shift tab, left, right, up and down keys, which allow quick user input. The great number of events allow the developer to control everything in this process\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:left;margin-right: 2em;margin-top:25px !important;padding-top:20px !important;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/formedit.png\" title=\"Form editing\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/formedit.png\" alt=\"Form editing\" \/><\/a><br \/>\nFORM EDITING<\/h4>\n<p><!-- Cell edit  --><br \/>\nGuriddo JS supports creating a form, on the fly, to enter or edit grid data. We supporting of text, text area, check box, select, image, button types, client side validation of the entered data, keyboard navigation up and down keys,<br \/>\nflexible events, full control of the form from creation to closing\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:right;margin-left: 2em;margin-top:25px !important;padding-top:20px;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/searching.png\" title=\"Searching\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/searching.png\" alt=\"Searching\" \/><\/a><br \/>\nSEARCHING AND FILTERING<\/h4>\n<p><!-- Searching --><br \/>\nThe columns in the grid can be used as the basis for a search form to appear above, below, or in place of, the grid. We support single field searching, toolbar searching (placing the search fields below the headers), complex form searching and advanced searching with criteria defined from user. We can define a predefined search templates to make the search easy.\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:left;margin-right: 2em;margin-top:25px !important;padding-top:20px !important;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/grouping.png\" title=\"Grouping\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/grouping.png\" alt=\"Grouping\" \/><\/a><br \/>\nGROUPING<\/h4>\n<p><!-- Cell edit  --><br \/>\nGrouping is a way to group data by different criteria. Guriddo jqGrid currently supports a unlimited levels of grouping and  different  type of calculations to the group value applied to column. Currently we support the following build in functions: sum, count, avg, min, max. Also a custom summary type is supported. With grouping you can easy create a representative report.\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:right;margin-left: 2em;margin-top:25px !important;padding-top:20px;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/groupheader.png\" title=\"Group headers\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/groupheader.png\" alt=\"Group header\" \/><\/a><br \/>\nGROUP COLUMN HEADERS<\/h4>\n<p>\nHeader grouping is a way to add additional columns above the header grid rows, so that they are grouped in a way you need them. We support this feature in unique manner using two types of grouping &#8211; with colSpan enabled and colSpan disabled. If the colSpan is disabled (the default) the headers that do not have grouping have a additional cell above it. If the colSpan is enabled there is no additional cell above the non-grouped column and it is considered as one column.\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:left;margin-right: 2em;margin-top:25px !important;padding-top:20px !important;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/frozen.png\" title=\"Frozen columns\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/frozen.png\" alt=\"Frozen Columns\" \/><\/a><br \/>\nFROZEN COLUMNS<\/h4>\n<p>\nIt is quit easy for developers to make some columns frozen\/locked within Guriddo jqGrid. The locked columns do not scroll out of view when users moving horizontally across the grid. This is quite useful when you dealing with wide table with some fields should be visible permanently. It is needed to set this property in the model and call only one command.\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:right;margin-left: 2em;margin-top:25px !important;padding-top:20px;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/virtual.png\" title=\"Virtual scroll\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/virtual.png\" alt=\"Virtual scrolling\" \/><\/a><br \/>\nVIRTUAL SCROLLING<\/h4>\n<p>\nThis is a special paging mode of Guriddo jqGrid where standard paging is disabled and you can request new pages by scrolling the scrollbar to the bottom. This is very convenient for getting large amounts of data page by page while keeping the interface simple.\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:left;margin-right: 2em;margin-top:25px !important;padding-top:20px !important;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/columnchooser.png\" title=\"jQuery UI Integrations\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/columnchooser.png\" alt=\"jQuery UI Integrations\" \/><\/a><br \/>\njQUERY UI INTEGRATIONS<\/h4>\n<p>\nSince Guriddo jqGrid is a jQuery plugin it is very natural that in some cases we should not reinvent the wheel. That is the reason that we have made a decision to do some things in Guriddo jqGrid using the jQuery UI lib. Currently we have the following additions: <strong>Sortable columns<\/strong> &#8211; the method allow to reorder the grid columns using the mouse; <strong>Column Chooser<\/strong> &#8211; With this method we can reorder columns and set visible and hidden columns in the grid in visual manner; <strong>Sortable Rows<\/strong> &#8211; This method allows reordering (sorting) grid rows in a visual manner using a mouse; <strong>Resizable Grid<\/strong> &#8211; This method allow to re size the grid width and\/or height in visual manner using a mouse.\n<\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\">\n<a style=\"float:right;margin-left: 2em;margin-top:25px !important;padding-top:20px;\" class=\"lbp_primary\" href=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/subgrid.png\" title=\"Subgrid, master detail\" > <img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"150\"  src=\"http:\/\/guriddo.net\/wp-content\/themes\/construct\/images\/features\/subgrid.png\" alt=\"Subgrid, master detail\" \/><\/a><br \/>\nSUBGRIDS AND MASTER DETAIL<\/h4>\n<p>\nYou can show any level of nested subgrids (master detail) inside a parent grid. It is needed to  set the subGridRowExpanded function to construct another Child grid.\n<\/p>\n<p><\/p>\n<h4 style=\"margin-bottom:14px;clear:both; padding-top:1.5em;\" class=\"bord\"> SOME OTHER FEATURES&#8230;<\/h4>\n<div class=\"bullets_lists c_after\">\n<ul class=\"arrows_list\">\n<li> TreeGrid &#8211; a unlimited level of hierarchy. See more details here<\/li>\n<li> PivotGrid &#8211; view data in diffrent perspective. See more here. <\/li>\n<li>CSS based themes. Guriddo jqGrid is compatible with UI Theming. Developers can change the grid skin by defining their own using the UI CSS Framework.<\/li>\n<li>Speed. The new rendering engine improves the loading speed in some cases up to 5-10 time faster than previous releases.<\/li>\n<li>Paging. This feature enables developer to display data page by page. Data will not be retrieved from the server until the end user comes to that page. Developers can control how many rows are displayed at a time.<\/li>\n<li>Resizable Columns. Column width can be changed by the end user.<\/li>\n<li>Sorting &#038; various data types. The end user can sort records by clicking on the header of a column. Developers can specify sorting for various types including string, number, boolean, link, select and percent.<\/li>\n<li>Multiple Sorting. We can sort a grid by more than a single field.<\/li>\n<li>Event handlers &#038; user API. Event handlers and various methods give you more flexibility without coding too much.<\/li>\n<li>Working with local data. Guriddo jqGrid can work with local data defined as an array.<\/li>\n<li>Seamless integration with any server side solution such as ASP, .net, PHP and perl.<\/li>\n<li> Multilanguage support (i18n). Currently Guriddo jqGrid supports more than 40 languages.<\/li>\n<li>Support for XML, JSON and arrays as data sources. Another great feature is the possibility to define your own custom data type.<\/li>\n<\/ul>\n<\/div>\n<p><\/dd><\/p>\n<p><\/dl>\n","protected":false},"excerpt":{"rendered":"<p>Guriddo jqGrid PHP Guriddo jqGrid for PHP is a server-side component built on top of open and widely used standards such as jQuery, jQuery UI, ThemeRoller. It uses Guriddo jqGrid JS. This product is created for PHP developers and teams [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":102663,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"blank.php","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"_links":{"self":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102675"}],"collection":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=102675"}],"version-history":[{"count":37,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102675\/revisions"}],"predecessor-version":[{"id":103497,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102675\/revisions\/103497"}],"up":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102663"}],"wp:attachment":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=102675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}