FusionCharts Forum / FusionCharts Free / FusionCharts Free and PHP / multiseries bar chart with mysql as database in php / Latest Posts

RE: multiseries bar chart with mysql as database in php

maheshshinde9 — Thu, 17 Apr 2008 08:07:38 GMT

I got the error.

The error was on line

$strXML = $strCat.$strDataXML;

I made following change to the line

$strXML .= $strCat.$strDataXML; I place . operator after $strXML. Now it works fine

Thanks for continous reply for my each question.

RE: multiseries bar chart with mysql as database in php

Sudipto Choudhury — Thu, 17 Apr 2008 07:36:18 GMT

Hi,

Could you please attach the screenshot of the cases with the 2 charts - cFREE chart v3.

It seems that the XML is invalid which once we receive the XML would be able to say. The problem with the v3 Chart (MSColumn3D.swf) might be that the chart SWF is not present in that path and is not loading showing blank space.

Could you also make sure that you are connecting to the database and table properly?

The previous screenshot shows that the PHP file is not getting executed even. Could you please (Just for a test) try copying only the <?php ... ?> portion to another php file and add the code to generate the XML (as suggested by Arindam) and try again?

For better debugging of the XML that would be built i would suggest you to use Firefox to open the XML generating php file. Firefix generally points out the invalid portion of the XML.

RE: multiseries bar chart with mysql as database in php

maheshshinde9 — Thu, 17 Apr 2008 06:54:24 GMT

It shows following error xml page cannot be displayed.

The XML page cannot be displayed

Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

Whitespace is not allowed at this location. Error processing resource 'http://localhost/test2/passvisachart.php'. Line 1, ...

<?

RE: multiseries bar chart with mysql as database in php

Arindam — Thu, 17 Apr 2008 06:44:05 GMT

Please use this you will get XML out put and send it to me

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

//set content type as XML
header('Content-type: text/xml');
#Return the chart XML for Column 3D Chart
print $strXML;

RE: multiseries bar chart with mysql as database in php

maheshshinde9 — Thu, 17 Apr 2008 06:31:51 GMT

how to get xml output? please tell me.

RE: multiseries bar chart with mysql as database in php

Arindam — Thu, 17 Apr 2008 06:26:10 GMT

could you please send us XML output

RE: multiseries bar chart with mysql as database in php

maheshshinde9 — Thu, 17 Apr 2008 05:17:14 GMT

when I used FCF_MSColumn3D.swf instead of MSColumn3D it shows invalid xml data error &

if I use MSColumn3D.swf it doesnot show anything (blank output). Also I have removed return

xml;

RE: multiseries bar chart with mysql as database in php

maheshshinde9 — Thu, 17 Apr 2008 05:14:06 GMT

still it it showing blank output.

RE: multiseries bar chart with mysql as database in php

Arindam — Thu, 17 Apr 2008 04:56:44 GMT

Hi maheshshinde9

Could you please remove return from your code and try again?

//Return
// return $strXML; no need of that

RE: multiseries bar chart with mysql as database in php

maheshshinde9 — Thu, 17 Apr 2008 04:36:20 GMT

I have changed chart to graph. but still it is not working.

RE: multiseries bar chart with mysql as database in php

Arindam — Thu, 17 Apr 2008 04:10:01 GMT

Hi maheshshinde9
Yor are using here Free Version of FusionCharts and You using here V3 version of XML. That’s why not working. In free version root tag is <graph>. Please use free version XML. For more information please see http://www.fusioncharts.com/free/docs

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);
?>