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. Table of Contents
FusionCharts_XT_with_PHP
. This will be our demo folder.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.Includes
folder from FusionCharts XT Download Package > Code > PHP > Includes
to our demo folder.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: // These four parameters must be changed dependent on your MySQL settings $hostdb = 'localhost'; // MySQl host $userdb = 'root'; // MySQL username $passdb = ''; // MySQL password $namedb = $dbName ? $dbName : 'world'; // MySQL database nameThere 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.
/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: < ?php // Set the content type in the header to text/xml. header('Content-type: text/xml'); // Include DBConn.php include('Includes/DBConn.php'); // Use the connectToDB() function provided in DBConn.php, and establish the connection between PHP and the World database in our MySQL setup. $link = connectToDB(); // Form the SQL query which will return the Top 10 Most Populous Countries. $strQuery = 'SELECT Name AS Country, Population FROM country ORDER BY Population DESC LIMIT 10'; // Execute the query, or else return the error message. $result = mysql_query($strQuery) or die(mysql_error()); // If we get a valid response - if ($result) { // Create the chart's XML string. We can add attributes here to customize our chart. $strXML = ""; while($ors = mysql_fetch_array($result)) { // Append the names of the countries and their respective populations to the chart's XML string. $strXML .= ""; } } // Close the chart's XML string. $strXML .= ""; // Return the valid XML string. echo $strXML; ?>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 // It would generate the HTML and JavaScript code required to render the chart. include('Includes/FusionCharts.php'); ?> < !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
FusionChartsXT_with_PHP_and_MySQL_using_DataString.php
. Write the following code in this file: < ?php // Include the DBConn.php and FusionCharts.php files, so that we can access their variables and functions. include('Includes/DBConn.php'); include('Includes/FusionCharts.php'); // Use the connectToDB() function provided in DBConn.php, and establish the connection between PHP and the World database in our MySQL setup. $link = connectToDB(); // Form the SQL query which will return the Top 10 Most Populous Countries. $strQuery = 'SELECT Name AS Country, Population FROM country ORDER BY Population DESC LIMIT 10'; // Execute the query, or else return the error message. $result = mysql_query($strQuery) or die(mysql_error()); // If we get a valid response - if ($result) { // Create the chart's XML string. We can add attributes here to customize our chart. $strXML = ""; while($ors = mysql_fetch_array($result)) { // Append the names of the countries and their respective populations to the chart's XML string. $strXML .= ""; } } // Close the chart's XML string. $strXML .= ""; ?> < !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Ever had a data set that seemed more complicated than a Rubik's cube? You’re not…
We’ve all seen them in textbooks or presentations—those overlapping circles that simplify complex information into…
We’re excited to announce the upcoming release of FusionCharts v4.1—a groundbreaking step forward in the…
Have you ever been overwhelmed by a massive data set and wondered, "How do I…
If you’ve ever tried to make sense of the stock market, you’ve probably come across…
Imagine you’re comparing the sales performance of your top product lines across different regions, or…
View Comments
Hie after the whole process, the chart is not displayed but only the space holder "chart" is shown, please help
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..
thanks
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 !!
Thanks!!!
what is the actual contents of FusionCharts.php
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??
I blog often and I truly thank you for your content.
This article has truly peaked my interest. I'm going to take a note of
your blog and keep checking for new details about once per week.
I subscribed to your Feed too.
Thanks to my father who stated to me regarding this weblog,
this blog is genuinely awesome.
Hi, I think your site might be having browser compatibility issues.
When I look at your website in Chrome, it looks fine but when opening in Internet Explorer, it
has some overlapping. I just wanted to give you
a quick heads up! Other then that, very good blog!
Fantastic blog! Do you have any suggestions for aspiring writers?
I'm hoping to start my own blog soon but I'm a little lost on everything.
Would you advise starting with a free platform like Wordpress or go for a paid option? There are so many options
out there that I'm totally confused .. Any suggestions?
Thank you!
Yes! Finally something about Judi Poker.