Finalmente dopo innumerevoli testate
Chi la dura la vince, sempre !!!
Codice PHP:
//----------------------------------- INIZIO CODICE AGGIUNTO
$query="SELECT
categoria AS CAT,
COUNT( campo1 ) AS T,
COUNT( campo2 ) AS P
FROM tabella
GROUP BY categoria";
$select=mysql_query($query) or die("Query fallita".mysql_error());
$arrData = array();
while ($row = mysql_fetch_assoc($select))
{
$arrData[] = $row;
}
//---------------------------------- FINE CODICE AGGIUNTO
//Initialize <graph> element
$strXML = "<graph caption='Sales by Product' numberPrefix='$' formatNumberScale='1' rotateValues='1' decimalPrecision='0' >";
//Initialize <categories> element - necessary to generate a multi-series chart
$strCategories = "<categories>";
//Initiate <dataset> elements
$strDataCurr = "<dataset seriesName='Current Year' color='AFD8F8'>";
$strDataPrev = "<dataset seriesName='Previous Year' color='F6BD0F'>";
//Iterate through the data
foreach ($arrData as $arSubData)
{
//Append <category name='...' /> to strCategories
$strCategories .= "<category name='" . $arSubData['CAT'] . "' />";
//Add <set value='...' /> to both the datasets
$strDataCurr .= "<set value='" . $arSubData['T'] . "' />";
$strDataPrev .= "<set value='" . $arSubData['P'] . "' />";
}
//Close <categories> element
$strCategories .= "</categories>";
//Close <dataset> elements
$strDataCurr .= "</dataset>";
$strDataPrev .= "</dataset>";
//Assemble the entire XML now
$strXML .= $strCategories . $strDataCurr . $strDataPrev . "</graph>";
//Create the chart - MS Column 3D Chart with data contained in strXML
echo renderChart("charts/swf/MSColumn3D.swf", "", $strXML, "productSales", 600, 300);
?>
Rispondi quotando