FusionCharts Forum / FusionCharts Free / FusionCharts Free and PHP

Accents make me crazy! Really!

jchatard — Thu, 15 May 2008 11:32:56 GMT

Sorry to post again a question about accent. But really after reading all topics about accent problems, I really think I miss it!

I'm working with Drupal 6.2 generating some data. Creating the XML file which is accessible from an URL (/data). On top of my XML generation function I added the Drupal header function :
- drupal_set_header('Content-type: text/xml; charset=utf-8');
My Firefox confirms that, really.

And my call to the SWF is like this :

[quote]

<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="500" height="400" id="abdc">
<param name="allowScriptAccess" value="always" />
<param name="movie" value="/swf/MSStackedColumn2D.swf"/>
<param name="FlashVars" value="&chartWidth=500&chartHeight=400&debugMode=1&dataURL=http://localhost:8888/data" />
<param name="quality" value="high" />
<embed src="/swf/MSStackedColumn2D.swf" FlashVars="&chartWidth=500&chartHeight=400&debugMode=1&dataURL=http://localhost:8888/data" quality="high" width="500" height="400" name="abdc" allowScriptAccess="always" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
</object>

[/quote]

And I still have thoses dummies characters!

PLEASE PLEASE HELP !!!

Thank you guys!

Jérémy

Gantt Chart (php + MySQL)

mariela — Wed, 14 May 2008 11:56:15 GMT

Hi,

After several experiments with the gantt chart to receive data from MySQL passed by php, I got - "Chart" as text without chart.

I will really appreciate any help to solve this!

Thanks in advance,

Mariela

Using Charts to grab from database and show times

Alpo — Thu, 08 May 2008 16:08:38 GMT

Well i have a game that shows amounts of money that everyone has.

Im using the chart to show that amount of money in the game. The problem I have is I dunno how to make it show the dates...so you will be able to see the amount of money in the game yesterday and the amount today. Im not sure how to add that and I need some help. you can visit this link to see what the chart looks like so far.

www.crimesociety.com/Default.php

getXML() not returning xml

Mac — Tue, 06 May 2008 10:48:40 GMT

I can't seem to get $FC->getXML(); to work properly. I have a chart that is being rendered fine and is receiving the xml data properly, and I can see the xml data string in my javascript but in my php code I cannot seem to store the xml data. Is there something I'm doing wrong?

Here's what I'm trying to do in the php file after i've set all chart params and created the instance of the chart:

[code]

# Create Line chart Object
$FC = new FusionCharts("MSLine","600","400");

# set the relative path of the swf file
$FC->setSWFPath("./dl/chart/FusionCharts/");

# (skipping addition of param setting code and addition of data, it's working as the chart renders)

$xml = $FC->getXML();

# Render Chart
$FC->renderChart();

echo "xml : " . $xml;
[/code]

The problem is I can't see my $xml variable that I wish to echo with the php file. Is there something I'm not doing write in my call to getXML(); ?

Multi Series from complex Query

Mac — Mon, 05 May 2008 14:53:25 GMT

Hi,

I have a query that selects data from a few tables, that I'm trying to get added to a multi series chart.

Here's the query:

[code]
select qjr.qjr_response, qjq.quickjournal_question_text, qjj.quickjournal_journal_date
from quickjournal_journals as qjj
join quickjournal_questions as qjq on qjj.quickjournal_id = qjq.quickjournal_id
join quickjournal_responses as qjr on
(qjq.quickjournal_question_id = qjr.qjr_question_id and qjr.qjr_journal_id = qjj.quickjournal_journal_id)
where qjj.uid = 551
and qjj.quickjournal_journal_date >= '2005-10-08' and qjj.quickjournal_journal_date <= '2005-11-07'
and qjq.quickjournal_question_id in (1, 2, 3, 4, 5, 6, 7, 8, 11, 13, 15, 16)
order by qjq.quickjournal_question_text, qjj.quickjournal_journal_date ASC
[/code]

Here's a sample of results returned:

[code]
qjr_response quickjournal_question_text quickjournal_journal_date
6 Concentration / Focus 2005-11-01
8 Concentration / Focus 2005-11-02
192 Daily Weight (lbs) 2005-11-01
191 Daily Weight (lbs) 2005-11-02
8 Hours of sleep 2005-11-01
7 Hours of sleep 2005-11-02
8 My Mood 2005-11-01
5 My Mood 2005-11-02
6 Pain and Soreness 2005-11-01
9 Pain and Soreness 2005-11-02
[/code]

And here's my code from my php file to get the information added to the LineMS chart type (multi series):

[code]
# Set Chart Data
$FC->addDatasetsFromDatabase($rs, "qjq.quickjournal_question_text", "qjr.qjr_response" );

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

All I'm getting is a chart with NaNM on the y-axis and nothing on the x-axis. Any thoughts on what I'm doing wrong?

"No Data to Display" when run on website, but it works correctly against local DB

qzgbd9 — Thu, 01 May 2008 11:24:06 GMT

Can anyone help with this?

I have a MySQL databse on my PC that is an exact replica of the one on my web hosting server. Before uploading the files I tested everything against the local database and the charts display correctly. When I move the files to the web server and run the application, the charts don't display. I get "No Data to Display".

I'm using the dataURL method with PHP Class.

I've set the permissions on the files to 755 (owner can read, write and execute,the world can read and execute). The files all exist in the correct paths.

I've checked that DBConn.php has the correct information for host, user, password and database.

I've tried running the sql against the remote database and it produces the data I'm expecting.

What am I doing wrong?

couldn't you make changes to you code that you have provided in particualr thread.

maheshshinde9 — Tue, 29 Apr 2008 02:58:22 GMT

Suggestion that you have made( could you please download the FusionWidgets Blueprint Application code and refer to function buildXMLMonthlyRev() in DataGen.php) contains following code:

$MonthArray=array();
while($oRs=mysql_fetch_array($result)){
$MonthArray[$oRs['Month']]=$oRs['TotalSales'];

}
// we again retireve the monthly revenue value form array and create set XML elements for each month
for($i=1;$i<=12;$i++){
$strXML .= "<set value='" . $MonthArray[$i] . "' />";
}

Instead of $strXML I have used $strCat .

Means you have used for loop out of while loop.

In our categorywise sales example, you have used mysql_data_seek() function. I made

changes to the my code as per above code. But because of this for loop( which out of while loop) it does not display proper labels (means month labels) & I think this is because of

we are using mysql_data_seek($resultCat) . Could'nt you make changes to the your code?

(even though As my need is a bit different from the original design you had)

can we show month also which dont have data?

maheshshinde9 — Tue, 29 Apr 2008 01:10:41 GMT

can we show absent months also? Means In above bar chart January ,september, oct, dec.months dont have data thats why they are absent but I want there labels there.(same code that you have posted in particular thread).

can you solve this problem?

maheshshinde9 — Mon, 28 Apr 2008 06:55:09 GMT

I have set the following code to display 0 for particular bar (same code that you have posted to particular thread)

while($arrCat[$mc++]<$ors{'months1'])

{

$strDataXML .="<set value='0.00001'/>";

}

No I want following solution for the pervious question?

maheshshinde9 — Mon, 28 Apr 2008 02:52:55 GMT

I want 0 (zero) as shown above, means when there is no data present I want to show zero there. e.g. In picture for february month there is no data for other categories except for produce category. I want to show 0 (zero) as shown above for other category. Also I want to show 0 (zero) for month which dont have any data. e.g. I have shown March month.

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 .

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

maheshshinde9 — Sat, 26 Apr 2008 03:42:22 GMT

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

zero (0) on top .

problem with example that you have given in FusionCharts Blueprint Application - PHP + MySQL version

maheshshinde9 — Fri, 25 Apr 2008 03:37:18 GMT

got some problem with example you have given free php & mysql sample.(FusionCharts Blueprint Application - PHP + MySQL version)

This error contains in sales by category page (i.e. multiseries example).(pages that contains data to show multiseries charts are Data_SalesByCategory.php,Default.php & DataGen.php)

I have changed tables fc_orders, fc_orderdetails & fc_products as follows.

I have changed orderdate to 2/5/1994 for orderid 10249 in fc_orders table. In fc_orderdetails table orderid 10249 contains two productid 14 & 51. In fc_products table , productid 14's category id is 7 & productid 51's category id is 7.

Means bar chart should show Feb(means second month) data. But it does not show that data.

Because you have set flag $catXMLDone for only first product 'Beverages'. Can you find the solution

have you got my previous question?

maheshshinde9 — Fri, 25 Apr 2008 05:58:45 GMT

have you got my previous question? send me reply....I am waiting....

problem with example that you have given in FusionCharts Blueprint Application - PHP + MySQL version

maheshshinde9 — Fri, 25 Apr 2008 05:40:04 GMT

got some problem with example you have given free php & mysql sample.(FusionCharts Blueprint Application - PHP + MySQL version)

This error contains in sales by category page (i.e. multiseries example).(pages that contains data to show multiseries charts are Data_SalesByCategory.php,Default.php & DataGen.php)

I have changed tables fc_orders, fc_orderdetails & fc_products as follows.

Means bar chart should show Feb(means second month) data. But it does not show that data.

Because you have set flag $catXMLDone for only first product 'Beverages'. Can you find the solution

problem with example that you have given in free php & mysql

maheshshinde9 — Fri, 25 Apr 2008 02:46:46 GMT

I got some problem with example you have given free php & mysql sample.

This error contains in sales by category page (i.e. multiseries example).

I have changed tables fc_orders, fc_orderdetails & fc_products as follows.

Means bar chart should show Feb(means second month) data. But it does not show that data.

Because you have set flag $catXMLDone for only first product 'Beverages'. Can you find the solution & tell me what correction should I make?

Please reply me for the following question that I have posted!!!!!!!

maheshshinde9 — Fri, 25 Apr 2008 08:54:16 GMT

Reply me!!!!!!!!!!

problem with example you have given in free php & mysql

maheshshinde9 — Fri, 25 Apr 2008 01:59:51 GMT

I got some problem with example you have given free php & mysql sample.

This error contains in sales by category page (i.e. multiseries example).

I have changed tables fc_orders, fc_orderdetails & fc_products as follows.

Means bar chart should show Feb(means second month) data. But it does not show that data.

Because you have set flag $catXMLDone for only first product 'Beverages'. Can you find the solution & tell me what correction should I make?

problem with multiseries bar chart in php with mysql as database

maheshshinde9 — Thu, 24 Apr 2008 00:50:12 GMT

Above bar chart does not display data according to query result. According to your suggestion I have checked xml file, according to that xml file it shows correct output.

But my problem is with the flag that I am using for setting the day label( means 9,11,12 in above example).Above bar chart should show day 4 before 9 & one bar of orange color on that day.But it shows that on day '9' instead of day '4'. This is happening because

of flag that I have used for setting day label( I am using the flag $catXMLDone that you have used in php & mysql free example multiseries example i.e. get sales by product bar chart). I am giving the following php code. can you tell me the solution?

$strXML = "<graph caption='Factory Output ' subcaption='(In Units)' xAxisName='Date' formatNumberScale='0' decimalPrecision='0' palette='" . getPalette() . "' >";

//To store categories - also flag to check whether category is already generated
$catXMLDone = false;
//Initialize XML elements
$strCat = "<categories>";

//First we need to get product type id from the database
$strSQL = "SELECT DISTINCT(p.product_type_id) as ids FROM products as p WHERE p.product_type_id >='3' GROUP BY ids ";

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

//To store datasets and sets
$strDataXML = "";

if ($result)
{

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

//Add this category as dataset
$strDataXML .= "<dataset seriesName='".$orsCat['ids']."' color='".getFCColor()."' >";

$strSQL = "SELECT COUNT(oi.product_id) as Total, Day(o.order_complete) as days, p.product_type_id as typeid FROM order_items as oi, orders as o,products as p WHERE p.product_type_id = '".$orsCat['ids']."' AND p.product_id = oi.product_id AND o.order_complete >= '2008-4-4 00:00:00' AND o.order_complete <= '2008-4-12 00:00:00' AND o.order_id = oi.order_id GROUP BY days";
//Execute it
$result2 = mysql_query($strSQL) or die(mysql_error());
while($ors = mysql_fetch_array($result2))
{

//Append <category label=''> if not already done

if (!$catXMLDone)
{
$strCat .= "<category name='" .$ors['days']. "' />";

}
//Append data
$strDataXML .= "<set value='" . $ors['Total'] . "'/>";
}
//Update flag that we've appended categories
$catXMLDone = true;
//Clear up objects
mysql_free_result($result2);
//Close dataset element
$strDataXML .= "</dataset>";
}
}

//Close </categories>
$strCat .= "</categories>";
//Create full XML
$strXML .= $strCat.$strDataXML;

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

//Create the chart - Column 2D Chart with data from strXML
echo renderChart("FusionCharts/FCF_MSColumn3D.swf", "", $strXML, "FactoryDetailed", 600, 300, false, false);

problem with multiseries bar chart in php with mysql as database

maheshshinde9 — Thu, 24 Apr 2008 01:49:28 GMT

Above bar chart does not display data according to query result. According to your suggestion I have checked xml file, according to that xml file it shows correct output.

//Close </categories>
$strCat .= "</categories>";
//Create full XML
$strXML .= $strCat.$strDataXML;

did you get my previous question?

maheshshinde9 — Thu, 24 Apr 2008 02:35:44 GMT

Please reply to my previous question?

multiseries bar chart with php. Reply me!!!!

maheshshinde9 — Thu, 24 Apr 2008 04:40:28 GMT

Reply me please!!!!!!!!!!!!

Above bar chart does not display data according to query result. According to your suggestion I have checked xml file, according to that xml file it shows correct output.

//Close </categories>
$strCat .= "</categories>";
//Create full XML
$strXML .= $strCat.$strDataXML;

how to connect with mysql database and fusionchart with php?

tharsoe — Wed, 23 Apr 2008 23:20:01 GMT

i am a beginner.
pls tell me how to connect with mysql database and fusionchart with php.
my email is tharsoe@gmail.com.

multiseries bar chart with php

maheshshinde9 — Wed, 23 Apr 2008 06:49:10 GMT

Above image displayed does not show proper data .

June (i.e Jun in graph) month should not contains orange bar. It should be present in Jul

month. Why this is happening? It shows proper data up to May Month.

I am giving my php code below.

$strXML = "<graph caption='Passport' subcaption='(In Units)' xAxisName='Date' yAxisName='Quantity' formatNumberScale='0' decimalPrecision='0'>";

//To store categories - also flag to check whether category is
//already generated
$catXMLDone = false;
//Initialize XML elements
$strCat = "<categories>";

//First we need to get product type id(categories)

$strSQL = "SELECT DISTINCT(pt.product_type_id) as ids, pt.product_type_desc as description FROM product_type as pt, products as p WHERE pt.product_type_id >='3' AND p.product_type_id = pt.product_type_id ";

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

//To store datasets and sets
$strDataXML = "";

if ($result)
{
while($orsCat = mysql_fetch_array($result))
{
//Add this category as dataset
$strDataXML .= "<dataset seriesName='".$orsCat['description']."' color='". getFCColor() ."'>";

//Now, we get the data for that factory
$strSQL = "SELECT COUNT(oi.product_id) as Total, Month(o.order_complete) as months1 ,Year(o.order_complete) as years FROM order_items as oi, orders as o,products as p WHERE p.product_type_id = '".$orsCat['ids']."' AND p.product_id = oi.product_id AND Year(o.order_complete)='2008' AND o.order_id = oi.order_id AND oi.status_id <='6' GROUP BY months1";
//Execute it
$result2 = mysql_query($strSQL) or die(mysql_error());
while($ors = mysql_fetch_array($result2))
{

//Append <category label=''> if not already done
if (!$catXMLDone)
{
$strCat .= "<category name='" . MonthName($ors['months1'],true). "'/>";

}

//Append data
$strDataXML .= "<set value='" . $ors['Total'] . "'/>";

}
//Update flag that we've appended categories
$catXMLDone = true;
//Clear up objects
mysql_free_result($result2);
//Close dataset element
$strDataXML .= "</dataset>";
}
}
//Close </categories>
$strCat .= "</categories>";
//Create full XML
$strXML .= $strCat.$strDataXML;

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

Multiseries barchart in php with mysql database (problem with bar chart )

maheshshinde9 — Wed, 23 Apr 2008 05:44:20 GMT

Above image displayed does not show proper data .

June (i.e Jun in graph) month should not contains orange bar. It should be present in Jul

month. Why this is happening? It shows proper data up to May Month.

I am giving my php code below.

$strXML = "<graph caption='Passport' subcaption='(In Units)' xAxisName='Date' yAxisName='Quantity' formatNumberScale='0' decimalPrecision='0'>";

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

//To store datasets and sets
$strDataXML = "";

if ($result)
{
while($orsCat = mysql_fetch_array($result))
{
//Add this category as dataset
$strDataXML .= "<dataset seriesName='".$orsCat['description']."' color='". getFCColor() ."'>";

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

can we set height & width of individual bar in bar chart in multiseries example

maheshshinde9 — Mon, 21 Apr 2008 05:32:40 GMT

I am using php & mysql. I have prepared multiseries bar chart using mysql database.

How can we set the height & width of individual bar in bar chart ? does set element provide any attribute for that?

Using array - how to add hyperlink?

Millsey — Tue, 08 Apr 2008 17:09:59 GMT

When generating an array to use with addchartdatafromarray function, where do I put the link to another page/chart?

$twoweeksago = strtotime("15 days ago");
$i=0;
$nowie = strtotime("now");

//echo date("d/m/Y",$twoweeksago);
//echo date("d/m/Y",$nowie);
// set up categoriy names and blank the data array
while($twoweeksago<$nowie) {

$fcatnames[$i]=date("d M", $twoweeksago);
$qstart=date("Y/m/d 00:00:00", $twoweeksago);
$qend=date("Y/m/d 23:59:59", $twoweeksago);
$twoweeksago+=86400;
$fcatdata[0][$i+2]=0;
$query = "SELECT sum(minutes) as minns from time_rec where who_inits = '".$who."' and date_posted > '".$qstart."' and date_posted < '".$qend."'";
$qry = mysql_query($query, $conn) or die(mysql_error());
$rows = mysql_fetch_array($qry);
$fcatdata[1][$i+2]=$rows[0]/6;
$i++;}

$FCa->addChartDatafromArray($fcatdata,$fcatnames);
$FCa->renderChart();

</SNIPPET>

Where within the array do I put the link url?

Thanks

Millsey

how to give different colour to bar chart in multiseries format

maheshshinde9 — Thu, 17 Apr 2008 08:26:45 GMT

how to give different colour in multiseries format in php with mysql as database.I am using free fusioncharts version means fusioncharts free

can we compare user date input with databae containing date column

maheshshinde9 — Tue, 22 Apr 2008 08:03:42 GMT

I want to compare date user input with date column in database. But that date column contains date in the following format 2008/4/2 means date contains '/'.

Then in this case does php code give the valid bar chart. Because date contains '/' special character.

multiseries bar chart with php & mysql database

maheshshinde9 — Tue, 22 Apr 2008 07:12:59 GMT

Following is the php code that I am using. Following example gives the multiseries bar chart according to selected start date & end date. But suppose I have given $start_date='2008-4-1' & $end_date = '2008-4-12' then following example gives the output (means bar) only for few dates between $start_date & $end_date. But following queries runs fine in database & gives correct output. But bar chart does not gives all records of queries. Tell me the

solution?

$strXML = "<graph caption='Passport And Visa Sales' subcaption='(In Units)' xAxisName='Date' yAxisName = 'Quantity' formatNumberScale='0' decimalPrecision='0'>"

//To store categories - also flag to check whether category is
//already generated
$catXMLDone = false;
//Initialize XML elements
$strCat = "<categories>";

//First we need to get product type id (categories)

$strSQL = "SELECT DISTINCT(p.product_type_id) as ids, pt.product_type_desc as description FROM products as p, product_type as pt WHERE p.product_type_id >2 AND p.product_type_id = pt.product_type_id ";

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

//To store datasets and sets
$strDataXML = "";

if ($result)
{
while($orsCat = mysql_fetch_array($result))
{

//Add this category as dataset
$strDataXML .= "<dataset seriesName='".$orsCat['description']."' color='". getFCColor() ."'>";

//Now, we get the data for that passport & visa counts
$strSQL = "SELECT SUM(Total) as output, days FROM(SELECT COUNT(oi.product_id) as Total, Day(o.order_complete) as days FROM order_items as oi, orders as o,products as p WHERE p.product_type_id = '".$orsCat['ids']."' AND p.product_id = oi.product_id AND o.order_complete >='$start_date' AND o.order_complete <='$end_date' AND o.order_id = oi.order_id AND oi.status_id <='6' GROUP BY days ORDER BY Total) as chart GROUP BY days ";

$result2 = mysql_query($strSQL) or die(mysql_error());
while($ors = mysql_fetch_array($result2))
{
//Append <category label=''> if not already done
if (!$catXMLDone)

{
$strCat .= "<category name='" .$ors['days']. "' />";

}
//Append data
$strDataXML .= "<set value='" . $ors['output'] . "' />";
}
//Update flag that we've appended categories
$catXMLDone = true;
//Clear up objects
mysql_free_result($result2);
//Close dataset element
$strDataXML .= "</dataset>";

}
}
// mysql_close($link);

//Close </categories>
$strCat .= "</categories>";
//Create full XML
$strXML .= $strCat.$strDataXML;

//Return
//return $strXML;

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

how to set width & height of individual bar in bar chart

maheshshinde9 — Tue, 22 Apr 2008 02:15:27 GMT

I am using php & mysql. I have prepared multiseries bar chart using mysql database.

How can we set the height & width of individual bar in bar chart ? does set element provide any attribute for that?

Fatal error:Call to undefined function getFCColor()

qzgbd9 — Wed, 16 Apr 2008 13:50:19 GMT

I am new to FusionCharts. I'm working through the examples but when I try anything under PHP/BasicExamples instead of seeing the chart I see the error above. I have checked that the path to FC_Color.php and FC_Color.asp is correct. (I tested it by adding an echo statement to FusionCharts.php which is in the same directory. That statement displays when I point my browser to SingleSeries.htm). I have also tried copying FC_COLOR.php and FC_Color.asp to the same directory where SingleSeries.php sits and changing the include statement so that it only references the file and not the path. I've done this separately for both the asp and the php versions on FC_Color. It makes no difference. Has anyone else seen this issue? Can anyone help to to debug this? Thanks in advance for any insights you can share.

Change Currency Symbol

shasto100 — Mon, 21 Apr 2008 10:14:00 GMT

Hi guys, I just want to 1st say thanks for this great product, this sales me a great deal of time & effort! :)

Right, I'm trying to change the $ (dollar) symbol to a £ (uk pound) symbol in the output. Any help would be greatly appreciated, I've tried searching on the forums & in the documentation but to no avail.

Cheers.

Make correction to your following file FC_Colors.php

maheshshinde9 — Mon, 21 Apr 2008 02:37:47 GMT

You forgot to add keyword php on first line of file FC_Colors.php.

i.e. tag <?php ?>

That's why most of fusioncharts users get error of undefined function getFCColor().

where to give set element for color attribute of bar chart

maheshshinde9 — Mon, 21 Apr 2008 00:32:22 GMT

Following is the example of multiseries bar chart.That contains two series(two bars).

I want to give two different colors for that two bars.

I am preparing bar chart in php with mysql as database. Following is the php code

tell me where to give colour attribute in following code OR tell me which file to include?

$strXML = "<graph caption='Factory Output ' subcaption='(In Units)' xAxisName='Date' formatNumberScale='0' decimalPrecision='0' >";

// Connet to the DB

//To store categories - also flag to check whether category is already generated
$catXMLDone = false;
//Initialize XML elements
$strCat = "<categories>";

//First we need to get unique categories in the database
$strSQL = "SELECT DISTINCT(p.product_type_id) as ids, Year(o.order_complete) as years FROM
order_items as oi, orders as o,products as p WHERE p.product_type_id >2 AND p.product_id = oi.product_id AND Year(o.order_complete) ='2008' AND o.order_id = oi.order_id GROUP BY oi.product_id";

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

//To store datasets and sets
$strDataXML = "";

if ($result)
{
while($orsCat = mysql_fetch_array($result))
{
//Add this category as dataset
$strDataXML .= "<dataset seriesName='".$orsCat['ids']."'>";

//Now, we get the data for that factory
$strSQL = "SELECT SUM(Total) as output,months1, years FROM(SELECT COUNT(oi.product_id) as Total, Month(o.order_complete) as months1 ,Year(o.order_complete) as years FROM order_items as oi, orders as o,products as p WHERE p.product_type_id = '".$orsCat['ids']."' AND p.product_id = oi.product_id AND Year(o.order_complete)='".$orsCat['years']."' AND o.order_id = oi.order_id GROUP BY months1) as chart GROUP BY months1";
//Execute it
$result2 = mysql_query($strSQL) or die(mysql_error());
while($ors = mysql_fetch_array($result2))
{
//Append <category label=''> if not already done
if (!$catXMLDone)
{
$strCat .= "<category name='" .$ors['months1']. "' />";
}
//Append data
$strDataXML .= "<set value='" . $ors['output'] . "' />";
}
//Update flag that we've appended categories
$catXMLDone = true;
//Clear up objects
mysql_free_result($result2);
//Close dataset element
$strDataXML .= "</dataset>";
}
}
// mysql_close($link);

//Close </categories>
$strCat .= "</categories>";
//Create full XML
$strXML .= $strCat.$strDataXML;

//Return
//return $strXML;

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

how to give different color for individual bar in multiseries bar chart.

maheshshinde9 — Mon, 21 Apr 2008 01:48:56 GMT

Following is the example of multiseries bar chart.That contains two series(two bars).

I want to give two different colors for that two bars.

I am preparing bar chart in php with mysql as database. Following is the php code

tell me where to give colour attribute in following code OR tell me which file to include?

$strXML = "<graph caption='Factory Output ' subcaption='(In Units)' xAxisName='Date' formatNumberScale='0' decimalPrecision='0' >";

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

//To store datasets and sets
$strDataXML = "";

if ($result)
{
while($orsCat = mysql_fetch_array($result))
{
//Add this category as dataset
$strDataXML .= "<dataset seriesName='".$orsCat['ids']."'>";

//Close </categories>
$strCat .= "</categories>";
//Create full XML
$strXML .= $strCat.$strDataXML;

//Return
//return $strXML;

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

how to give colour to barchart in multiseries format

maheshshinde9 — Fri, 18 Apr 2008 04:39:05 GMT

I am preparing bar chart in php with mysql as database. Following is the php code

tell me where to give colour attribute in following code OR tell me which file to include?

$strXML = "<graph caption='Factory Output ' subcaption='(In Units)' xAxisName='Date' formatNumberScale='0' decimalPrecision='0' >";

// Connet to the DB

//To store categories - also flag to check whether category is
//already generated
$catXMLDone = false;
//Initialize XML elements
$strCat = "<categories>";

//First we need to get unique categories in the database
$strSQL = "SELECT DISTINCT(p.product_type_id) as ids, Year(o.order_complete) as years FROM
order_items as oi, orders as o,products as p WHERE p.product_type_id >2 AND p.product_id = oi.product_id AND Year(o.order_complete) ='2008' AND o.order_id = oi.order_id GROUP BY oi.product_id";

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

//To store datasets and sets
$strDataXML = "";

if ($result)
{
while($orsCat = mysql_fetch_array($result))
{
//Add this category as dataset
$strDataXML .= "<dataset seriesName='".$orsCat['ids']."' color ='3300FF'>";

//Close </categories>
$strCat .= "</categories>";
//Create full XML
$strXML .= $strCat.$strDataXML;

//Return
//return $strXML;

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

multiseries bar chart with mysql as database in php

maheshshinde9 — Thu, 17 Apr 2008 01:54:21 GMT

//following is php code .but does not give any output.

first query give the following data through database

ids

second query give following data through database for ids=1

Total month product_id
1 2 1

2 3 1

3 4 1

same data come for ids =2 & ids=3 with same values of month & different Total

but following php code does not give any output

<?php
//Generate the graph element string
$strXML = "<chart caption='Factory Output ' subcaption='(In Units)' xAxisName='Date' formatNumberScale='0' decimalPrecision='0'>";

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

//To store categories - also flag to check whether category is
//already generated
$catXMLDone = false;
//Initialize XML elements
$strCat = "<categories>";

//First we need to get unique categories in the database
$strSQL = "Select product_id as ids from products where product_id <='3' ORDER BY product_id";
$result = mysql_query($strSQL) or die(mysql_error());

//To store datasets and sets
$strDataXML = "";

if ($result)
{
while($orsCat = mysql_fetch_array($result))
{
//Add this category as dataset
$strDataXML .= "<dataset seriesName='" .$orsCat['ids']. "'>";

//Now, we get the data for that factory
$strSQL = "SELECT count(oi.product_id) as Total, Month(o.order_complete) as month, oi.product_id FROM order_items as oi, orders as o,products as p WHERE oi.product_id='".$orsCat['ids']."' AND p.product_id = oi.product_id AND o.order_id = oi.order_id GROUP BY Month(o.order_complete) ";
//Execute it
$result2 = mysql_query($strSQL) or die(mysql_error());
while($ors = mysql_fetch_array($result2))
{
//Append <category label=''> if not already done
if (!$catXMLDone)
{
$strCat .= "<category label='" .$ors['month'] . "' />";
}
//Append data
$strDataXML .= "<set value='" . $ors['Total'] . "' />";
}
//Update flag that we've appended categories
$catXMLDone = true;
//Clear up objects
mysql_free_result($result2);
//Close dataset element
$strDataXML .= "</dataset>";
}
}
mysql_close($link);

//Close </categories>
$strCat .= "</categories>";
//Create full XML
$strXML = $strCat . $strDataXML;

//Return
return $strXML;

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

//Create the chart - Column 2D Chart with data from strXML
echo renderChart("FusionCharts/FCF_MSColumn3D.swf", "", $strXML, "FactoryDetailed", 600, 300, false, false);
?>

simple bar chart with mysql as database

maheshshinde9 — Wed, 16 Apr 2008 08:34:35 GMT

this is php code i am using.

This example works with pie chart but not with bar chart. I tried to use different chart

in renderchart sentense .but it did not work .I used order by clause in sql sentense then also it didnot work. give me solution.

<?php
$link = connectToDB();

$strXML = "<chart palette='2' caption='Factory Output ' subcaption='(In Units)' xAxisName='Date' showValues='1' labelStep='2' >";

$strQuery = "SELECT count(o.product_id) as Total, p.product_short_desc, p.product_desc, o.product_id FROM products as p, order_items as o WHERE p.product_type_id='3' AND p.product_id=o.product_id GROUP BY p.product_short_desc";
$result = mysql_query($strQuery) or die(mysql_error());

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

$strXML .= "<set label='" . $ors['product_short_desc'] . "' value='" . $ors['Total'] . "' />";

}
}

mysql_close($link);

//Finally, close <graph> element
$strXML .= "</chart>";

//Create the chart with data from $strXML
echo renderChart("FusionCharts/FCF_Bar2D.swf", "", $strXML, "FactoryDetailed", 600, 300, false, false);

?>

Gantt Chart display categories in time rather than date

zhxcookie — Fri, 04 Apr 2008 00:55:05 GMT

Hi, I am using FusionCharts Free version and PHP. I am constructing a Gantt Chart, I would like to display the category in "time" rather than "day". Like for normal Gantt Chart, the category is like [b][i]category start="1/1/2005" end="31/1/2005" name="January"[/i][/b]

Is that possible I can put the start and end as a time? For example [i][b]category start="08:00:00" end="09:00:00" name="8 - 9 am"[/b][/i]

Thanks in advance :) :w00t: