FusionCharts Forum / FusionCharts Free / FusionCharts Free and PHP / Product Forums

combination and mysql don´t work

handyaner — Sat, 20 Mar 2010 11:58:35 GMT

hello
i want two Area2D in one chart
i get the data from a mysql database
but it combinate the two statistic to one

[code] $link = connectToDB();

# Create pie 3d chart object using FusionCharts PHP Class
$FC = new FusionCharts("Area2D","650","450");

# Set Relative Path of swf file.
$FC->setSwfPath("../../FusionCharts/");

//Store chart attributes in a variable for ease of use
$strParam="caption=Factory Output report;subCaption=By Quantity;pieSliceDepth=30; showBorder=1;showNames=1;formatNumberScale=0;numberSuffix= tweets;decimalPrecision=0";

# Set chart attributes
$FC->setChartParams($strParam);

// Fetch all factory records usins SQL Query
//Store chart data values in 'total' column/field and category names in 'FactoryName'
$strQuery = "select count, date from twitter_tweet_day";
$result = mysql_query($strQuery) or die(mysql_error());

$strQuery2 = "select count, date from twitter_follower_day";
$result2 = mysql_query($strQuery2) or die(mysql_error());
//Pass the SQL Query result to the FusionCharts PHP Class function
//along with field/column names that are storing chart values and corresponding category names
//to set chart data from database
if ($result && $result2) {
$FC->addDataFromDatabase($result, "count", "date");
$FC->addDataFromDatabase($result2, "count", "date");
}

mysql_close($link);

# Render the chart
$FC->renderChart();[/code]

just a word 'chart'..

urmil — Fri, 19 Mar 2010 06:39:13 GMT

Hello,

I have just tried fusion chart for the first time. And after rendering it in my php page i can just see a word 'chart'.
I have searched through some forums and link to my js file is okey.

Here s and xml that is generated at the page.

If anyone can help... plzzz...

Problem saving chart (after capturing)

gemejenbrejk — Thu, 18 Mar 2010 10:29:43 GMT

Hi, I'm having problem saving my chart when exporting it as a jpeg/png/pdf.

I have followed the Server-side export > Returning the exported output as download -tutorial under the Exporting as Image/PDF folder in http://www.fusioncharts.com/docs/

The problem occurs after capturing the chart, the download-dialog persists NOT to appear. I hope somebody could tell me what I'm doing wrong...

ps. my webbpage reloads after the capture. I noticed that the demopage doesn't reload when exporting the chart to a file. Mayby some relevance...

//David

Invalid XML data for large amount of data

mojgan.nemati — Fri, 12 Mar 2010 14:41:58 GMT

Hello everyone,

I am having problem creating a Bar2D chart when my query pulls a large amount of data in X Axis. The messge is Invalid XML data. I am using DataXML method.

Would you please let me know what I can do to plot large amount of data.

Thanks in advance,

Mojgan Nemati

Web Application/Database developer

AJAX call from addChartData link:JavaScript

ivolator — Tue, 08 Dec 2009 06:53:54 GMT

Hi there,
I am pretty new with FusionCharts. I managed to get basic functionality working and I must say I like it a lot (thanks FusionCharts)!!!

So to the problem...
When I try to add a drill through to link for my chart for each section via JS like this

$FC->addChartData($data,'link=JavaScript:myAjaxCall(param,param);return false;');

I am getting a JS error 'return not in function'. If I remove the return false; at the end of the JS the page gets redirected.
What is the solution to my pain?
Thanks and Regards!

chart with oracle...

Mohammad Salah — Mon, 08 Mar 2010 02:04:59 GMT

hi all,

i am new in Fusioncharts and i am use oracle database to get data to charts, when i render chart i face this error

Warning: ocifetchinto() [function.ocifetchinto]: ORA-01002: fetch out of sequence in C:\wamp\www\test\Class\FusionCharts_Gen.php on line 717

and here the code:

$conn = connectToOracle();
$FC = new FusionCharts("MSColumn3D","400","220");
$FC->setSWFPath("../FusionCharts/");
$strParam="caption=Separated/Joined Employees;;pieSliceDepth=100;showBorder=1; formatNumberScale=0;numberSuffix= ";
$FC->setChartParams($strParam);
$FC->setDataBaseType("Oracle");
$stid = oci_parse($conn,"select year.year YEAR,
(select count(employee_number) from DASHBOARD_EMP_DETAILS where year_of_hire=year.year )JOINED,
(select count(employee_number) from DASHBOARD_TERMINATION_DTL where termination_year=year.year)SEPARATED
from
(select emp.year_of_hire year from DASHBOARD_EMP_DETAILS emp
union
select term.TERMINATION_YEAR year from DASHBOARD_TERMINATION_DTL term
)year
where year is not null
order by 1");
oci_execute($stid);
$FC->addCategoryFromDatabase($stid, "YEAR");
$p[0]="parentYAxis=P";
$FC->addDatasetsFromDatabase($stid, "YEAR","JOINED");
$FC->addDatasetsFromDatabase($stid, "YEAR","SEPARATED");
$FC->renderChart();
oci_free_statement($stid);
oci_close($conn);

Problem positioning rendered charts

tfacchini — Thu, 04 Mar 2010 17:09:57 GMT

Hi,

Im from Brasil, so sorry for my english...

Well....

Im trying to positioning my div's that will receive the swf chart, but dont matter what kind os style propertie I set up because dont work.

Part of my source code:
[code] echo renderChart("corefiles/FCF_Funnel.swf", "", $strXML_general_1, "GENERAL_1", 300,250);
echo renderChart("corefiles/FCF_Doughnut2D.swf", "", $strXML_general_2, "GENERAL_2", 300, 250);
?>

[table border="1" width="100%"]
[tr]
[td]
[div id="GENERAL_1" style="position:relative; top:100px; background-color:#666; width:500px; border:1px solid #333;"]
[/div]
[/td]
[td]
[div id="GENERAL_2" style="position:relative;"]
[/div]
[/td]
[/tr]
[/table][/code]
How can I set my div position and border, and this kind of configs?

PS: I replace <> for [] tags because the forum reads html commands and all of us will get problem to read my topic. lol

How the charts looks like in my app:

[URL=http://img199.imageshack.us/i/screenshot20100304at808.png/][IMG]http://img199.imageshack.us/img199/9175/screenshot20100304at808.png[/IMG][/URL]

Thanks in advance,
Tfacchini

get chart from database

ankit — Fri, 05 Mar 2010 04:23:00 GMT

dear

i want to create database with the help of database

i have 2 field
date user
10-may-2009 ankit
10-may-2009 amit
11-may-2009 anit

i want to display records in graph by date
but i m geeting problem to show data by while loop tell me pls

SELECT date,count(user) FROM Orders
GROUP BY date

pls help me how we can show date with Count(User) in graph

how add 2 chart on one page

ankit — Fri, 05 Mar 2010 00:28:49 GMT

i want to add two chart in one page

but only one chart is working pls help me

FusionCharts y Mysql

locuas0130 — Thu, 04 Mar 2010 13:03:55 GMT

Alguin podria darme una manito please.

Necesito alguna base para generar una grafica de usuarios y sus avances en porcentaje que los tengo en una base de datos, entiendo que deben estar ocupados o algo asi :P pero porfa pido un poco de su tiempo que necesito huvicarme que debo configurar para graficar.

Agradeciendo de antemano su ayuda me despido.

how to add zero ( or how to show zero) in bar chart when there is no data present

maheshshinde9 — Mon, 28 Apr 2008 00:18:23 GMT

Below I have given picture of bar chart. I want to display zero for bar which don't have data.Means consider following case where Febuary month contains one category while others don't have data. I want zero (0) there. Also If there is not any data present in database for particular month, in that case I want to display zero there. In following case

march, april ,may etc. where there is not any data. I want to display there labels along with

zero (0) on top .

Using $FC->addDatasetsFromDatabase Method want to control category font and size

car2roll — Sat, 20 Feb 2010 13:37:57 GMT

I am using the "addDatasetsFromDatabase" method. It works perfectly. I just want to change the category font and size.
Currently the outCnvBaseFont and outCnvBaseFontSize attributes in the "$FC->setChartParams($strParam)" control the category font. How do I change the category font?

$ctrlField = "category";
$valueField = "Receipts;Outlays;SurplusDeficit;GDP";
$datasetParamArray = array('Color=008800', 'Color=880000', 'Color=CC0033', 'Color=0000CC');

$FC->addDatasetsFromDatabase($data_result, $ctrlField, $valueField, $datasetParamArray);

I tried hard coding the font and size in FusionCharts_Gen.php file on or about line 408.
$strCatXML ="<category name='" . $label . "' " . $strParam . " />";
change to
$strCatXML ="<category name='" . $label . "' font='arial' fontSize='6' />";

In the chart XML for category element this produced the following:
<category name='1961' font='arial' fontSize='6' />
In the documentation font and fontSize are listed as viable attributes for the category element.

I know that hard coding the attributes is not a viable option. I was just trying to find a way to get the attributes into the category element to see if there was a change in the font for the category element. But the category font did not change.

Thanks in advance for your help,
Chris

StackedColumn3DLineDY Emergency...

Mohammad Salah — Wed, 24 Feb 2010 07:57:31 GMT

Hi,

Please can anybody help to get data in StackedColumn3DLineDY chart from database(sql)
i face problem in addDatasetsFromDatabase .

thanks to all

renderChart(); $debugMode=false

juggeraunt — Mon, 22 Feb 2010 22:14:14 GMT

Hey guys

Why my renderChart() function cant pass value to $debugMode?

The thing is my renderChart() function does not work, so I try to echo every variable in the function.
Before the code: $ndebugMode = boolToNum($debugMode); I try to echo $debugMode, but I could not echo it.
Anyone help me here?

renderChart don't work, emergency

juggeraunt — Mon, 22 Feb 2010 17:38:48 GMT

Hi guys

I am doing a project using FusionCharts in PHP. My code can successfully generate a correct $strXML string, but when I tried to use the renderChart function, I failed.

Can anybody here tell me what is the nature of renderChart function? How does it work? Anything need to be taken care of?

God bless you.

Chart data based from form based on dropdown list

twhit67 — Fri, 19 Feb 2010 10:10:40 GMT

Hi folks,
Is there a way to display chart data based on dropdown list choice?

Much like the form example, I'd like to be able to chart data based on month choice from a dropdown list.

To clarify:

I have a seperate php form for users where they enter their data;

Fields to mysql dbase: data1, data2, month, name.
I currently have charts preconfigured to display data1, data2 based on month.

I'd like for them to view the chart display based on whichever month they choose from a dropdown list (Jan, Feb, etc etc)

JQuery Date Picker not working with fusion chart

java_80 — Sat, 01 Nov 2008 08:23:24 GMT

Helloo...

Am using JQuery Date picker and Fusion Chart in the same JSP
in this case the JQuery Date Picker is not working but when ii
remove the Fusion chart code it works, anybody knows why and is there
any alternative solution ..please help me...

Thanks

Max size of a chart

satdev — Tue, 16 Feb 2010 07:39:11 GMT

Hi,

Currently i am working in a fleet management system project, where i need to render a chart for various countries, affiliates, drivers etc.. It is working fine if i keep the height of the y-axis to
4000, but in a particular case, i need to have large number of details in y-axis, say for ex 84 countries and 7 affiliates in combination so the number of data rose upto (84 x 7), In such condition the size of the chart is ok till 4000 but after which it turns blank. Please provide solution for this problem.

Thanks
satdev

How to make candle chart using database in php?

dyas — Fri, 05 Feb 2010 01:34:05 GMT

Hi all,

Help me with this problem, I want make candle stick chart with dynamic data, so candle stick chart can update anytime. Data using database and show candle chart in page php.

I can make building the PHP Page for dataXML Method.
The PHP page for dataXML method example is named as BasicDBExample.php (in DBExample folder) I can sukses to build this.
I try it for candle chart but alwas not success. Please help me to understand it.

Nb. Please with the listing program. ;)

Thanks in advance!

Charting all columns

twhit67 — Fri, 29 Jan 2010 10:30:48 GMT

Can chart the sum of 1 column per example given; $strQuery = "select sum(Quantity) as TotOutput from Factory_Output where FactoryId=" . $ors['FactoryId'];

However, looking for syntax to chart sum(column1) sum(column2) etc etc in one chart by group.

Data is in a MySQL dbase - pulling data via PHP

I've tried the following in various formats;

$strQuery = "select sum(column1) as TotOutput, sum(column2) as TotOutput2 from data where TeamID='1'" . $ors['TeamID'];
$result2 = mysql_query($strQuery) or die(mysql_error());
$ors2 = mysql_fetch_array($result2);

$strXML .= "";

mysql_free_result($result2);

Any help or insight would be appreciated.

Possible bug in renderChartHTML() function

atetrack — Sun, 06 Dec 2009 21:16:41 GMT

I have been using the FusionCharts_Gen.php class to generate my charts (renderChart() function call with html mode set to true) and everything has been working great...in IE.

Today I switched to Firefox and for some reason the only thing that the renderChart() function would spit out for me was 'bgcolor=""'. At first I suspected it might be an isolated case due to wonky data in my environment (which I suppose is still possible), but after looking into it further that may not entirely be the case.

I traced through the code a bit and found that the issue was with a line in the renderChartHTML() method that is only executed for non-MSIE browsers. I believe it is line 944, it starts with:
[code]$strHTML .= "<embed src=....[/code]
Midway through the line there is a conditional used to add the bgcolor property. Unfortunately, it appears that this conditional is not being isolated properly and the concatenation is not producing the expected results.

I added some extra brackets around the following segment of code:
[code]( ($this->JSC["bgcolor"]!="")? " bgcolor=\"" . $this->JSC["bgcolor"] . "\"":"" ) [/code]

Once I added these brackets, everything came to life.

Likely not applicable, but as an FYI anyway, I am using php 5.2.11

$_GET and javascript

drunk — Tue, 19 Jan 2010 13:37:43 GMT

Hello People!
I need some help to do a function in Javascript pass GET parameters to a PHP page.

[quote]
function plotChart(getParameters){
var chartReport = new FusionCharts("fusioncharts/charts/FCF_Column3D.swf", "My Chart", "1000", "360");
var dataUrl= "chart.php?"+getParameters;
//var dataUrlEscape= escape(dataUrl);
alert(dataUrl);
chartReport.setDataURL(dataUrl);
chartReport.render("chart");
}

function getFormData(){
var customersObj = document.getElementById('customers');

var url= "";

var i; getCustomer="";
var arrCustomer;

for (i=0; i arrCustomer = customerObj.options[i].value;
if((i+1)==customerObj.options.length){
getCustomer= getCustomer + "arrCustomer[]=" + arrCustomer;
}else{
getCustomer= getCustomer + "arrCustomer[]=" + arrCustomer + "&";
}
}
//alert(getPredio);
//alert(getCliente);
if(getCustomer != ""){var url = url +"&"+ getCustomer;}
//-------------------------------------------------------------------------------
//alert(url);

plotChart(url);
}
[/quote]

When I print my url I have the result above:

chart.php?arrCustomer[]=A&arrCustomer[]=B&arrCustomer[]=C&flag=1 :w00t:

This URL is correct! But in my PHP page I try take this array with this code:
[quote]
$arrCustomer= $_GET["arrCustomer"];
[/quote]

The Chart in this case stay always same.. I am pass a variable too, and It's perfect!

I read in doc I have to add urlencode in php and escape to javascript but I try do this and nothing yet..
Sorry for my english :P
Anyone can help me?

Generate Img ServerSide -> Return Path Img

JellyBelly — Fri, 15 Jan 2010 09:28:10 GMT

Hello, I groom all documentation regarding the section server side, but I could not come to grips with my problem.
I have a script in PHP that generates a PDF, within this pdf I want to see the chart achieved by FusionCharts. To do that I need to save the image of the graph created on the file system and retrieve the path of the image.
I could not find any example in PHP that makes saving the image on the filesystem graph dela!
This thing is possible with FusionCharts?
If so, how?
Thank you.
Regards

dynamic labelStep

mbjorge — Thu, 14 Jan 2010 07:25:49 GMT

I have read through some posts where you suggested using labelStep. This does not work for me. How should i do this?

Here's my code:

$strXML = "<graph caption='Test' xAxisName='Dato - Tid' yAxisName='Verdi' decimalPrecision='0' formatNumberScale='0' showValues='0' rotateNames='1' labelStep='24'>";
$strXML .= "<set name='$d / $k' value='$val' color='ffffff' shadowAlpha='5'/>"; //generated from a while loop.
........
$strXML .= "<graph>";

How do i also get rid of the line running through the dots, I would onlu like to show the dots?

Not plotting (0;0) data

FreedomOverdose — Wed, 13 Jan 2010 14:24:18 GMT

Hey there

I'm trying to plot a "flat" graph, meaning that all the y values will be equal to 0. Look at the strange rendering I get:
[b]edit: please notice, at the top of the pic, the blue bar of points loads correctly, but not on the right place :S[/b]
[IMG]http://i45.tinypic.com/10f0wmp.jpg[/IMG]
I'm using $FC->addChartDataFromArray($arrData);, just as the example.

When I use print_r($arrData); i get this code:
[quote]Array ( [0] => Array ( [0] => 15 December [1] => 0 ) [1] => Array ( [0] => 16 December [1] => 0 ) [2] => Array ( [0] => 17 December [1] => 0 ) [3] => Array ( [0] => 18 December [1] => 0 ) [4] => Array ( [0] => 19 December [1] => 0 ) [5] => Array ( [0] => 20 December [1] => 0 ) [6] => Array ( [0] => 21 December [1] => 0 ) [7] => Array ( [0] => 22 December [1] => 0 ) [8] => Array ( [0] => 23 December [1] => 0 ) [9] => Array ( [0] => 24 December [1] => 0 ) [10] => Array ( [0] => 25 December [1] => 0 ) [11] => Array ( [0] => 26 December [1] => 0 ) [12] => Array ( [0] => 27 December [1] => 0 ) [13] => Array ( [0] => 28 December [1] => 0 ) [14] => Array ( [0] => 29 December [1] => 0 ) [15] => Array ( [0] => 30 December [1] => 0 ) [16] => Array ( [0] => 31 December [1] => 0 ) [17] => Array ( [0] => 1 January [1] => 0 ) [18] => Array ( [0] => 2 January [1] => 0 ) [19] => Array ( [0] => 3 January [1] => 0 ) [20] => Array ( [0] => 4 January [1] => 0 ) [21] => Array ( [0] => 5 January [1] => 0 ) [22] => Array ( [0] => 6 January [1] => 0 ) [23] => Array ( [0] => 7 January [1] => 0 ) [24] => Array ( [0] => 8 January [1] => 0 ) [25] => Array ( [0] => 9 January [1] => 0 ) [26] => Array ( [0] => 10 January [1] => 0 ) [27] => Array ( [0] => 11 January [1] => 0 ) [28] => Array ( [0] => 12 January [1] => 0 ) [29] => Array ( [0] => 13 January [1] => ) ) [/quote]

Strangely, when I change ANY of the values to a nonzero value, the graph will plot correctly. Any ideas?

Thanks

Gantt Chart (PHP + MySQL) Need Help! Urgent for my graduation.

krebowz — Sun, 22 Nov 2009 20:24:13 GMT

Hellow,

i already try and try again, but still fail. i need this code for my college graduation.
please..need help..really.

need help, i don't understand how to:
1.making (gantt chart XML code) into (gantt chart PHP code).
2.receive data to generate gantt chart.swf from data in database MySQL.

here's my files:
1.database (database name, table, query).
2.gantt chart (XML code).

I will really appreciate any help to solve this!

thanks,
regard jerri jonathan r.f.

Php with Swedish Characters

ramsesiitr — Sat, 02 Jan 2010 21:47:36 GMT

Hello,
I have problem with displaying Swedish characters in charts. I am using PHP. Does FusionCharts Free supports Swedish language?
If so, how can I solve this problem?

Thank you

Array Problem

Nicholas Cooper — Tue, 22 Dec 2009 14:15:12 GMT

I have an xml file that is generated and put into a folder on my web server. Now I would like to pull that information from that XML file and plot it on a graph. Now I got it to plot on the graph but it shows the same thing, which is the last element in the XML file. Below is my php code and if you would like to see my XMLfile I will post a link! I thank you all for your help and time on my problem. I also really love the charts! Thank you again!!!!!!

<?php
include("FusionCharts_Evaluation/FusionCharts.php");
?>
<HTML>
<HEAD>
<TITLE>
FusionCharts - Array Example using Single Series Column 3D Chart
</TITLE>
<?php
//You need to include the following JS file, if you intend to embed the chart using JavaScript.
//Embedding using JavaScripts avoids the "Click to Activate..." issue in Internet Explorer
//When you make your own charts, make sure that the path to this JS file is correct. Else, you would get JavaScript errors.
?>
<SCRIPT LANGUAGE="Javascript" SRC="FusionCharts_Evaluation/Code/FusionCharts/FusionCharts.js"></SCRIPT>
<style type="text/css">

</style>
</HEAD>
<BODY>

<CENTER>
<?php
//In this example, we plot a single series chart from data contained
//in an array. The array will have two columns - first one for data label
//and the next one for data values.

//Let's store the sales data for 6 products in our array). We also store
//the name of products.
//Store Name of Products

$file = 'report_16.xml';
$xml = simplexml_load_file($file);
$flight = $xml->Flight_Data;

foreach($flight as $time){
$results = $time->attributes()->time;

for ($i=0; $i<=2; $i++){
$arrData[$i][1] = $results;
}}

foreach($flight as $alt){
$result = $alt->attributes()->alt;

for ($i=0; $i<=2; $i++){
$arrData[$i][2] = $result;
}}

//Now, we need to convert this data into XML. We convert using string concatenation.
//Initialize <chart> element
$strXML = "<chart caption='Acars Altitude Tracker' numberPrefix='' formatNumberScale='0'>";
//Convert data to XML and append
foreach ($arrData as $arSubData)
$strXML .= "<set label='" . $arSubData[1] . "' value='" . $arSubData[2] . "' />";

//Close <chart> element
$strXML .= "</chart>";

//Create the chart - Column 3D Chart with data contained in strXML
echo renderChart("FusionCharts_Evaluation/Code/FusionCharts/Line.swf", "", $strXML, "productSales", 600, 300, false, false);
?>
<BR><BR>
</CENTER>
</BODY>
</HTML>

Strange problem with big charts

Felipe — Wed, 16 Dec 2009 12:03:03 GMT

Hello,

I've been experiencing some problems with the single line chart but I didn't find a solution yet. Check below:

[img]http://img94.imageshack.us/img94/9634/bug2fw.png[/img]
That's what happens on the free version.

[img]http://img37.imageshack.us/img37/3186/bughj.png[/img]
That's what happens on the paid version (I was using trial since I tought the free was bugish).

The 2 charts above are huge, like 14,000px. They both show a whole year day-by-day. With minor widths (like 500px~2000px) I didn't have any problems.

Thanks in advance and sry for my bad english,

Felipe R.

No data to display

siric — Mon, 30 Nov 2009 18:17:17 GMT

Hi,

I am using a database query to assemble my XML statement but when I render the chart, I get a "No data to Display".

This does not work

[code]echo renderChart("cbw/swf/FCF_Line.swf", "", $strXML, "Satisfaction", 650, 450);[/code]

The strange thing is that if I add a print $strXML just before the renderChart and capture the output from the screen and substitute $strXML in the statement with this, it works.

Works -

[size=7]echo renderChart("cbw/swf/FCF_Line.swf", "", "<graph caption='Factory Output report' subCaption='By Quantity' pieSliceDepth='30' showBorder='1' showNames='1' formatNumberScale='0' numberSuffix=' Reviews' formatNumber='1' formatNumberScale='1' thousandSeparator=',' decimalPrecision='0' anchorBorderColor='0033CC' showAlternateHGridColor='1' AlternateHGridColor='ff5904' divLineColor='ff5904' divLineAlpha='20' alternateHGridAlpha='5'><set name='2008-11' value='0' color='FFE500' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2008-11'/><set name='2008-12' value='0' color='FFE500' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2008-12'/><set name='2009-01' value='0' color='FFE500' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2009-01'/><set name='2009-02' value='0' color='FFE500' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2009-02'/><set name='2009-03' value='0' color='FFE500' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2009-03'/><set name='2009-04' value='0' color='FFE500' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2009-04'/><set name='2009-05' value='0' color='FFE500' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2009-05'/><set name='2009-06' value='0' color='00CC00' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2009-06'/><set name='2009-07' value='9' color='FF0000' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2009-07'/><set name='2009-08' value='5' color='00CC00' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2009-08'/><set name='2009-09' value='20' color='FF0000' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2009-09'/><set name='2009-10' value='18' color='FF0000' link='histoDetail.php%3FbusinessId%3D8%26startDate%3D2009-10'/></graph>", "Satisfaction", 650, 450);[/size]

Is 3D scroll chart available with Free version

kavitha — Thu, 19 Nov 2009 23:15:46 GMT

Is 3D scroll chart available with Free version

Data not accurate

1qTour — Wed, 11 Nov 2009 05:05:39 GMT

Hi,

Firstly thank you fot the FREE product... Hopefully I can get it to work!!

I am passing an array to a php page(iframe), say chart.php?value1=1&value2=2 and so on. Then I create the xml file with this data. After that I call the graph using this xml file just created. I have checked the data & check the xml file and both are correct each time.

Sometimes it works, sometimes the data on the chart is incorrect showing previous results, sometimes the bars on the chart are full and in the shape of a triangle. if i keep submitting the data it may be correct the 6th time around with all these errors happening in no particular order before that and after that.

code of

<?php
//We've included ../Includes/FusionCharts.php, which contains functions
//to help us easily embed the charts.
include("FusionChartsFree/Code/PHP/Includes/FusionCharts.php");
?>
<HTML>
<HEAD>
<TITLE>FusionCharts Free - Simple Column 3D Chart</TITLE>
</HEAD>
<BODY>
<?php

$data[0] = $_GET['choicecount0'];
$data[1] = $_GET['choicecount1'];
$data[2] = $_GET['choicecount2'];
$data[3] = $_GET['choicecount3'];
$data[4] = $_GET['choicecount4'];
$data[5] = $_GET['choicecount5'];
$data[6] = $_GET['choicecount6'];
$data[7] = $_GET['choicecount7'];
$data[8] = $_GET['choicecount8'];
$data[9] = $_GET['choicecount9'];
$data[10] = $_GET['choicecount10'];
$data[11] = $_GET['choicecount11'];

$month[0] = "Jan";
$month[1] = "Feb";
$month[2] = "Mar";
$month[3] = "Apr";
$month[4] = "May";
$month[5] = "Jun";
$month[6] = "Jul";
$month[7] = "Aug";
$month[8] = "Sep";
$month[9] = "Oct";
$month[10] = "Nov";
$month[11] = "Dec";

//testing array data - correct each time
for($i = 0; $i <= 11; $i++)
{
echo $data[$i];
echo "<br>";
}

//create xml file - tried with & without the line break "" no success
$file = "data1.xml";
$fh = fopen($file, "w");
fputs($fh, "<graph caption='Errors' xAxisName='Month' yAxisName='Units' decimalPrecision='0' formatNumberScale='0' >");

for($i = 0; $i <= 11; $i++)
{
$line = "<set name='".$month[$i]."' value='".$data[$i]."' color='002255' />";
fwrite($fh, $line);
}

fputs($fh, "</graph>");

fclose($fh);

//Create the chart - Column 3D Chart with data from data1.xml
echo renderChartHTML("FusionChartsFree/Charts/FCF_Column3D.swf", "data1.xml", "", "myFirst", 600, 300);
?>
</BODY>
</HTML>

Any help would be much appreciated. Thanks in advance.

Daithi

How can i print charts free with all the content of the page in firefox

peteraeon — Thu, 30 Oct 2008 11:50:14 GMT

Hello
im using the free version with php 5.1.x
and i can't print the charts using javascript:window.print() on firefox 2.x because it prints everything
in the page except the chart.
in IE 6, 7 there is not any problem doing the same but i need to use firefox for this
what can i do?

No Data to Display - error when creating a dynamic querystring

MarcelJansens — Wed, 21 Oct 2009 08:01:34 GMT

Setup detail phpfile
$strDataURL = "includes/Graph.php?keyissueId=".$keyissueId."&departmentId=".$departmentId;
echo renderChart("includes/fusionCharts/FCF_Column3D.swf", $strDataURL, "", "Measurements", 400, 300);

Setup Graph phpfile

$keyissueId = $_REQUEST['keyissueId'];
$departmentId = $_REQUEST['departmentId'];

getGraphS1K1($departmentId);

function getGraphS1K1($departmentId) {

include("DBConn.php");
$link = connectToDB();

$strXML = "<graph>";

$strQuery = "select * FROM csrform_s1_k1 where companyId=1"; // this works!!!!
// $strQuery = "select * FROM csrform_s1_k1 where companyId=".$departmentId; // this doesn't works!!!!

$result = mysql_query($strQuery) or die(mysql_error());

if ($result) {
while($ors = mysql_fetch_array($result)) {
$strXML .= "<set name='".$nYearFrom."-".$nYearTill."' value='".$total."' color='AFD8F8' link='?keyissueId=".$ors['keyissueId']."&formId=".$ors['formId']."' />";
}
}

mysql_free_result($result);
mysql_close($link);

$strXML .= "</graph>";

header('Content-type: text/xml');
echo $strXML;

}

The big issue is that both querystrings do write the correct (and same) syntax (XMLString), but the first querystring show a graph in the detail page and the second querystring shows the error 'no data to display'.

I am getting pretty frustrated here! Please help me. If you have the answer, please contact me via mail: marcel.jansens [at] businessbrains.nl

no display trying the charting data from a DB example in php class

lmhart — Wed, 21 Oct 2009 17:06:18 GMT

I can not get the chart to display it simply just gives a page that says chart. Please someone help. I am trying to learn this so I can implement on my pages.

[code]<?php
//We've included ../Includes/FusionCharts_Gen.php, which contains
//FusionCharts PHP Class to help us easily embed charts
//We've also used ../Includes/DBConn.php to easily connect to a database.
include("../class/FusionCharts_Gen.php");
include("../class/DBConn.php");
//include 'dbc.php';
?>

<HTML>
<HEAD>
<TITLE>
FusionCharts Free - Database Example
</TITLE>

<?php
//You need to include the following JS file, if you intend to embed the chart using JavaScript.
//Embedding using JavaScripts avoids the "Click to Activate..." issue in Internet Explorer
//When you make your own charts, make sure that the path to this JS file is correct.
//Else, you would JavaScript errors.
?>
<SCRIPT LANGUAGE="Javascript" SRC="../../FusionCharts/FusionCharts.js"></SCRIPT>

</HEAD>
<BODY>
<CENTER>

<?php
//In this example, we show how to connect FusionCharts to a database.
//For the sake of ease, we've used an MySQL databases containing two
//tables.

// Connect to the Database
$link = connectToDB();

# Create pie 3d chart object using FusionCharts PHP Class
$FC = new FusionCharts("Pie3D","650","450");

# Set Relative Path of chart swf file.
$FC->setSwfPath("../FusionCharts/FCF_Pie2D.swf");

//Store chart attributes in a variable for ease of use
$strParam="caption=Factory Output report;subCaption=By Quantity;pieSliceDepth=30; showBorder=1;showNames=1;formatNumberScale=0;numberSuffix= Units;decimalPrecision=0";

# Set chart attributes
$FC->setChartParams($strParam);

// Fetch all factory records using SQL Query
// Store chart data values in 'total' column/field
// and category names in 'FactoryName'
$strQuery = "select record_category, sum(record_amount) as total from record group by record_category";

$result = mysql_query($strQuery) or die(mysql_error());

//Pass the SQL Query result to the FusionCharts PHP Class function
//along with field/column names that are storing chart values and corresponding category names
//to set chart data from database
if ($result)
{
$FC->addDataFromDatabase($result, "total", "Category");
}

mysql_close($link);

# Render the chart
$FC->renderChart();

</CENTER>
</BODY>
</HTML>[/code]

How create gantt chart with php Class?''

galansex — Thu, 19 Feb 2009 12:54:50 GMT

Hi, I am using FusionCharts Free version and PHPClass. I am constructing a Gantt Chart, I would like to create this chart using the class but i don't know how!!!! please i need help . i don't know what params give to class, something example o what else???''''

Problem export pdf using PHP - $strXML

comiz — Wed, 07 Oct 2009 09:03:58 GMT

Hello,

I can not export to pdf. Clicking right on the chart the process starts, but does not open the box to save the file.
I've tried many ways ... help me please
[b]Examples ??[/b]

Source **********************************
[quote]
[code]
include("Code/PHP/Includes/FusionCharts.php");
include("comandos.php");

$conectar = conecta();

$strXML = "";
$strXML .= "";

$query = selecionar("empresa","id_empresa, fantasia nome","1=1","id_empresa",$conectar);
if (mysql_num_rows($query) > 0) {
while ($result = mysql_fetch_assoc($query)) {
$query2 = selecionar("colaborador a, colaborador_empresa b","count(b.id_colaborador) colab, a.nome", "a.id_colaborador=b.id_colaborador and b.id_empresa='".$result['id_empresa']."' group by b.id_empresa","nome",$conectar);
$result2 = mysql_fetch_assoc($query2);

$strXML .= "";
}
}

$strXML .= "";

echo renderChartHTML("Charts/Pie3D.swf", "", $strXML, "myChart", '50%', '50%', true, true);

?>

FusionCharts Export Handler Component

[/code]
[/quote]
[email]thiago_ccomp@hotmail.com[/email]:blink:

to have mean value in charts using database and php

honeydukes_22 — Thu, 01 Oct 2009 06:16:02 GMT

Hello

I have made a chart uisng database php example. Here is the code:

include("Includes/FusionCharts.php");
include("Includes/DBConn.php");
$dateformat = 'mdy';
?>

// Connect to the DB
$link = connectToDB();

//$strXML will be used to store the entire XML document generated
//Generate the chart element
$strXML = "";

// Fetch all factory records
$strQuery = "SELECT date, count(*) AS numrows FROM items GROUP BY date";
$result = mysql_query($strQuery) or die(mysql_error());
while($row=mysql_fetch_array($result)){
$date = $row['date'];
$numrows = $row['numrows'];

//Now create a second query to get details for this factory
$strQuery1 = "SELECT date,count(*) AS numrows FROM items where date='$date' GROUP BY date";

$result2 = mysql_query($strQuery1) or die(mysql_error());

$ors2 = mysql_fetch_array($result2);
//Generate

$strXML .= "";

//free the resultset
mysql_free_result($result2);
}

mysql_free_result($result);
mysql_close($link);

//Finally, close element
$strXML .= "";

//Create the chart - Pie 3D Chart with data from $strXML
echo renderChart("FusionCharts/Column3D.swf", "", $strXML, "chart", 600, 300, false, false);
?>

Now I need that from the items table where I am pulling all values and showing the chart, I need to calculate the mean value also and show. Can anyone tell me how to do it for fetching values from the database?

FusionCharts_Gen outputs garbage after update

Zane — Fri, 18 Sep 2009 02:35:58 GMT

Hi all,
since I updated to the latest code (Version: 1.0.1 (11 December 2008), AFAIK), I'm experiencing a disrupting problem.

FusionCharts_Gen.php outputs some byte of garbage

[img]http://img10.imageshack.us/img10/389/fusioncgarbage.jpg[/img]

Any hints? Thankyou

Graph does not render precisely on Y axis

brianohit — Mon, 21 Sep 2009 20:56:19 GMT

Hi,

When I generate a 2D area graph the chart sometimes does not render precisely. In the image I include the line should extend from 0 to 1 but it appears to terminate below. Can you tell me what I am doing wrong ?

Here is the image:

Here is the code:

//Instantiate the Chart var chart_redemptions = new FusionCharts("FCF_Area2D.swf", "redemptions", "800", "500", "0", "0"); chart_redemptions.setTransparent("false"); //Provide entire XML data using dataXML method chart_redemptions.setDataXML("<graph caption='' xAxisName='Time' yAxisName='# of Redemptions' numberPrefix='' formatNumberScale='0' decimalPrecision='0' numHDivLines='0' numDivLines='0' ><set name='2009-08-25' value='0' color='AFD8F8' /><set name='2009-08-27' value='1' color='AFD8F8' /></graph>") //Finally, render the chart. chart_redemptions.render("redemptionsDiv");