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 Filtering
  2. Filtering.Column Filter
    • Quick Filter
    • Filter Builder
    • Preliminary Filter
    • Selection Filters
    • Custom Filter - 1
    • Custom Filter - 2

Filtering.Column Filter

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
×

Column filter allows you to filter data against a specific column. It is available in both grid and card view modes and can be activated by pressing the button. By default the filter is enabled for the following columns:

  • Lookup columns;
  • Columns based on the date data type (values are grouped by month and year);
  • Enum columns;
  • Boolean columns;
  • BLOB columns.

For other columns it should be enabled explicitly.

By default, the filter dropdown displays unique column values while this can be customized with the OnPrepareColumnFilter event. Click the button to learn how a custom filter has been implemented for Rating and Runtime columns (where only custom values are used), and Release Date column (custom values are added to default ones).

You can optionally specify the number of items displayed in the filter dropdown as well as change the default sort order of displayed values (the Release Date column).

  • «
  • 1
  • 2
  • ...
  • 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
  • Update
        protected function doPrepareColumnFilter(ColumnFilter $columnFilter)
        {
            // custom values
            $columnFilter->setOptionsFor(
                'rating',
                array(
                    "Less than 3" => FilterCondition::lessThan(3),
                    "4-5" => FilterCondition::between(4, 5),
                    "6-7" => FilterCondition::between(6, 7),
                    "7-8" => FilterCondition::between(7, 8),
                    "Higher than 8" => FilterCondition::greaterThan(8)
                ),
                false // no default values
            );
            
            // custom values with groups
            $columnFilter->setOptionsFor(
                'runtime',
                array(
                    'Shorter than 90 min' => FilterCondition::lessThan(90),
                    '90 - 180 min' => FilterGroup::orX(
                        array(
                            '90-120 min' => FilterCondition::between(90, 120),
                            '120-150 min' => FilterCondition::between(120, 150),
                            '150-180 min' => FilterCondition::between(150, 180)
                        )
                    ),
                    'Longer than 180 min' => FilterCondition::greaterThan(180)
                ),
                false // no default values
            );
            
            // custom values and default values
            $columnFilter->setOptionsFor('release_date',
                array(
                    '2010s' => FilterCondition::between('2010-01-01', '2019-12-31'),
                    '2000s' => FilterCondition::between('2000-01-01', '2009-12-31')
                ),
                true // add default values (this parameter can be omitted)
            );
        }

 
  •   Runtime
  •   Release Date
  •   Rating
  •   Original Language
  •   Genre
There are no records to display
Title Whiplash
Runtime 105
Release Date 2014-10-10
Rating 8.34
Original Language English
Genre Drama
Title The Shawshank Redemption
Runtime 142
Release Date 1994-09-10
Rating 8.30
Original Language English
Genre Drama
Title The Godfather
Runtime 175
Release Date 1972-03-15
Rating 8.23
Original Language English
Genre Drama
Title Interstellar
Runtime 169
Release Date 2014-11-05
Rating 8.17
Original Language English
Genre Adventure
Title Room
Runtime 117
Release Date 2015-10-16
Rating 8.07
Original Language English
Genre Drama
Title Fight Club
Runtime 139
Release Date 1999-10-14
Rating 8.03
Original Language English
Genre Drama
Title Inside Out
Runtime 94
Release Date 2015-06-09
Rating 8.02
Original Language English
Genre Animation
Title The Dark Knight
Runtime 152
Release Date 2008-07-16
Rating 8.02
Original Language English
Genre Drama
Title Pulp Fiction
Runtime 154
Release Date 1994-10-14
Rating 8.01
Original Language English
Genre Thriller
Title Guardians of the Galaxy
Runtime 121
Release Date 2014-07-30
Rating 8.00
Original Language English
Genre Adventure
Title The Imitation Game
Runtime 113
Release Date 2014-11-14
Rating 7.98
Original Language English
Genre Drama
Title Gone Girl
Runtime 145
Release Date 2014-10-01
Rating 7.95
Original Language English
Genre Drama
Title The Wolf of Wall Street
Runtime 180
Release Date 2013-12-25
Rating 7.92
Original Language English
Genre Drama
Title Inception
Runtime 148
Release Date 2010-07-14
Rating 7.86
Original Language English
Genre Adventure
Title The Lord of the Rings: The Return of the King
Runtime 201
Release Date 2003-12-01
Rating 7.85
Original Language English
Genre Adventure
Title Big Hero 6
Runtime 102
Release Date 2014-10-22
Rating 7.84
Original Language English
Genre Adventure
Title 12 Years a Slave
Runtime 134
Release Date 2013-10-18
Rating 7.83
Original Language English
Genre Drama
Title Star Wars
Runtime 121
Release Date 1977-03-20
Rating 7.81
Original Language English
Genre Adventure
Title Never Back Down: No Surrender
Runtime 101
Release Date 2016-06-07
Rating 7.79
Original Language English
Genre Drama
Title How to Train Your Dragon 2
Runtime 102
Release Date 2014-06-12
Rating 7.78
Original Language English
Genre Adventure

Multiple Sort

Column Order
Sort by

Filter builder

  • «
  • 1
  • 2
  • ...
  • 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