Multi-Series with MySQL Database

Multi-Series with MySQL Database :: URGENT!

FusionCharts Forum

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

11 posts, Page 1 of 2

1 2 »»

Multi-Series with MySQL Database :: URGENT!

Rate Topic

Display Mode

Topic Options

Author

Message

karenn1

Posted 4/4/2008 5:28:27 AM

Forum Newbie

Group: Forum Members
Last Login: 4/9/2008 2:58:47 AM
Posts: 3, Visits: 5

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

Post #5449

Sudipto Choudhury

Posted 4/7/2008 12:15:02 AM

Supreme Being

Group: Administrators
Last Login: Today @ 12:33:50 PM
Posts: 1,533, Visits: 2,932

Hi,

Could you please try changin the SQL :

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

Regards,

Sudipto Choudhury
FusionCharts Team

I code, therefore I am.

Post #5466

karenn1

Posted 4/7/2008 12:48:33 AM

Forum Newbie

Group: Forum Members
Last Login: 4/9/2008 2:58:47 AM
Posts: 3, Visits: 5

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

Post #5467

Pallav

Posted 4/8/2008 10:26:08 PM

FusionCharts Team

Group: Administrators
Last Login: Today @ 7:39:40 AM
Posts: 2,384, Visits: 764

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

Thanks,
Pallav Nadhani
FusionCharts Team

Post #5520

karenn1

Posted 4/9/2008 2:26:49 AM

Forum Newbie

Group: Forum Members
Last Login: 4/9/2008 2:58:47 AM
Posts: 3, Visits: 5

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

Post #5536

Pzr

Posted 6/30/2009 6:56:01 AM

Junior Member

Group: Forum Members
Last Login: 9/3/2010 7:53:20 AM
Posts: 22, Visits: 67

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

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. :-)

Post #15693

Rajroop

Posted 7/2/2009 7:02:55 AM

Supreme Being

Group: Administrators
Last Login: Today @ 4:45:29 AM
Posts: 1,710, Visits: 2,605

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. Smile

Regards,
Rajroop Bhaduri
FusionCharts Team

Follow us @Twitter

Post #15761

Pzr

Posted 7/8/2009 5:34:23 AM

Junior Member

Group: Forum Members
Last Login: 9/3/2010 7:53:20 AM
Posts: 22, Visits: 67

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:\xampplite\htdocs\index3.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!!! BigGrin

Post #16056

Rajroop

Posted 7/11/2009 2:30:31 AM

Supreme Being

Group: Administrators
Last Login: Today @ 4:45:29 AM
Posts: 1,710, Visits: 2,605

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.fusioncharts.com/free/docs/Contents/DrillDown/Simple.html

Hope this helps. Tongue

Please accept our gratitude for your kind words. Rolleyes

Regards,
Rajroop Bhaduri
FusionCharts Team

Follow us @Twitter

Post #16170

Pzr

Posted 7/14/2009 6:10:16 AM

Junior Member

Group: Forum Members
Last Login: 9/3/2010 7:53:20 AM
Posts: 22, Visits: 67

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

Post #16246

« Prev Topic | Next Topic »

11 posts, Page 1 of 2

1 2 »»

Permissions

All times are GMT -5:00, Time now is 9:16pm

Execution: 0.078.