Member Avatar for uselessninja

hi...i've research fusion chart... and i find it nice ..

I would like to retrieve from my database(SQL) and graph it using php

is there anybody here experience working with fusion chart and php?...

  • 3 Contributors
  • 5 Replies
  • 902 Views
  • 4 Years Discussion Span
  • Latest Post Latest Post by Ankita_11
Member Avatar for pritaeas

According to the documentation you have to provide the data in XML or JSON format.

Member Avatar for uselessninja

According to the documentation you have to provide the data in XML or JSON format.

yeah i read it :D .... im currently working with SQL-php- fusionchart and i use odbc connection ... im learning xml about 2 days ago and im hoping someone experience odbc with fusion chart and help me just only a basic of it..

Member Avatar for uselessninja

this is my code with odbc ...there's something wrong with it (it will not display the chart)...

<?php
//We've included ../Includes/FusionCharts.php and ../Includes/DBConn.php, which contains
//functions to help us easily embed the charts and connect to a database.
include("/Includes/FusionCharts.php");

?>
<HTML>
   <HEAD>
      <TITLE>FusionCharts Free - Database Example</TITLE>
      <SCRIPT LANGUAGE="Javascript" SRC="../../FusionCharts/FusionCharts.js"></SCRIPT>
   </HEAD>
   <BODY>
   <CENTER>
   <?php   
  
$conn=odbc_connect('datasourcegaby','','');



$firststring= "Select POWER_GEN_1_VAL0,POWER_GEN_2_VAL0 from generators";

 
$rs=odbc_exec($conn,$firststring);

 $conn = connectToDB();


$strXML = "<graph caption='Sales' subCaption='of the month' decimalPrecision='0' showNames='1' numberSuffix=' Units' pieSliceDepth='30' formatNumberScale='0'>";



while (odbc_fetch_row($rs))

{

$g1=odbc_result($rs,"POWER_GEN_1_VAL0");

$g2=odbc_result($rs,"POWER_GEN_2_VAL0");

$strXML .= "<set name='POWER_GEN_1_VAL0' value='".$rs['POWER_GEN_1_VAL0']."' />";
$strXML .= "<set name='POWER_GEN_2_VAL0' value='".$rs['POWER_GEN_2_VAL0']."' />";

}

$strXML .= "</graph>";



//Create the chart - Column 3D Chart with data from strXML variable using dataXML method

echo renderChartHTML("./Charts/FCF_Bar2D.swf", "", $strXML, "ad", 800, 600, false);

?> 

</BODY>
</HTML>

table name:generators

column name1: POWER_GEN_1_VAL0
column name2: POWER_GEN_2_VAL0

Member Avatar for uselessninja

ohhh... i got it! ..


this is where i stuck...

echo renderChartHTML("./Charts/FCF_Bar2D.swf", "", $strXML, "ad", 800, 600, false);

it must be:
echo renderChartHTML("./MyFolderHere/FCF_Bar2D.swf", "", $strXML, "ad", 800, 600, false);

Edited by uselessninja because: n/a
Member Avatar for Ankita_11

I am getting error as:
include(includes/fusioncharts.php): failed to open stream: No such file or directory in C:\xampp\htdocs\ghi.php on line 5

My code is :

<script type="text/javascript" src="/path/to/fusioncharts.js"></script> <script type="text/javascript" src="/path/to/themes/fusioncharts.theme.ocean.js"></script> <?php

include("includes/fusioncharts.php");
$columnChart = new FusionCharts("column2d", "ex1" , 600, 400, "chart-1", "json", '{  
       "chart":{  
          "caption":"Harry SuperMart",
          "subCaption":"Top 5 stores in last month by revenue",
          "numberPrefix":"$",
          "theme":"ocean"
       },
       "data":[  
          {  
             "label":"Bakersfield Central",
             "value":"880000"
          },
          {  
             "label":"Garden Groove harbour",
             "value":"730000"
          },
          {  
             "label":"Los Angeles Topanga",
             "value":"590000"
          },
          {  
             "label":"Compton-Rancho Dom",
             "value":"520000"
          },
          {  
             "label":"Daly City Serramonte",
             "value":"330000"
          }
       ]
    }');
    // Render the chart
    $columnChart->render();
    ?>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.