JavaScript charts in PHP and MySQL with FusionCharts XT – Part 2

This the second part of the FusionCharts XT with PHP series. We will create interactive JavaScript charts using data from a MySQL database with FusionCharts XT. We will make use of the PHP library that is bundled with the FusionCharts Suite.

To recap from the first article in this series, FusionCharts XT is essentially a JavaScript charting library, which renders highly interactive charts in the browser. It takes data in either XML or JSON. To plot a chart using PHP, you need to include the HTML and JavaScript code to embed a chart object and then provide the requisite parameters. To make things simpler for you, we have put all this functionality in a PHP script named FusionCharts.php. This script is bundled in FusionCharts XT Download Package > Code > PHP > Includes > FusionCharts.php. So, whenever you need to work with FusionCharts XT in PHP, just include this file in your page and you’re good to go.

FusionCharts XT in PHP Series

What we are going to visualize

We will make use of the sample World database provided by MySQL and plot the Top 10 Most Populous Countries.

What we will need

Our installation process will be the same as we did in the previous article. You may use the same setup or create it as follows:

  1. Within the root directory of your web server, create a folder named FusionCharts_XT_with_PHP. This will be our demo folder.
  2. Copy the entire Charts folder from the FusionCharts XT Download Package and paste it within our demo folder. This completes the installation of FusionCharts XT in our web application.
  3. Copy the Includes folder from FusionCharts XT Download Package > Code > PHP > Includes to our demo folder.

Connecting to the MySQL database

In the Includes folder, we provide you with DBConn.php, which you can use to connect with your database. You may use this file to authenticate with your database if you aren’t using any other method. You would have to provide the relevant values to connect to your database. For instance, on our demo computer, we have the following values:

There are two ways using which you can provide data to the PHP library – Data URL and Data String. Let us use both of them in detail.

Creating the chart using the Data URL method

In the Data URL method, you instruct FusionCharts to load XML or JSON data from a URL. This URL could refer to a static XML file that is already present on the server, or it could refer to a virtual data provider e.g., /path_to/DataProvider.php, which executes queries the database, builds the XML data as string and finally outputs this XML string to the output stream with content type set to [cciel lang=’html’]text/xml, but without any HTML tags. We then need to create a second file, which would receive this XML string, pass it on to FusionCharts.php, and then render the chart.

Let us create the first file named FusionChartsXT_with_PHP_and_MySQL_using_DataURL_DataProvider.php. Write the following code in this file:

Save this file and navigate to it using your web browser. You should see the following XML displayed:

We now need to pass this XML data to FusionCharts.php, which will generate the required HTML and JavaScript code to display our chart. Let us create a PHP file FusionChartsXT_with_PHP_and_MySQL_using_DataURL.php. In this file, write the following code:

< ?php // Set the rendering mode to JavaScript FC_SetRenderer(‘javascript’); // Call the renderChart method, which would return the HTML and JavaScript required to generate the chart echo renderChart(‘FusionCharts/Column2D.swf’, // Path to chart type ‘FusionChartsXT_with_PHP_and_MySQL_using_DataURL.php’, // Path to the data provider ”, // Empty string when using Data URL Method ‘top10_most_populous_countries’, // Unique chart ID ‘660’, ‘400’, // Width and height in pixels false, // Disable debug mode true // Enable ‘Register with JavaScript’ (Recommended) ); ?>

Save this file and navigate to it using your web browser. This is the JavaScript chart that you should get to see:

Creating the chart using Data String method

In the Data String method, the XML or JSON data is embedded within a single web page, along with the chart’s HTML and JavaScript code. This method doesn’t require a static data file or a virtual data provider. Moreover, once the chart has finished loading, the data is present locally within the page.

Create a blank PHP file named FusionChartsXT_with_PHP_and_MySQL_using_DataString.php. Write the following code in this file:

< ?php // Set the rendering mode to JavaScript FC_SetRenderer(‘javascript’); // Call the renderChart method, which would return the HTML and JavaScript required to generate the chart echo renderChart(‘FusionCharts/Column2D.swf’, // Path to chart type ”, // Empty string when using Data String method $strXML,// Variable which has the chart data ‘top10_most_populous_countries’, // Unique chart ID ‘660’, ‘400’, // Width and height in pixels false, // Disable debug mode true // Enable ‘Register with JavaScript’ (Recommended) ); ?>

Save this file and navigate to it using your web browser. This is the JavaScript chart that you should get to see:

Download source files for these samples

Next in the series

In this article, the chart has top 10 countries by population. In the next article, we will see how to add drill-down capability to this MySQL data. So when you click on the column showing China’s population, you will be able to drill-down to the most populous cities in China.

  • oscar April 16, 2012, 1:44 pm

    Hie after the whole process, the chart is not displayed but only the space holder “chart” is shown, please help

    • Hrishikesh Choudhari April 16, 2012, 2:41 pm

      Hi Oscar, 

      Check whether the JavaScript files are properly included in the page; make sure their path is correct.

      This issue occurs when the FusionCharts JavaScript file is not loaded in the page.

      Let us know if this solves your problem.. 

  • NTAKIRUTIMANA May 29, 2012, 8:24 pm

    thanks

  • fabien June 25, 2012, 6:15 pm

    hi,
    In echo renderChart(………) there is FusionChartsXT_with_PHP_and_MySQL_using_DataURL.php and i think it better be FusionChartsXT_with_PHP_and_MySQL_using_DataURL_DataProvider.php
    Thanks for you work !!

    • Rosenbaum November 11, 2012, 8:14 am

      Thanks!!!

  • ketan p November 22, 2014, 1:59 pm

    what is the actual contents of FusionCharts.php

  • Ferrer August 12, 2015, 9:42 pm

    Hi, I have the same question, what is the contents of FusionCharts.php?? And how do I include the FusionCharts.php to a php file??

Leave a Comment