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

Filtered by tag "demo"

CELL edit with Add, Delete and Export buttons
phpGrid has a less known edit feature called “CELL”. It’s similar to INLINE [...]
bootstrap grid layout
Bootstrap Grid Layout
The datagrid can also be displayed and positioned easily in a Bootstrap Grid System layout, [...]
master-detail-layout-css
Change Master Detail Grids Layout Using CSS
The default master detail grid has the top down layout. The master, the parent datagrid is [...]
Simple Shopping Cart Using the Action Column
In the action column, it is possible to add additional links or buttons beside the CRUD buttons [...]
Complete Date Format Demo (Updated)
The example demonstrates date column formatting using functions set_col_date, set_col_datetime, [...]
Timepicker Only Support
phpGrid now has standalone time-picker support using set_col_time() method. Only the table [...]
Display Hyperlink From Another Field of The Same Row
This demo is based on Hyperlink to Call JavaScript Function. It triggers a JavaScript event [...]
Excel Editing
Set the edit type to CELL enables datagrid to behave like an Excel spreadsheet. It is advisable [...]
Tagging with autocomplete
To enable tagging, you can set the type of grid edit control to autocomplete with [...]
Loading from Large Database Table with 3 Million Records!
The total record count is usually one of the most expensive database operations due to [...]
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 [...]
Bulk Edit, Select Multiple Rows
You can select multiple records with set_multiselect() method. When multiselect is enabled, a [...]
Rating Plugin Integration
phpGrid has built-in jQuery rating plugin support since version 7.1.5. In set_col_format(), [...]
Set Start Day of the Week in Datepicker
Sunday was named as the first day in Jewish and early Christian tradition. However, Sunday is [...]
Form-Only Edit Mode
* Please note this feature is only available in commercial licenses (7.0+) phpGrid now supports [...]
Enhance Edit Form
There are many ways to enhance the edit form in regular datagrid + form, or just in form-only [...]
Load Existing Record into Form (Form-Only Mode)
* Please note this feature is only available in paid versions.   You can load existing [...]
Advanced Search with Date & Number Range Filter
Advanced search now supports range filter for both date and number. To enable search use [...]
Working with Complex Query
Keep in mind that any direct editing is always limited to the primary table. For example, in [...]
Pivot Grid
phpGrid now supports pivot grid through a simple function “set_pivotgrid“. Simply [...]
set_col_headerTooltip()
Parameter(s): $col_name: Column name. $tooltip: Tooltip text. Description: Set column tooltip [...]
phpGrid Laravel Integration
This is a step-by-step tutorial of how to integrate the Laravel PHP framework with phpGrid. [...]
Local Array Data Source *
* This feature is available with a commercial license.   phpGrid now supports local array [...]
Work With Different Database Types
You should specific PHPGRID_DB_TYPE value in conf.php. It can be one of the following strings. [...]
Save Data in Virtual Column
It’s possible to save data in virtual column to database.To save data in virtual column [...]
Header Grouping
Header grouping adds additional columns above the datagrid header rows, so that columns below [...]
Nested/Cascade/Dependent Dropdown
Use “autocomplete” control and set_nested_dropdown() method, dependent dropdown, [...]
iOS, Android Mobile Support
phpGrid works well in iOS and Android mobile devices. Visit the following demo on your mobile [...]
Multiple Datagrids Side by Side
When having multiple datgagrids on a page, it’s common you need to change the default top [...]
Composite Primary Key Support *
* An exclusive feature for phpGrid commercial License   In the past, phpGrid supports [...]
Column Chooser & Sortable Row
The example below demonstrates column chooser and sortable row features. Click on the column [...]
One Table, Multiple Datagrids
You can certain have more than one datagrid instances from the same database table. Just make [...]
Row-level Edit Permission
Using actions column in the earlier example, it’s now possible to specify row-level edit [...]
Inline Edit Actions Column
Inline edit mode also comes with actions column with edit and delete buttons. Use add_column [...]
Column Methods
Version 5.5.5 introduced set_grid_method() method. You can use this method to call any jqGrid [...]
Column Freeze
You can now use the set_col_frozen() method to set the column freeze method. It’s useful [...]
Custom Data Validation
phpGrid automatically does data validation based on database data type such as a string cannot [...]
Virtual/Calculated Column
Starting version 5.5, you can now add virtual column, AKA calculated column, to your existing [...]
custom form edit layout php datagrid
Customize Edit Form Layout
By default, the edit form is displayed a single column table. This is fine for table with small [...]
PHP Datagrid AJAX File Upload
*The file upload is supported under the commercial license. File upload is one of the most [...]
Hyperlink to Call JavaScript Function
You can show hyperlink using set_col_link for static link or set_col_dynalink for dynamic link. [...]
Column Property
You can now directly manipulate individual column properties without using helper set_col_* [...]
Custom Event Handler
phpGrid supports custom event handlers using the add_event() method. The event handlers are [...]
Method Chaining
Method chaining is now supported starting version 5.0. It’s not required, but it provides more [...]
Conditional Format *
* Please note this feature is not available in Lite and Basic versions.     [...]
Horizontal Scroll
Set parameter $shrinkToFit in set_dimension() to false to enable horizontal scroll when the [...]
Create Excel-Like, Responsive Grid
Expand to Current Window Width Use enable_autowidth() and enable_autoheight() to set datagrid [...]
Conditional Value *
* Please note this feature is not available in Lite and Basic versions. Conditional Value is [...]
In-cell Data Bar *
Bar chart is a great way to visualize numeric data. phpGrid now supports bar chart natively [...]
Display Non-English Characters
If database is created in charset other than default charset, e.g. “latin1″, some characters [...]
Reference to Multiple Databases *
* Please note this feature is only available in paid versions. phpGrid nows supports data [...]
Locale Setting
If you are using phpGrid in a language rather English, you may want the datagrid to display [...]
Nested Master Detail Datagrid *
* Please note this feature is only available in paid versions. The master detail datagrid can [...]
Master with Multiple Detail Grids *
* Please note this feature is only available in paid versions. phpGrid supports a master grid [...]
Column Grouping with Summary *
* Please note this feature is only available in paid versions.     phpGrid can group [...]
Multiple Editable Grids
Did you know it is possible to have multiple editable grids in a single page? No need to [...]
Subgrid *
    Defining a subgrid is essentially the same as setting up the master detail grid [...]
Master Detail with Column Alias
It can be tricky working with master detail grids with column name alias, especially during [...]
Master Detail Grid *
* Please note this feature is only available in paid versions. The phpGrid went extra miles to [...]
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 [...]
Required fields
To set fields as required in an editable grid, use set_col_required() method. If required [...]
Read only fields
Sometimes we don’t want certain fields to be editable, then we can use set_col_readonly() [...]
CRUD PHP Datagrid (Editable Datagrid) *
* CRUD PHP Datagrid feature is only available in paid versions.   The PHP datagrid is not [...]
Interactive Datagrid Resizing
When enabled, the small triangle icon is displayed at the right bottom corner of the grid. The [...]
Image Display
Display image is easy in phpGrid. Simply set the column name in set_col_img(), phpGrid will [...]
Data Format Display
phpGrid comes with several frequently used data formatter through set_col_format() method. [...]
Display Dynamic URL
From example above, we learn that phpGrid can display simple, static URL using set_col_link() [...]
Hyperlink Display
You can display the text in column as static hyperlink by calling set_col_link() and passing [...]
Theme Roller *
* Please note this feature is only available in paid versions. ** Premium Themes are now [...]
Load Data with Vertical Scroll
In contrast to traditional pagination method to browse through data, you can use vertical [...]
Advanced Search
phpGrid also includes advanced search. By default, this feature is not enabled. To enable [...]
Datagrid Pagination
By default, the pagination size is 20. It means maximum of 20 records can be displayed in a [...]
Set Grid Height and Width
Use set_dimension() method to specify grid initial height and width. The default height and [...]
Integrated Search
phpGrid includes integrated search. By default, this feature is not enabled. To enable search [...]
Export Data to Excel, PDF, CSV, and HTML
   phpGrid currently supports export in native Excel format, CSV, PDF, and HTML [...]
Datagrid Caption
By default, phpGrid displays table name as the caption. You can change the datagrid caption [...]
Hide Column
For columns need not to be shown, such as primary key, use method set_col_hidden() to hide [...]
Descriptive Column Header
By default phpGrid pulls out the data field name defined in database as the header for each [...]
A Basic PHP Grid Example
A basic PHP grid requires only as little as TWO lines of code. First of all, always create a [...]
Introduction
Welcome to phpGrid! The most beloved datagrid for PHP developers. If you are new to phpGrid, we [...]
Get My Awesome Grid!
Examples: Getting Started
  • Introduction
  • A Basic PHP Grid Example
  • Work With Different Database Types
  • Local Array 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 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
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
  • phpGrid, Laravel 5 and Bootstrap 3 - Part I
  • phpGrid and CodeIgniter Integration
  • Integrate with .CSV or Google Spreadsheets
  • phpGrid and Zend Framework Integration
  • phpGrid Now Has Improved IBM DB2 Support!
  • phpGrid, Laravel 5 Integration - Part II (Improved version)
  • 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
  • Load Existing Record into Form (Form-Only Mode)
  • Form-Only Edit Mode
  • Enhance Edit Form

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
  • Announcing phpGrid version 7.4.6!

    Announcing phpGrid version 7.4.6!

  • phpGrid 7.4.5

    phpGrid 7.4.5

  • phpGrid 7.4.1

    phpGrid 7.4.1

  • phpGrid 7.4

    phpGrid 7.4

  • enable_dnd_grouping()

    enable_dnd_grouping()

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
  • Examples & Tutorials
  • Documentation
  • OEM
  • T&C
  • Privacy
  • EULA
  • Version History
© 2008-2021 Kayson Group Inc. All rights reserved.