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

Subscribe to our news:
Partners
Testimonials
Steve Morton: "First let me thank you for making this application Free. Best deal I have ever see for what it does".
George Westrup: "I have saved so much time using your products. Also you are quick to respond to every question I have had. Thanks for the great support".

More

Add your opinion

Customers
Download Buy

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

Charts

PHP Generator for MySQL 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