Sign in to follow this  

Is It Possible To Make "gauge" Charts Using Php And Mysql?

Recommended Posts

I've downloaded and installed the Widgets XT package and I want to query the MySQL database to make my gauge. In the little bit of reading I've done, I'm shown the code "echo renderChart(paramters here)" etc. But no where in the trial files is the php function renderChart.


Do I have to download/eventually purchase more than just the widgets package to make this possible?




Share this post

Link to post
Share on other sites
Guest Sashibhusan

Hi Dami,


A warm welcome to FusionCharts Forum. :D


You are in the absolutely correct direction.


Yes, renderChart function can be used in PHP to render a chart/gauge.


We generally call this as a function of FusionCharts PHP Wrapper Class (FusionCharts.php) - an umbrella wrapper class to render charts and gauges present in all packs of FusionCharts Suite XT pack and FusionWidgets XT (which you have downloaded) is part of this Suite.


However, FusionCharts.php is not present in FusionWidgets XT pack. It is present in FusionCharts XT download pack.


But not to worry! You do not need to buy FusionCharts XT to procure this. The fully functional PHP wrapper class is present in FusionCharts XT Trial pack and you can easily download the FusionCharts XT Trial pack from


Once downloaded you can get the file from the FusionCharts XT Download Package > Code > PHP > Includes folder. The said PHP folder also provides a lots of code samples which you can try. The code samples presently uses charts from FusionCharts pack, which you just need to replace with charts and gauges from FusionWidgets XT pack. For example, you can change the Column3D.swf chart to Funnel.swf chart.


You can also read how these are implemented from the Documentation of FusionCharts XT:


1. Basic Example

2. Using PHP and MySQL


Just remember that although these code and documentation pages showcase the use of charts from FusionCharts XT pack, you can simply replace the chart types and use charts from FusionWidgets XT pack.


All you would need to do it to understand the XML structure of the various gauges and charts of FusionWidgets XT, and build XML using the format required by the gauges or chart (from FusionWidgets XT pack)you intend to render.


Also, using MySQL is simple - you can use you own PHP code to connect to the tables. All you need is to build correct XML (using simple string concatenation) for the required chart.


Hope this helps.

Edited by Sudipto Choudhury
Answer modified

Share this post

Link to post
Share on other sites

Oh, Benevolent Supreme Being, you have more than answered my question. ;)


Thank you for the tip about FusionCharts having the files I need. I have cobbled together a MySQL query and got it to work without the renderChart function, displaying multiple charts per page, based on the query results. This is going to be fun!


Thanks again,


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this