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.
Provides quick access to recently added or significantly updated pages. These pages are also included into the appropriate groups.
This page demonstrates how to customize a grid toolbar.
Customize Edit, Insert, and View forms with just a few lines of code.
An example of a couple Stepped Area charts.
An example of a Candlestick chart.
An example of a Histogram chart.
An example of a Bubble chart.
An example of a Timeline chart.
An example of a Gantt chart.
An example of a Scatter chart.
An example of a Tree Map chart.
Some advanced export options can be configured via the OnGetCustomExportOptions event.
Learn how to customize Export and Print views for a single record.
Learn how to change a value in the database without opening a data input form.
A powerful editor to add and edit HTML content without any coding knowledge.
Example of using watermarks.
Pages showing common data grid features.
Table view is the default option for all pages.
Card view is an alternative way to browse data. It allows you to get a 100% responsive page without any custom settings.Watch video
To make a table view responsive, define column visibilities for each display resolution (mobile, tablet, desktop, and large desktop).Watch video
You can display summaries (Sum, Average, Count, etc) for all or certain grid columns.
This property is used to display a brief description of the page.
You can organize columns in logical groups and display them using multi-row header representation.
Compare records and find identical/different values in a couple of clicks.Watch video
It is possible to display and edit data in any language.
PHP Generator provides support for full-fledged RSS feeds.
You can easily change default appearance of any grid row depending on the row data.
This page demonstrates how it is possible to define a custom template for a grid view.
This page demonstrates how it is possible to define a custom template for a card view.
This page demonstrates how to customize a grid toolbar.
This page demonstrates how to define a custom template for a single record view form.
Pages that illustrate column-specific features such as formatting, hyperlinks, etc.
This page presents all the supported data grid column types.
It is possible to truncate long text values.
You can specify exact width for certain data grid column(s).
You can use various formatting options for columns, such as font, alignment, and even inline styles.
It is possible to define a custom character string that will be displayed when a NULL value is stored in the database.
You can display the contents of a grid cell as a hyperlink.
It is possible to enable or disable HTML display.
You can view the linked record of a lookup column.
You can control the rendering of each cell via the OnCustomRenderColumn event.
Examples for a number data grid options.
You can limit the maximum width of the data grid.
It is possible to get the grid header non-scrollable.
Turn this option ON for borders on all sides of the grid and cells.
This option allows you to make the grid more compact by cutting cell padding in half.
There is also an option to display row numbers.
It is possible to place the control buttons on the left (default) or on the right side of the data grid.
Learn more about data sources your pages can be based on.
Learn how to use a table as page data source.
Learn how to use a view as page data source.
Learn how to use a read-only query as page data source.
Learn how to use an updatable query as page data source.
Learn how to use an updatable view as page data source.
Examples of various kinds of master/detail presentations.
A basic example of master/detail features provided by PHP Generator.
It is possible to have multiple detail views for a single master view.
Nested detail views are also supported. There is no limit to the depth of nesting.
Starting from the version 16.9 inline details (and all the related features) are also supported for card views.
Pages showing common Edit and Insert form features including custom templates.
By default View, Edit, Insert, and Copy forms are displayed on a separate page.
It is also possible to insert, view, edit, and copy data using modal windows.
Inline editing allows you to insert, edit, and copy records directly in the data grid.
Customize Edit, Insert, and View forms with just a few lines of code.Watch video
Customize Edit, Insert, and View forms with just a few lines of code.
Define your own templates to customize Edit and Insert forms in a separate page.
Define your own templates to customize Edit and Insert modal dialogs.
Define your own templates to customize Edit and Insert inline forms.
Learn how to how to split a data input form into multiple steps.
This page displays how to quickly add multiple records.
This page demonstarates all the data editors provided by our software.
PHP Generator provides support for both control level and form level client-side data validation.
Get full control over the Edit and Insert forms via the client-side events.
Learn how to implement cascading lookup controls using client-side events.
Add missing data items to lookup controls directly from Edit and Insert forms.Watch video
You can change the value of a grid cell even without having to go to an Edit form.
You can update multiple records at a time.
You can provide a non-trivial default value for a column in the Insert form.
Each page is dedicated to a certain edit control provided by PHP Generator.
A single-line plain text edit control.
Provides suggestions while you type into the field.
A multi-line plain text edit control.
A powerful editor to add and edit HTML content without any coding knowledge.
Allow users to edit numeric values with ease.
Use this editors to upload a file or an image to a specified folder.
Allows to select one of a limited number of choices.
A drop-down list for selecting among a set of options.
Use this editor for lookup columns when the lookup datasource has a large amount of records.
Allows to select a value using multiple comboboxes.
Allows to select a value using multiple dynamic comboboxes.
Allows to select multiple values from a drop-down list.
Allows to select multiple values from a set of checkboxes.
These properties are supported for all editors.
Provides examples of usage of built-in and user-defined data filtering tools.
The Quick Filter tool allows you to quickly search across all rows.
Filter Builder is the most flexible and powerful data filtering tool provided by PHP Generator.Watch video
Column filter allows you to filter data against a specific column.Watch video
You can display data only after providing one or more filter conditions.
You can create your own filters to select records on a page.
Learn how to create a simple custom filter panel.
Learn how to create an advanced custom filter.
Learn how to sort your data in various ways.
This page explains how to sort data by single or multiple columns using the column header.
Another way to sort data is to use the Sort dialog window.
It is also possible to specify the default sort order for a page.
Provides examples of all kinds of data partitioning supported by PHP Generator.
Range partitioning means that each partition contains rows for which the partitioning expression value lies within a given range.
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.
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.
Learn more about exporting and printing possibilities.
It is possible to export and print the whole grid.
You can also export and print a single record from a View form or directly from the data grid.
Some advanced export options can be configured via the OnGetCustomExportOptions event.
Learn how to customize Export and Print views for the whole data grid.
Learn how to customize Export and Print views for a single record.
You can use your own styles for the printer-friendly version and export to PDF.
Learn more about image management features provided by PHP Generator.
All page images can be viewed in a gallery mode.
Example of using thumbnails.
You can link set of images to any column in a grid.
You can now upload multiple images at once.
Learn how to use multi upload for detail pages.
Example of using watermarks.
Charts are one of the most intuitive way to display the data. Study the pages below to learn how create and customize your charts.
An example of a simple Pie chart with default settings.Watch video
A simple Column chart, also with default settings.Watch video
A Bar chart with a couple of series.
An example of a multiple series Line chart.
An example of an Area chart.
An example of a geographical chart.
An example of a couple Stepped Area charts.
An example of a Candlestick chart.
An example of a Histogram chart.
An example of a Bubble chart.
An example of a Timeline chart.
An example of a Gantt chart.
An example of a Scatter chart.
An example of a Tree Map chart.
It is possible to place multiple charts on any of generated pages.Watch video
Charts can be placed above or below the data grid.Watch video
You can customize any chart according to your needs with the OnPrepareChart event.Watch video
It is also possible to create dashboard-like pages i.e. pages that consist only of charts.
Learn how to manage many-to-many relationships with PHP Generator.
Handling many-to-many relationships: classic junction table.
Handling many-to-many relationships: junction table with extra columns.
Think you are familiar with all the features of PHP Generator? OK, now it is time to study the pages in this group.
Change the default set of icons to your own.
Customize any of color themes that comes with PHP Generator.
Investigate how it is possible to use a third-party edit control in data input forms.
Learn how to embed a generated page into an existing website.
Implement client-side data validation using the Ajax technique.
Get familiar with 25 built-in color themes.
Learn how to generate barcodes of any kind on your page.
Learn how to change a value in the database without opening a data input form.
Learn how to show or hide details depending on a condition.
Learn how to use Ajax in data input forms to retrieve some information from the server.
Provides examples of sending emails from server-side events.
A simple example of sending an email from a server-side event.
A more complex example of sending an email from a server-side event.
Provides examples of using calculated (AKA computed) columns.
Introduction to calculated columns.
A more complex example of using calculated columns.
Customize everything according to your dreams.
This page demonstrates how it is possible to define a custom template for a grid view.
This page demonstrates how it is possible to define a custom template for a card view.
This page demonstrates how to customize a grid toolbar.
This page demonstrates how to define a custom template for a single record view form.
Define your own templates to customize Edit and Insert forms in a separate page.
Define your own templates to customize Edit and Insert modal dialogs.
Define your own templates to customize Edit and Insert inline forms.
Learn how to how to split a data input form into multiple steps.
Learn how to create a simple custom filter panel.
Learn how to create an advanced custom filter.
Learn how to customize Export and Print views for the whole data grid.
Learn how to customize Export and Print views for a single record.