phpGrid – PHP Datagrid
     
     
  • Home
  • Gallery
  • Demos
    • Examples
    • Demo Explorer
    • Video Tutorials (new)
  • Documentation
  • Contact Us
  • Get phpGrid Lite (FREE!)
phpGrid – PHP Datagrid
     
  • Home
  • Gallery
  • Demos
    • Examples
    • Demo Explorer
    • Video Tutorials (new)
  • Documentation
  • Contact Us
  • Get phpGrid Lite (FREE!)

Filtered by category "Examples"

Introduction
Welcome to phpGrid! The most beloved datagrid for PHP developers. If you are new to phpGrid, we [...]
A Basic PHP Grid Example
A basic PHP grid requires only as little as TWO lines of code. First of all, always create a [...]
Descriptive Column Header
By default phpGrid pulls out the data field name defined in database as the header for each [...]
Hide Column
For columns need not to be shown, such as primary key, use method set_col_hidden() to hide [...]
Datagrid Caption
By default, phpGrid displays table name as the caption. You can change the datagrid caption [...]
Export Data to Excel, PDF, CSV, and HTML
   phpGrid currently supports export in native Excel format, CSV, PDF, and HTML [...]
Integrated Search
phpGrid includes integrated search. By default, this feature is not enabled. To enable search [...]
Set Grid Height and Width
Use set_dimension() method to specify grid initial height and width. The default height and [...]
Datagrid Pagination
By default, the pagination size is 20. It means maximum of 20 records can be displayed in a [...]
Advanced Search
phpGrid also includes advanced search. By default, this feature is not enabled. To enable [...]
Load Data with Vertical Scroll
In contrast to traditional pagination method to browse through data, you can use vertical [...]
Theme Roller *
* Please note this feature is only available in paid versions. ** Premium Themes are now [...]
Hyperlink Display
You can display the text in column as static hyperlink by calling set_col_link() and passing [...]
Display Dynamic URL
From example above, we learn that phpGrid can display simple, static URL using set_col_link() [...]
Data Format Display
phpGrid comes with several frequently used data formatter through set_col_format() method. [...]
Image Display
Display image is easy in phpGrid. Simply set the column name in set_col_img(), phpGrid will [...]
Interactive Datagrid Resizing
When enabled, the small triangle icon is displayed at the right bottom corner of the grid. The [...]
CRUD PHP Datagrid (Editable Datagrid) *
* CRUD PHP Datagrid feature is only available in paid versions.   The PHP datagrid is not [...]
Read only fields
Sometimes we don’t want certain fields to be editable, then we can use set_col_readonly() [...]
Required fields
To set fields as required in an editable grid, use set_col_required() method. If required [...]
Grid Edit Types – Select, Checkbox, Textarea, Autocomplete, WYSIWYG, etc.
After enabling edit, set types of data grid edit controls with set_col_edittype() for any [...]
Master Detail Grid *
* Please note this feature is only available in Premium and higher editions. The phpGrid went [...]
Master Detail with Column Alias
It can be tricky working with master detail grids with column name alias, especially during [...]
Subgrid *
    Defining a subgrid is essentially the same as setting up the master detail grid [...]
Multiple Editable Grids
Did you know it is possible to have multiple editable grids in a single page? No need to [...]
Column Grouping with Summary *
* Please note this feature is only available in paid versions.     phpGrid can group [...]
Master with Multiple Detail Grids *
* Please note this feature is only available in paid versions. phpGrid supports a master grid [...]
Nested Master Detail Datagrid *
* Please note this feature is only available in Premium and higher editions. The master detail [...]
Locale Setting
If you are using phpGrid in a language rather English, you may want the datagrid to display [...]
Reference to Multiple Databases *
* Please note this feature is only available in paid versions. phpGrid nows supports data [...]
Display Non-English Characters
If database is created in charset other than default charset, e.g. “latin1″, some characters [...]
In-cell Data Bar *
Bar chart is a great way to visualize numeric data. phpGrid now supports bar chart natively [...]
Conditional Value *
* Please note this feature is not available in Lite and Basic versions. Conditional Value is [...]
Create Excel-Like, Responsive Grid
Expand to Current Window Width Use enable_autowidth() and enable_autoheight() to set datagrid [...]
Horizontal Scroll
Set parameter $shrinkToFit in set_dimension() to false to enable horizontal scroll when the [...]
Conditional Format *
* Please note this feature is not available in Lite and Basic versions.     [...]
Method Chaining
Method chaining is now supported starting version 5.0. It’s not required, but it provides more [...]
Custom Event Handler
phpGrid supports custom event handlers using the add_event() method. The event handlers are [...]
Column Property
You can now directly manipulate individual column properties without using helper set_col_* [...]
Hyperlink to Call JavaScript Function
You can show hyperlink using set_col_link for static link or set_col_dynalink for dynamic link. [...]
PHP Datagrid AJAX File Upload
*The file upload is supported under the commercial license. File upload is one of the most [...]
custom form edit layout
Customize Edit Form Layout
By default, the edit form is displayed a single column table. This is fine for table with small [...]
phpgrid phpchart integration
phpGrid, phpChart Integration
  It’s easy to combine phpGrid and phpChart to create a seamless integrated, interactive, [...]
Virtual/Calculated Column
Starting version 5.5, you can now add virtual column, AKA calculated column, to your existing [...]
Custom Data Validation
phpGrid automatically does data validation based on database data type such as a string cannot [...]
Column Freeze
You can now use the set_col_frozen() method to set the column freeze method. It’s useful [...]
Column Methods
Version 5.5.5 introduced set_grid_method() method. You can use this method to call any jqGrid [...]
Inline Edit Actions Column
Inline edit mode also comes with actions column with edit and delete buttons. Use add_column [...]
Row-level Edit Permission
Using actions column in the earlier example, it’s now possible to specify row-level edit [...]
One Table, Multiple Datagrids
You can certain have more than one datagrid instances from the same database table. Just make [...]
Column Chooser & Sortable Row
The example below demonstrates column chooser and sortable row features. Click on the column [...]
Composite Primary Key Support *
* An exclusive feature for phpGrid commercial License   In the past, phpGrid supports [...]
Multiple Datagrids Side by Side
When having multiple datgagrids on a page, it’s common you need to change the default top [...]
iOS, Android Mobile Support
phpGrid works well in iOS and Android mobile devices. Visit the following demo on your mobile [...]
Nested/Cascade/Dependent Dropdown
Use “autocomplete” control and set_nested_dropdown() method, dependent dropdown, [...]
Header Grouping
Header grouping adds additional columns above the datagrid header rows, so that columns below [...]
Save Data in Virtual Column
It’s possible to save data in virtual column to database.To save data in virtual column [...]
Mobile Device Optimized
phpGrid has decent mobile device support. View the below demo on your mobile device such as iOS [...]
Math (e.g. Sum, Avg, Count) Operation
It’s possible to perform math operation on numeric columns with a little bit help from [...]
Externalize Search
  You can even externalize search fields without ever using phpGrid’s integrated or [...]
Multiple Fields Global Search *
* Please note global search feature is only available in commercial licenses.   In [...]
Work With Different Database Types
You should specific PHPGRID_DB_TYPE value in conf.php. It can be one of the following strings. [...]
Local Array Data Source *
* This feature is available with a commercial license.   phpGrid now supports local array [...]
phpgrid twitter bootstrap integration
phpGrid, Twitter Bootstrap Integration
  This is a step-by-step tutorial of how to integrate SmartAdmin, or any other Bootstrap [...]
phpgrid laravel demo
phpGrid Laravel Integration (version 1)
This is a step-by-step tutorial of how to integrate the Laravel PHP framework with phpGrid. [...]
conditional display js
Conditional Formatting with Custom Javascript
What would you do if you need more than set_conditional_format() and set_conditional_value() [...]
phpgrid laravel5 bootstrap3 full edit
phpGrid, Laravel and Bootstrap (version 2)
Introduction This tutorial will begin by walking you through the integration of the Laravel 5 [...]
phpgrid ci319
phpGrid and CodeIgniter Integration
Introduction CodeIgniter is a popular, open source PHP framework loosely based on the MVC [...]
Integrate with .CSV or Google Spreadsheets
You can use a local .csv or Google Spreadsheet as a data source to populate your datagrid. In [...]
zf2 phpgrid
phpGrid and Zend Framework Integration
Introduction IntroductionZend Framework (ZF) is a popular open source, MVC web application [...]
phpgrid db2
phpGrid Now Has Improved IBM DB2 Support!
THIS TUTORIAL IS OUTDATED. “ibm_db2” is now the recommended extension to access the [...]
pivot grid
Pivot Grid
phpGrid now supports pivot grid through a simple function “set_pivotgrid“. Simply [...]
Announcing phpGrid v6.7
Today we released phpGrid version 6.7. It updates several major core components to support PHP [...]
Working with Complex Query
Keep in mind that any direct editing is always limited to the primary table. For example, in [...]
phpgrid db2
Access DB2 through “ibm_db2” extension
* Access to DB2 through “ibm_db2” extension is only supported in the commercial [...]
Copy Row
  You can now clone a row by simply calling “enable_copyrow()” function. Once [...]
Persist State of the Sort Order and Page On Page Reload
Sometimes you need the datagrid to be able to remember sort order and current page. For that, [...]
Drag and Drop Grouping
* Please note this feature is only available in commercial licenses.   You can enable drag [...]
Tabbed Grid – Build a DataGrid With Tabs
Note that some features used in this demo are only supported in phpGrid Enterprise 6.9+.   [...]
Advanced Search with Date & Number Range Filter
Advanced search now supports range filter for both date and number. To enable search use [...]
WYSIWYG editor with font colorpicker
Font colorpicker is now built right into the phpGrid Wysiwyg editor for both inline and form [...]
phpGrid blank form only
Form-Only Edit Mode
* Please note this feature is only available in commercial licenses (7.0+) phpGrid now supports [...]
phpGrid form only load
Enhance Edit Form
There are many ways to enhance the edit form in regular datagrid + form, or just in form-only [...]
phpGrid form only load
Load Existing Record into Form (Form-Only Mode)
* Please note this feature is only available in paid versions.   You can load existing [...]
joomla3 phpgrid
Joomla! CMS Native Support
* Please note this feature is only available in paid versions (version 7.0+).   phpGrid [...]
phpGrid update confirmation message
CRUD success/error status display
Starting version 7, phpGrid now displays status of either success or error confirmation [...]
symfony logo
phpGrid Symfony Integration
Files needed for this demo phpGrid Lite (free) Symfony 3 (free)   Where to keep phpGrid [...]
db admin demo
Create a Database Management System in 15 Lines of Code
  Introduction We will learn how to build a fully functional, single-page database content [...]
start day week datepicker
Set Start Day of the Week in Datepicker
Sunday was named as the first day in Jewish and early Christian tradition. However, Sunday is [...]
datagrid rating
Rating Plugin Integration
phpGrid has built-in jQuery rating plugin support since version 7.1.5. In set_col_format(), [...]
bulk edit2
Bulk Edit, Select Multiple Rows
You can select multiple records with set_multiselect() method. When multiselect is enabled, a [...]
Drag & Drop Rows Between Grids
You can drag and drop rows between two or more grids using a mouse. In the demo, we have both [...]
input char counter
Show Remaining Characters in Textarea/Input
In a recent user support request, the user would like to see the remaining characters allowed [...]
CRM sales team view
Build a Simple CRM from Start to Finish
Customer Relationship Management (CRM) is a system that manages customer interactions and data [...]
pm employee screenshot 1
Build a Project Management Application From Scratch
What is a Project Management Application? A project management application is a software system [...]
campaigns datagrid
A Step-by-Step Guide to Building a Donation Manager from Scratch in PHP – Part I
Introduction This Donations Manager application can be used by charitable organizations to [...]
dm reports
A Step-by-Step Guide to Building a Donation Manager from Scratch in PHP – Part II
In this part of the tutorial, we will continue from where we left off in Build a Donation [...]
Creating a Custom Inventory Management Application in PHP and MySQL
Introduction You do not need bloated enterprise software to effectively track your inventory. [...]
Loading from Large Database Table with 3 Million Records!
The total record count is usually one of the most expensive database operations due to [...]
tagging w autocomplete
Tagging with autocomplete
To enable tagging, you can set the type of grid edit control to autocomplete with [...]
Get My Awesome Grid!
Examples: Getting Started
  • Introduction
  • A Basic PHP Grid Example
  • Work With Different Database Types
  • Local Array Data Source *
  • Data Source: Stored Procedure with IN Paramters
  • JSON Data Source
Examples: Datagrid Properties
  • Datagrid Caption
  • Datagrid Pagination
  • Interactive Datagrid Resizing
Examples: Data Grid Editing
  • Bulk Edit, Select Multiple Rows
  • CELL edit with Add, Delete and Export buttons
  • Composite Primary Key Support *
  • Copy Row
  • CRUD PHP Datagrid (Editable Datagrid) *
  • Customize Edit Form Layout
  • Drag & Drop Rows Between Grids
  • enable_dnd_grouping()
  • Enhance Edit Form
  • Excel Editing
  • Grid Edit Types - Select, Checkbox, Textarea, Autocomplete, WYSIWYG, etc.
  • Inline Edit Actions Column
  • Multiple Editable Grids
  • Nested/Cascade/Dependent Dropdown
  • Row-level Edit Permission
  • Show Remaining Characters in Textarea/Input
  • Tagging with autocomplete
  • Working with Complex Query
  • WYSIWYG editor with font colorpicker
Examples: Set Column Properties
  • Descriptive Column Header
  • Hide Column
  • Set Grid Height and Width
  • Hyperlink Display
  • Display Dynamic URL
  • Data Format Display
  • Image Display
  • Read only fields
  • Required fields
  • Hyperlink to Call JavaScript Function
  • Column Freeze
  • Display Hyperlink From Another Field of The Same Row
  • How to display data from other columns?
Examples: Master Detail
  • Master Detail Grid *
  • Master Detail with Column Alias
  • Subgrid *
  • Master with Multiple Detail Grids *
  • Nested Master Detail Datagrid *
  • Change Master Detail Grids Layout Using CSS
Examples: Search & Export
  • Export Data to Excel, PDF, CSV, and HTML
  • Integrated Search
  • Advanced Search
  • Externalize Search
  • Multiple Fields Global Search *
  • Advanced Search with Date & Number Range Filter
Examples: UI, Data & Grouping
  • Load Data with Vertical Scroll
  • Theme Roller *
  • Column Grouping with Summary *
  • Create Excel-Like, Responsive Grid
  • Horizontal Scroll
  • Column Methods
  • One Table, Multiple Datagrids
  • Column Chooser & Sortable Row
  • Header Grouping
  • Mobile Device Optimized
  • Math (e.g. Sum, Avg, Count) Operation
  • Drag and Drop Grouping
  • Tabbed Grid - Build a DataGrid With Tabs
  • Loading from Large Database Table with 3 Million Records!
Examples: Conditional Output
  • Conditional Value *
  • Conditional Format *
  • Conditional Formatting with Custom Javascript
Examples: Advanced Methods
  • Custom Event Handler
  • Column Property
  • Virtual/Calculated Column
  • Custom Data Validation
  • Column Methods
  • Save Data in Virtual Column
  • Simple Shopping Cart Using the Action Column
Integrated Ajax File Upload
  • PHP Datagrid AJAX File Upload
Examples: Framework Integration
  • phpGrid, Twitter Bootstrap Integration
  • phpGrid Laravel Integration (version 1)
  • phpGrid, Laravel and Bootstrap (version 2)
  • phpGrid and CodeIgniter Integration
  • Integrate with .CSV or Google Spreadsheets
  • phpGrid and Zend Framework Integration
  • phpGrid Now Has Improved IBM DB2 Support!
  • Access DB2 through "ibm_db2" extension
  • Bootstrap Grid Layout
Examples: Date Formatting
  • Complete Date Format Demo (Updated)
  • set_col_datetime()
  • Timepicker Only Support
  • Set Start Day of the Week in Datepicker
Examples: Pivot Grid, Misc.
  • CRUD success/error status display
  • Pivot Grid
  • Display Non-English Characters
  • Locale Setting
Examples: Persist State
  • Bulk Edit, Select Multiple Rows
  • Persist State of the Sort Order and Page On Page Reload
Examples: Form Only
  • Form-Only Edit Mode
  • Enhance Edit Form
  • Load Existing Record into Form (Form-Only Mode)
  • 1
  • 2
  • Next

phpGrid is a product of Kayson Group Inc. Kayson Group creates powerful and easy-to-use PHP components for IT professionals since 2004.

 

Download phpGrid
Recent Posts
  • System Requirements

    System Requirements

  • Technical Overview

    Technical Overview

  • A Basic PHP Grid Example

    A Basic PHP Grid Example

  • Installation

    Installation

Contact

Kayson Group Inc.
324 10TH ST STE 203
OAKLAND CA 94607,
USA

 

Hong Kong: 852-30184061
North America: (877)GRID-666

Products People ♥

  • Home
  • Download
  • Blog
  • Examples & Tutorials
  • Documentation
  • OEM
  • T&C
  • Privacy
  • EULA
  • Version History
© 2008-2021 Kayson Group Inc. All rights reserved.

We are using cookies to give you the best experience on our website.

You can find out more about which cookies we are using or switch them off in settings.

phpGrid - PHP Datagrid
Powered by  GDPR Cookie Compliance
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.