Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Roger Brown: "Great product. The more I work with it, the more I am amazed at what it can do".
Simon Greener: "A lot of work went in to designing our application database. PHP Generator allowed us to build a fully functional, professional looking, and functionally powerful web application from that database. It has freed us from worrying about low level code, enabling us to focus on the business requirements of the customer. The support provided is excellent with staff quickly producing answers to questions ranging from newbie to simple or complex. I highly recommend the product".

More

Add your opinion

PostgreSQL PHP Generator online Help

Prev Return to chapter overview Next

Charts

PostgreSQL PHP Generator allows you to visualize data on your website with feature-rich, responsive, customizable, and interactive charts.

 

Live examples

You can find a number of examples in the Charts group of the Feature Demo. Some more examples can be found at the Games, Players, and Teams page of the NBA Demo.

 

Key facts

 

1.Charts are based on the Google chart library.
2.Column, Bar, Pie, Line, Area, Geo, Candlestick, Histogram, Bubble, Stepped Area, Timeline, Gantt, Tree Map and Scatter charts are currently supported.
3.Charts can be placed in rows above the data grid or below the grid.
4.Each row can contain any number of charts.
5.Common properties for each chart can be set up directly in the software UI.
6.All other properties provided by the library can be customized with the OnPrepareChart event.
7.Charts are sensitive to the data grid i.e. if you apply a filter to the grid, charts will change accordingly.

 

Creating and editing charts

 

To add a new chart to a webpage or edit an existing one:

 

open the webpage editor;
go to the Charts tab;
Click Add... or Edit... to create a new chart or modify an existing chart accordingly;
define an SQL query to retrieve chart data;
setup common and advanced options of the chart.

 

You can hide/show a chart with the Visible checkbox.

 



Prev Return to chapter overview Next