Skip to main content

How to implement graphs using fusion charts and php

How to implement graphs using fusion charts and php


In this post i would like to explain about how to implementing graphs using fusion charts. And implemented using PHP. In my previous post explained about How to calculate statistics in daily, weekly , monthly and yearly using php. Get the information using that post and implement the graph using this code. Create a xml file with specific feilds and download the fusion charts from the site. By following example i will explain. We can get the values from database and create xml file as mentioned.
This picture denotes : A graph for number of registrations over the year ( by monthly ) divided men and women.
how to implement graphs using fusion charts and php | Anil Labs
how to implement graphs using fusion charts and php | Anil Labs

1) Create a xml file :


In my previous post i have explained about how to calculate statistics in daily, weekly , monthly and yearly using php. By using this post we can get the categories.
 $dataFeildsArray={"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"};
Get the men registered numbers per month by using mysql quires.
for($d1=0;$d1<count($dataFeildsArray);$d1++){
  $get_users_query = "select *  from usertbl WHERE DATE_FORMAT( reg_date, '%Y.%M' ) =  '".'2011'.$months[$d1]."' AND gender='male'";
   $result = mysql_query($get_users_query);
   $dataArrayDay_men[] = mysql_num_rows($result);
  }
 // Same for women

Prepare XML file


<?php  
$strXMLYEAR = "<graph xaxisname='' yaxisname='No.Of Registrations' hovercapbg='F5589A' hovercapborder='F5589A' rotateNames='1' yAxisMaxValue='100' numdivlines='9' divLineColor='CCCCCC' divLineAlpha='80' decimalPrecision='0' showAlternateHGridColor='1' AlternateHGridAlpha='30' AlternateHGridColor='F5589A' caption='Registrations' subcaption='During a Year' >";
 
$strXMLYEAR .= "<categories font='Arial' fontSize='11' fontColor='000000'>";
 
for($i=(count($disp_months)-1);$i>=0;$i=$i-1){
    $strXMLYEAR .= "<category name='".$disp_months[$i]."' hoverText='".$disp_months[$i]."'/>";
    }
$strXMLYEAR .= "</categories><dataset seriesname='Men' color='FDC12E'>";
 
for($m1=(count($dataArrayDay_men)-1);$m1>=0;$m1=$m1-1){
    $strXMLYEAR .= "<set value='".$dataArrayDay_men[$m1]."' />";
    }
$strXMLYEAR .= "</dataset><dataset seriesname='Women' color='F5589A'>";
 
for($m1=(count($dataArrayDay_women)-1);$m1>=0;$m1=$m1-1){
    $strXMLYEAR .= "<set value='".$dataArrayDay_women[$m1]."' />";
    }
$strXMLYEAR .= "</dataset></graph>";
 
echo renderChart("Charts/FCF_MSColumn3D.swf", "", $strXMLYEAR, "productSales1235", 600, 300);
?>
Download fusion charts from from http://www.fusioncharts.com/
Labels:

Comments

Post a Comment

Popular posts from this blog

Learn phpfox

PHPFox  is a social network script, it is an internet application and when you install it, it is a website. The  phpfox  script comes in 3 packages, each with a different set of modules. it has two products: 1. Nebula (upto phpfox 3.8) 2. Neutron (Newer) You can check the demo on :  http://www.phpfox.com =================================================== To clear cache in phpfox follow the following steps, admincp >> Tools >> Maintenance >> Cache Manager >> Click on Clear All button =================================================== To work facebook app on local Following settings need to done in facebook app   1) go => setting => Advance 2) see "OAuth Settings" area and set "Valid OAuth redirect URIs" =  http:// projectdomain /index.php?do=/user/login/, http:// projectdomain .com/index.php?do=/user/register/, http:// projectdomain .com, http:// projectdomain .com/index.php 3) en...
Post a Comment
Read more

Interview PHP

>> Why do you want to work at our company? Sir, It is a great privilege for anyone to work in a reputed company like yours. When I read about your company I found that my skills are matching your requirements.  Where I can showcase my technical skills to contribute to the company growth. >> What are your strengths? I am very much hard working and optimistic. Hard Working: Work with dedication and determination. Optimistic: work with positive attitude. I am a team player. I am also very hardworking, and will do what it takes to get the job done. >> What are your weaknesses? Gets nervous when talk to strangers I am a bit lazy about which I am not interested I tend to trust people too easily. I am working on it. >> Why should I hire you? With reference to my work experience, I satisfy all the requirement for this job. I am sincere with my work and would never let you down in anyway. I promise you will never regret for the decision to a...
1 comment
Read more

How to Make Your Own PHP Captcha Generator

In this article we will create file based simple yet successful captcha generator. 3 Major Anti-spamming techniques used? Mathematical Operation like Random number + Random Number = -> The user must specify the answer Random word -> User must type the word Random question -> Obvious one which the user should answer correctly [ex: Are you human?] How Captcha works? The captcha generator generates an IMAGE with the question and then put up a session variable storing the value. User input though an input box. Using php POST, we compare the session variable data with the user input and tell whether its a bot or human. Its coding time The Code First let's write the php script which generates the captcha image. We use the simple header-content change technique, from which we can easily bring up an image from a given text. captcha.php PHP Code: array("Num" => "Num"), 1 => array("Are y...
Post a Comment
Read more