[karenn1]

Can anyone urgently help me please? I want to use the multi-series option of FusionCharts and connect it to my database. This is what my table looks like:

months		    units   stationName
January
14,629
 Station 1
February
19,161
 Station 1
March
13,388
 Station 1
April
10,522
 Station 1
May
15,941 
 Station 1
June
10,650
 Station 1
July
11,005
 Station 1
August
19,141
 Station 1
September
13,228
 Station 1
October
22,452
 Station 1
November
15,757
 Station 1
December
20,464
 Station 1
January
    15,654  
Station 2
February
16,718
 Station 2
March
14,839
 Station 2
April
12,791
 Station 2
May
12,838
 Station 2
June
14,229
 Station 2
July
15,616
 Station 2
August
14,633
 Station 2
September
19,544
 Station 2
October
16,592
 Station 2
November
14,746
 Station 2
December
15,425
 Station 2
January
233,796
 Station 3
February
82,309
 Station 3
March
198,876
 Station 3
April
34,959
 Station 3
May
367,101
 Station 3
June
430,691
 Station 3
July
220,664
 Station 3
August
318,963
 Station 3
September
106,403
 Station 3
October
248,531
 Station 3
November
339,486
 Station 3
December
174,552
 Station 3
January
190,048
 Station 4
February
38,460
 Station 4
March
178,998
 Station 4
April
49,516
 Station 4
May
256,988
 Station 4
June
307,099
 Station 4
July
201,678
 Station 4
August
215,608
 Station 4
September
108,847
 Station 4
October
222,191
 Station 4
November
235,785
 Station 4
December
103,880
 Station 4

I'm struggling to get the info from the table. Here's PHP the code I used:

# Months
  
  $strQuery = "SELECT distinct months FROM stations_new"; 
  $result = mysql_query($strQuery);
  
  # Add category names
  $FC->addCategoryFromDatabase($result, "months");
  
  # Stations
  
  # Create a new dataset 
  $strQuery = "select units, months, stationName from stations_new GROUP BY stationName";
  $result = mysql_query($strQuery);
  $FC->addDatasetsFromDatabase($result, "stationName", "units");
 
  
  # Add chart values for the above dataset
  
  
  $strQuery = "select months, units, stationName from stations_new"; 
  $result = mysql_query($strQuery);
  $FC->addDataFromDatabase($result, "units");

This code is not working at all. What am I doing wrong? Is there anyway to simplify the table structure? The table above is very cumbersome. Eventually I would need it to be by week and days of the year. To do that the table would be 365 x 4 rows long. Is there a better way to do this?

Thanks!

Karen

[Sudipto Choudhury]

Hi,

Could you please try changin the SQL :

$strQuery = "select units, months, stationName from stations_new ORDER BY stationName";

[karenn1]

Hi,

Thanks for your reply. I've changed the code as you requested and this is what I get:

At least it's picking up on all four stations per month but it's not recognizing the units. Any insight why this could be?

Thanks!
Karen

[Pallav]

Is your data in XML purely numeric - without any currency or comma signs?

[karenn1]

Hi Pallav,

I had look at my data and there were commas in it. I've taken it out and now it works fine. Thank you for that insight! My other question though, my table of data (as I posted in my first post above) is very lob-sided. Is there an easier way to structure my table?

Thanks!
Karen

[Pzr]

I'm hijacking this.

New to fusioncharts and in big trouble making something out of it. in the demo I can surely see the potential. :-) In an effort to make something out of this I'm trying here for some hints and help. I have a mySQL database with a db table called: material

Table: MATERIAL

S_1  , S_2  , S_3   (columns)

20090626 fot    SUASRTGL22  

20090626 hand SUASRTGL22

20090626 fot   SUASRTGL22

20090627 fot   SUASRTGL22

20090628 hand SUASRTGL22

20090628 hand SUASRTGL22

How should I do to show this in fusioncharts? I would like the lying bar to show the dates ((S_1) 26, 27, 28 etc...), and the the other bar the count of similar S_2 for that date. (Eg. S_2 is for the 20090626 2*fot and 1*hand, that is two bars in different colours.)

Just need a hint or point in the right direction. :-)

/P

 

[Rajroop]

Hello,



Could you please conjure a SQL query and send it over to us for only then can we implement it into our FusionCharts?



Also, please include your results.



We will more than happy to be of help.

[Pzr]

I have tried to give this a shot, but i'm not capable of gettig it to work...



Please advice what i'm doing wrong:



<?php



include('Includes/FusionCharts.php');

include('Includes/Connection_inc.php');



?>



<HTML>

<HEAD>

<TITLE>FusionCharts - Database Example</TITLE>

<SCRIPT LANGUAGE="Javascript" SRC="FusionCharts/FusionCharts.js"></SCRIPT>

</HEAD>

<BODY>

<CENTER>





<?php



$link = connectToDB();



$strXML = "<chart caption='DATUM' subCaption='ANTAL' pieSliceDepth='30' showBorder='1' formatNumberScale='0' numberSuffix=' Units'>";



$strQuery="SELECT s_00100010, s_00400254, s_00400244 from study ORDER BY s_00400244";

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



if ($result) {

while($ors = mysql_fetch_array($result)) {



$strQuery = "select sum(ANTAL) as TotOutput from study where s_000040254=" . $ors['s_00400254'];

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

$ors2 = mysql_fetch_array($result2);



$strXML .= "set label='" . $ors['s_00100010'] . "' value='" . $ors2['s_0040244'] . "' />;



mysql_free_results($result2);

}

}

mysql_close($link);



$strXML .= "</chart>";



echo renderChart("FusionsCharts/Pie.swf", "", $strXML, "Antal us" 600, 300, false, false);



?>





</BODY>

</HTML>



I get error: Parse error: syntax error, unexpected '/' in C:xampplitehtdocsindex3.php on line 40



(I dont want to use a piechart, but just wanted to see if I could get some result and then go from there..)



:-( /Regards



*edit*

Got it working now and I am really happy! :-)

My new challenge is to create a "nested chart", move some variables with the user as he press on a bar and get more in detail information about that one.



But that's for tomorrow! Thank you for a GREAT product!!!

[Rajroop]

Hello,



Firstly, please accept our apologies for the delay in the reply.



In response to your second query: "My new challenge is to create a "nested chart", move some variables with the user as he press on a bar and get more in detail information about that one.", you can use the Drill down attribute of FusionCharts which uses a Javascript function to pass custom set additional information of the data item.



Please note the following link which gives a simple example of Drill down charts and its functionalities: http://www.fusioncha...own/Simple.html



Hope this helps.



Please accept our gratitude for your kind words.

[Pzr]

I'm set! :-) And stunned over the possibilites.

Have a wierd problem I think comes from importing *.xml fi´les in UTF-8 into the dabatase.

When I get the values from within fusioncharts I't doesent show Å, Ä, Ö (and some other characters...) Instead I have some jobberish. I'm currently searching for a solution for this on the web.

If you have som helpful hints they would be much appreciated!

As for now, I have a chart showing med a column with the name BCKEN, but when hovering the column it say's : BÄCKEN (witch is the right thing to show.)

/Emanuel

[Rajroop]

Hello Emanuel,



To insert the accent characters you would need to first add BOM characters to the file after that need to encode your string with utf8_encode() function.



Please see the following code for an example:

$fp = fopen("relatorios/DataXMLFusion.xml" , "w");

$fw = fwrite($fp, "xEFxBBxBF");

$fw = fwrite($fp,utf8_encode($xml));



Hope this helps.