PHP Generator Feature Demo

This demo application contains 100+ pages to explain most of the features provided by PHP Generator for MySQL. You can investigate it online or download the demo project from our website and run the demo on your webserver.

 Start the demo

Recently added/updated

Provides quick access to recently added or significantly updated pages. These pages are also included into the appropriate groups.

Grid Toolbar

This page demonstrates how to customize a grid toolbar.

Tabbed Forms

Customize Edit, Insert, and View forms with just a few lines of code.

Stepped Area Chart

An example of a couple Stepped Area charts.

Candlestick Chart

An example of a Candlestick chart.

Histogram Chart

An example of a Histogram chart.

Bubble Chart

An example of a Bubble chart.

Timeline Chart

An example of a Timeline chart.

Gantt Chart

An example of a Gantt chart.

Scatter Chart

An example of a Scatter chart.

Tree Map Chart

An example of a Tree Map chart.

Export options

Some advanced export options can be configured via the OnGetCustomExportOptions event.

Invoice generation

Learn how to customize Export and Print views for a single record.

Inline Button

Learn how to change a value in the database without opening a data input form.

HTML Wysiwyg

A powerful editor to add and edit HTML content without any coding knowledge.

Watermarks

Example of using watermarks.

Data Grid

Pages showing common data grid features.

Table View

Table view is the default option for all pages.

Card View

Card view is an alternative way to browse data. It allows you to get a 100% responsive page without any custom settings.Watch video

Autohiding Columns

To make a table view responsive, define column visibilities for each display resolution (mobile, tablet, desktop, and large desktop).Watch video

Totals

You can display summaries (Sum, Average, Count, etc) for all or certain grid columns.

Grid Header

This property is used to display a brief description of the page.

Column Grouping

You can organize columns in logical groups and display them using multi-row header representation.

Record Comparison

Compare records and find identical/different values in a couple of clicks.Watch video

Unicode Support

It is possible to display and edit data in any language.

RSS

PHP Generator provides support for full-fledged RSS feeds.


Custom Drawing

You can easily change default appearance of any grid row depending on the row data.


Custom Table Template

This page demonstrates how it is possible to define a custom template for a grid view.

Custom Card Template

This page demonstrates how it is possible to define a custom template for a card view.

Custom Toolbar Template

This page demonstrates how to customize a grid toolbar.

Custom View Form

This page demonstrates how to define a custom template for a single record view form.

Grid Columns

Pages that illustrate column-specific features such as formatting, hyperlinks, etc.

Column Types

This page presents all the supported data grid column types.

Text Truncating

It is possible to truncate long text values.

Column Fixed Width

You can specify exact width for certain data grid column(s).

Formatting

You can use various formatting options for columns, such as font, alignment, and even inline styles.

Null Label

It is possible to define a custom character string that will be displayed when a NULL value is stored in the database.

Hyperlinks

You can display the contents of a grid cell as a hyperlink.

Html Display

It is possible to enable or disable HTML display.

Lookup Data View

You can view the linked record of a lookup column.

Custom Rendering

You can control the rendering of each cell via the OnCustomRenderColumn event.

Grid Options

Examples for a number data grid options.

Fixed Grid Width

You can limit the maximum width of the data grid.

Fixed Column Header

It is possible to get the grid header non-scrollable.

Bordered Table

Turn this option ON for borders on all sides of the grid and cells.

Condensed Table

This option allows you to make the grid more compact by cutting cell padding in half.

Line Numbers

There is also an option to display row numbers.

Control Buttons Position

It is possible to place the control buttons on the left (default) or on the right side of the data grid.

Data Sources

Learn more about data sources your pages can be based on.

Table

Learn how to use a table as page data source.

View

Learn how to use a view as page data source.

Non-Updatable Query

Learn how to use a read-only query as page data source.

Updatable Query

Learn how to use an updatable query as page data source.

Updatable View

Learn how to use an updatable view as page data source.

Master-Detail Views

Examples of various kinds of master/detail presentations.

Master/Detail Basics

A basic example of master/detail features provided by PHP Generator.

Multiple Details

It is possible to have multiple detail views for a single master view.

Nested Details

Nested detail views are also supported. There is no limit to the depth of nesting.

Card Mode Details

Starting from the version 16.9 inline details (and all the related features) are also supported for card views.

Data Input Forms

Pages showing common Edit and Insert form features including custom templates.

Separate Page

By default View, Edit, Insert, and Copy forms are displayed on a separate page.

Modal Window

It is also possible to insert, view, edit, and copy data using modal windows.

Inline Editing

Inline editing allows you to insert, edit, and copy records directly in the data grid.

Form Layouts

Customize Edit, Insert, and View forms with just a few lines of code.Watch video

Tabbed Forms

Customize Edit, Insert, and View forms with just a few lines of code.

Custom Separate Page

Define your own templates to customize Edit and Insert forms in a separate page.

Custom Modal Dialog

Define your own templates to customize Edit and Insert modal dialogs.

Custom Inline Form

Define your own templates to customize Edit and Insert inline forms.

Wizard Form

Learn how to how to split a data input form into multiple steps.


Adding multiple records

This page displays how to quickly add multiple records.

Editors Overview

This page demonstarates all the data editors provided by our software.

Validation

PHP Generator provides support for both control level and form level client-side data validation.

Client-side API

Get full control over the Edit and Insert forms via the client-side events.

Dependent Lookups

Learn how to implement cascading lookup controls using client-side events.

On-the-Fly Adding

Add missing data items to lookup controls directly from Edit and Insert forms.Watch video

Quick Edit

You can change the value of a grid cell even without having to go to an Edit form.

Multi Edit

You can update multiple records at a time.

Custom Default Values

You can provide a non-trivial default value for a column in the Insert form.

Editors

Each page is dedicated to a certain edit control provided by PHP Generator.

Text

A single-line plain text edit control.

Autocomplete

Provides suggestions while you type into the field.

Text Area

A multi-line plain text edit control.

HTML Wysiwyg

A powerful editor to add and edit HTML content without any coding knowledge.

Spin & Range

Allow users to edit numeric values with ease.

Upload To Folder

Use this editors to upload a file or an image to a specified folder.


Radio Group

Allows to select one of a limited number of choices.

Combobox

A drop-down list for selecting among a set of options.

Dynamic Combobox

Use this editor for lookup columns when the lookup datasource has a large amount of records.

Cascading Combobox

Allows to select a value using multiple comboboxes.

Dynamic Cascading Combobox

Allows to select a value using multiple dynamic comboboxes.


Multiple Select

Allows to select multiple values from a drop-down list.

Checkbox Group

Allows to select multiple values from a set of checkboxes.


Common Properties

These properties are supported for all editors.

Data Filtering

Provides examples of usage of built-in and user-defined data filtering tools.

Quick Filter

The Quick Filter tool allows you to quickly search across all rows.

Filter Builder

Filter Builder is the most flexible and powerful data filtering tool provided by PHP Generator.Watch video

Column Filter

Column filter allows you to filter data against a specific column.Watch video

Preliminary Filter

You can display data only after providing one or more filter conditions.

Selection Filters

You can create your own filters to select records on a page.

Custom Filter - 1

Learn how to create a simple custom filter panel.

Custom Filter - 2

Learn how to create an advanced custom filter.

Sorting

Learn how to sort your data in various ways.

Sort By Click

This page explains how to sort data by single or multiple columns using the column header.

Sort By Dialog

Another way to sort data is to use the Sort dialog window.

Default Sort Order

It is also possible to specify the default sort order for a page.

Partitioning

Provides examples of all kinds of data partitioning supported by PHP Generator.

Range

Range partitioning means that each partition contains rows for which the partitioning expression value lies within a given range.

List

In the list partitioning each partition is defined and selected based on the membership of a column value in one of a set of value lists.

Custom

If neither range nor list partitioning is suitable for your needs, you can define a couple of PHP functions to split data to different partitions in any way you like.

Exporting & Printing

Learn more about exporting and printing possibilities.

Grid

It is possible to export and print the whole grid.

Single Record

You can also export and print a single record from a View form or directly from the data grid.


Export Options

Some advanced export options can be configured via the OnGetCustomExportOptions event.

Custom Grid

Learn how to customize Export and Print views for the whole data grid.

Custom Single Record

Learn how to customize Export and Print views for a single record.

User Defined Styles

You can use your own styles for the printer-friendly version and export to PDF.

Image Management

Learn more about image management features provided by PHP Generator.

Image Galleries

All page images can be viewed in a gallery mode.

Thumbnails

Example of using thumbnails.

Linked Images

You can link set of images to any column in a grid.

Multi Upload - 1

You can now upload multiple images at once.

Multi Upload - 2

Learn how to use multi upload for detail pages.

Watermarks

Example of using watermarks.

Charts

Charts are one of the most intuitive way to display the data. Study the pages below to learn how create and customize your charts.

Pie Chart

An example of a simple Pie chart with default settings.Watch video

Column Chart

A simple Column chart, also with default settings.Watch video

Bar Chart

A Bar chart with a couple of series.

Line Chart

An example of a multiple series Line chart.

Area Chart

An example of an Area chart.

Geo Charts

An example of a geographical chart.

Stepped Area

An example of a couple Stepped Area charts.

Candlestick

An example of a Candlestick chart.

Histogram

An example of a Histogram chart.

Bubble

An example of a Bubble chart.

Timeline

An example of a Timeline chart.

Gantt

An example of a Gantt chart.

Scatter

An example of a Scatter chart.

Tree Map

An example of a Tree Map chart.


Multiple Charts

It is possible to place multiple charts on any of generated pages.Watch video

Chart Placement

Charts can be placed above or below the data grid.Watch video

Customizing Charts

You can customize any chart according to your needs with the OnPrepareChart event.Watch video

Dashboard

It is also possible to create dashboard-like pages i.e. pages that consist only of charts.

Many-to-Many Relations

Learn how to manage many-to-many relationships with PHP Generator.

Classic Junction Table

Handling many-to-many relationships: classic junction table.

Handling Extra Columns

Handling many-to-many relationships: junction table with extra columns.

Fine-tuning & Tweaking

Think you are familiar with all the features of PHP Generator? OK, now it is time to study the pages in this group.

Custom Icons

Change the default set of icons to your own.

Custom Theme

Customize any of color themes that comes with PHP Generator.

Custom Editor

Investigate how it is possible to use a third-party edit control in data input forms.

Page Embedding

Learn how to embed a generated page into an existing website.

Ajax-based Validation

Implement client-side data validation using the Ajax technique.

Color Themes

Get familiar with 25 built-in color themes.

Barcodes Generation

Learn how to generate barcodes of any kind on your page.

Inline Button

Learn how to change a value in the database without opening a data input form.

Conditional Details

Learn how to show or hide details depending on a condition.

Using Ajax in Forms

Learn how to use Ajax in data input forms to retrieve some information from the server.

Emailing

Provides examples of sending emails from server-side events.

Basic Usage

A simple example of sending an email from a server-side event.

Advanced Usage

A more complex example of sending an email from a server-side event.

Calculated Columns

Provides examples of using calculated (AKA computed) columns.

Example - 1

Introduction to calculated columns.

Example - 2

A more complex example of using calculated columns.

Custom Templates

Customize everything according to your dreams.

Grid View

This page demonstrates how it is possible to define a custom template for a grid view.

Card View

This page demonstrates how it is possible to define a custom template for a card view.

Grid Toolbar

This page demonstrates how to customize a grid toolbar.

Single Record View

This page demonstrates how to define a custom template for a single record view form.

Separate Page Editing

Define your own templates to customize Edit and Insert forms in a separate page.

Modal Dialog Editing

Define your own templates to customize Edit and Insert modal dialogs.

Inline Form Editing

Define your own templates to customize Edit and Insert inline forms.

Wizard Form

Learn how to how to split a data input form into multiple steps.

Custom Filter - 1

Learn how to create a simple custom filter panel.

Custom Filter - 2

Learn how to create an advanced custom filter.

Export & Print: Data Grid

Learn how to customize Export and Print views for the whole data grid.

Invoice generation

Learn how to customize Export and Print views for a single record.