Filtered by tag "demo"

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 mode

* Please note this feature is only available in Enterprise versions (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 [...]

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 an Enterprise license. phpGrid now supports local array [...]

Work With Different Databases

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 Enterprise and Enterprise Plus License In the past, [...]

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 Enterprise and Enterprise Plus license. File upload is [...]

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 Datagrids

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 php data [...]

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 Data Grid Height and Width

Use set_dimension() method to specify data grid initial height and width. The default height [...]

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 Datagrid Example

A basic PHP datagrid requires only as little as TWO lines of code. First of all, always create [...]

Introduction

Welcome to phpGrid! The most beloved datagrid for PHP developers. If you are new to phpGrid, we [...]