PHP Generator Feature Demo
  • Themes
    • Default
    • Default compact
    • Cerulean
    • Cerulean compact
    • Cosmo
    • Cyborg
    • Darkly
    • Darkly compact
    • Facebook
    • Flatly
    • Journal
    • Lumen
    • Paper
    • Readable
    • Sandstone
    • Simplex
    • Slate
    • Slate compact
    • Spacelab
    • Superhero
    • Superhero compact
    • United
    • United compact
    • Yeti
    • Yeti compact
  • English
    • German
    • Brazilian
    • Czech
    • Danish
    • Spanish
    • Finnish
    • French
    • Hungarian
    • Italian
    • Dutch
    • Polish
    • Russian
    • Swedish
    • Slovak
    • Slovenian
    • Serbian
    • Turkish
    • Arabic
  • Learn more
    • PHP Generator Feature Demo
    • About this demo
    • Download project file for this demo
    • Check out other PHP Generator demos
    • NBA Database Demo
    • Security Demo
    • MySQL Schema Browser Demo
    • Learn more about our products
    • Try PHP Generator for free
    • SQL Maestro Group website
    • Follow us
    • Facebook
    • Twitter
    • YouTube
  • Recently added/updated
    • Grid Toolbar
    • Tabbed Forms
    • Stepped Area Chart
    • Candlestick Chart
    • Histogram Chart
    • Bubble Chart
    • Timeline Chart
    • Gantt Chart
    • Scatter Chart
    • Tree Map Chart
    • Export options
    • Invoice generation
    • Inline Button
    • HTML Wysiwyg
    • Watermarks
  • Data Grid
    • Table View
    • Card View
    • Autohiding Columns
    • Totals
    • Grid Header
    • Column Grouping
    • Record Comparison
    • Unicode Support
    • RSS
    • Custom Drawing
    • Custom Table Template
    • Custom Card Template
    • Custom Toolbar Template
    • Custom View Form
  • Grid Columns
    • Column Types
    • Text Truncating
    • Column Fixed Width
    • Formatting
    • Null Label
    • Hyperlinks
    • Html Display
    • Lookup Data View
    • Custom Rendering
  • Grid Options
    • Fixed Grid Width
    • Fixed Column Header
    • Bordered Table
    • Condensed Table
    • Line Numbers
    • Control Buttons Position
  • Data Sources
    • Table
    • View
    • Non-Updatable Query
    • Updatable Query
    • Updatable View
  • Master-Detail Views
    • Master/Detail Basics
    • Multiple Details
    • Nested Details
    • Card Mode Details
  • Data Input Forms
    • Separate Page
    • Modal Window
    • Inline Editing
    • Form Layouts
    • Tabbed Forms
    • Custom Separate Page
    • Custom Modal Dialog
    • Custom Inline Form
    • Wizard Form
    • Adding multiple records
    • Editors Overview
    • Validation
    • Client-side API
    • Dependent Lookups
    • On-the-Fly Adding
    • Quick Edit
    • Multi Edit
    • Custom Default Values
  • Editors
    • Text
    • Autocomplete
    • Text Area
    • HTML Wysiwyg
    • Spin & Range
    • Upload To Folder
    • Radio Group
    • Combobox
    • Dynamic Combobox
    • Cascading Combobox
    • Dynamic Cascading Combobox
    • Multiple Select
    • Checkbox Group
    • Common Properties
  • Data Filtering
    • Quick Filter
    • Filter Builder
    • Column Filter
    • Preliminary Filter
    • Selection Filters
    • Custom Filter - 1
    • Custom Filter - 2
  • Sorting
    • Sort By Click
    • Sort By Dialog
    • Default Sort Order
  • Partitioning
    • Range
    • List
    • Custom
  • Exporting & Printing
    • Grid
    • Single Record
    • Export Options
    • Custom Grid
    • Custom Single Record
    • User Defined Styles
  • Image Management
    • Image Galleries
    • Thumbnails
    • Linked Images
    • Multi Upload - 1
    • Multi Upload - 2
    • Watermarks
  • Charts
    • Pie Chart
    • Column Chart
    • Bar Chart
    • Line Chart
    • Area Chart
    • Geo Charts
    • Stepped Area
    • Candlestick
    • Histogram
    • Bubble
    • Timeline
    • Gantt
    • Scatter
    • Tree Map
    • Multiple Charts
    • Chart Placement
    • Customizing Charts
    • Dashboard
  • Many-to-Many Relations
    • Classic Junction Table
    • Handling Extra Columns
  • Fine-tuning & Tweaking
    • Custom Icons
    • Custom Theme
    • Custom Editor
    • Page Embedding
    • Ajax-based Validation
    • Color Themes
    • Barcodes Generation
    • Inline Button
    • Conditional Details
    • Using Ajax in Forms
  • Emailing
    • Basic Usage
    • Advanced Usage
  • Calculated Columns
    • Example - 1
    • Example - 2
  • Custom Templates
    • Grid View
    • Card View
    • Grid Toolbar
    • Single Record View
    • Separate Page Editing
    • Modal Dialog Editing
    • Inline Form Editing
    • Wizard Form
    • Custom Filter - 1
    • Custom Filter - 2
    • Export & Print: Data Grid
    • Invoice generation
  1. Data Grid
  2. Data Grid.Column Grouping
    • Table View
    • Card View
    • Autohiding Columns
    • Totals
    • Grid Header
    • Record Comparison
    • Unicode Support
    • RSS
    • Custom Drawing
    • Custom Table Template
    • Custom Card Template
    • Custom Toolbar Template
    • Custom View Form

Data Grid.Column Grouping

Page settings

Appearance

Here you can select the number of cards to be placed in a row for each of supported screen resolutions. Your current resolution is highlighted in this way.

Page size

Total record count: 200.

page(s).
Cancel Save changes
×

Data grid provides the ability to organize columns in logical groups and display them using multi-row header representation. A column group is visually represented by a header displayed above the headers of the columns it combines. Each group can contain data columns as well as other groups.

If auto-hiding columns are defined, a group disappears when all its columns become invisible. If you are on a desktop, reduce the size of the browser window to see this feature in action.

To define column groups for a page, specify the OnGetCustomColumnGroup event. Click the button to see how column grouping has been defined for the example below.

  • «
  • 1
  • ...
  • 4
  • 5
  • 6
  • ...
  • 10
  • »
Add new
Refresh
Export
  • Export to Pdf
  • Export to Excel
  • Export to Word
  • Export to Xml
  • Export to Csv
Print
  • Print current page
  • Print all pages
  • Clear
  • Selection filter
    • Show selected only
    • Show unselected only
    • Show all
  • Export
    • Export to Pdf
    • Export to Excel
    • Export to Word
    • Export to Xml
    • Export to Csv
  • Print
  • Update
        protected function doGetCustomColumnGroup(FixedKeysArray $columns, ViewColumnGroup $columnGroup)
        {
            $columnGroup->add(new ViewColumnGroup('Common info',
                array(
                    $columns['id'],
                    $columns['title'],
                    $columns['release_date']
                )
            ));
            $columnGroup->add(new ViewColumnGroup('Addtional info',
                array(
                    new ViewColumnGroup('Texts',
                        array(
                            $columns['genre_id'],
                            $columns['original_title'],
                            $columns['original_language_id']
                        )
                    ),
                    new ViewColumnGroup('Numbers',
                        array(
                            $columns['runtime'],
                            $columns['rating']
                        )
                    )
                )
            ));
        }

 
Actions Common info Addtional info
Texts Numbers
Id Title Release Date Genre Original Title Original Language Runtime Rating
169917 A Walk Among the Tombstones 2014-09-18 Drama A Walk Among the Tombstones English 113 6.21
174751 Jane Got a Gun 2016-01-01 Drama Jane Got a Gun English 98 4.41
177572 Big Hero 6 2014-10-22 Adventure Big Hero 6 English 102 7.84
177677 Mission: Impossible - Rogue Nation 2015-07-23 Action Mission: Impossible - Rogue Nation English 131 7.08
181533 Night at the Museum: Secret of the Tomb 2014-12-17 Adventure Night at the Museum: Secret of the Tomb English 97 6.12
194662 Birdman 2014-10-17 Drama Birdman English 119 7.31
198184 Chappie 2015-03-04 Action Chappie English 120 6.61
198663 The Maze Runner 2014-09-10 Action The Maze Runner English 113 7.00
201088 Blackhat 2015-01-13 Drama Blackhat English 133 4.98
205584 Gods of Egypt 2016-02-25 Adventure Gods of Egypt English 127 4.92
205596 The Imitation Game 2014-11-14 Drama The Imitation Game English 113 7.98
206647 Spectre 2015-10-26 Adventure Spectre English 148 6.19
207703 Kingsman: The Secret Service 2014-12-13 Adventure Kingsman: The Secret Service English 130 7.65
209112 Batman v Superman: Dawn of Justice 2016-03-23 Adventure Batman v Superman: Dawn of Justice English 151 5.63
210577 Gone Girl 2014-10-01 Drama Gone Girl English 145 7.95
210908 All Cheerleaders Die 2013-09-06 Horror All Cheerleaders Die English 89 4.92
211672 Minions 2015-06-17 Adventure Minions English 91 6.57
214756 Ted 2 2015-06-25 Comedy Ted 2 English 115 6.42
225886 Sex Tape 2014-07-17 Comedy Sex Tape English 97 5.38
227159 Horrible Bosses 2 2014-11-26 Comedy Horrible Bosses 2 English 108 6.12
There are no records to display

Multiple Sort

Column Order

Filter builder

  • «
  • 1
  • ...
  • 4
  • 5
  • 6
  • ...
  • 10
  • »

About this demo

This demo application contains 100+ pages and illustrates most of features provided by PHP Generator. Hope it will help you to create even more powerful websites for your users.

You can download the demo project from our website and run the demo on your webserver as described in readme.txt.

Download PHP Generator Free Trial

Legend
New Recently added or significantly updated pages.
Pro Pages illustrating features available only in the Professional edition of PHP Generator.

© 2002- SQL Maestro Group. Follow us:

Created with PHP Generator for MySQL. Want to learn more? Download the demo project!

Change your password

Change password for user ''

Passwords do not match. Please try again.

Close Change password