Hi!
Im testing FusionCharts v3 Trial version for php-mysql application. I find it's great - works perfectly with database and shows everything what you want in easy way - congratulations for this fantastic tool!
But I have a problem with IE browser... My charts display perfectly in Google Chrome, Mozilla and Safari (mobile devices as well) but doesnt display in Internet Explorer! It doesnt display anything, just like there wouldnt be anything.
I tried to figure out what's the problem. I noticed, that it works fine in IE without <doctype.. > statement at the begining of the page. But than my CSS styles dont work without doctype in IE... In other browsers charts work normally with or without doctype. I tried to modify doctype statement even with the simplest one <DOCTYPE HTML> but still doesnt work!
Could anyone help me? - do you know whats the problem? Is it the problem of DOCTYPE or something else?
Im using Windows 7, IE 8, FusinCharts v3 Trial
Code below:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Test Site</title>
<link href="styles.css" rel="stylesheet" type="text/css">
<link href="reset.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="js/functions.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
<body>
<?php
$query = "SELECT database1.zone, SUM(database2.column_a) as AA, SUM(database2.column_ as BB, (SUM(database2.column_a)+SUM(database2.column_) as TOTAL
FROM database1, database2
WHERE database1.id = database2.id GROUP BY database1.zone";
//FUSION CHARTS SECTION
require_once('MyFCPHPClassCharts/Class/FusionCharts_Gen.php');
require_once("MyFCPHPClassCharts/DBConn.php");
?>
<script type="text/javascript" SRC="MyFCPHPClassCharts/FusionCharts/FusionCharts.js"></SCRIPT>
<?php
$link = connectToDB();
# Create Column3D chart Object
$FC = new FusionCharts("Pie2D","900","400");
# set the relative path of the SWF file
$FC->setSWFPath("MyFCPHPClassCharts/FusionCharts/");
# Set chart attributes
$strParam="caption=test;xAxisName=x;yAxisName=y;";
$FC->setChartParams($strParam);
$result = mysql_query($query);
if ($result) {
$FC->addDataFromDatabase($result, "TOTAL");
}
mysql_close($link);
$FC->renderChart();
?>
</body>
</html>
Thanks!!
Konrad