Developing (v7+)

Problem rendering FUSIONCHART

Permalink June 02, 2013 at 10:26 AM

Hi

I'm using fusioncharts to render some mysql data.
I've installed the PHP block addon in concrete to code it.
Everything works in EDIT MODE, chart renders etc ..., but once i exit edit mode the url changes when i click my page stats and redering the chart doesn't work anymore ??

Somebody any idea? Thanks

Fusionchart is using PHP and JAVASCRIPT to render some swf file ...

I've got some (bad/no error handling and messy)code and some pictures attached:

$url="https://blubblubblub.blub";
$con=mysql_connect("localhost","root","blub") or die("Failed to connect to DB");
mysql_select_db("blub", $con);
///////////////////////////////////////////////////////////////////////
///START PHP FUNCTION CREATION TO DETERMINE VARIABLES NEEDED FOR DB///
$parsed = parse_url($url);
function GetName($myName){
foreach($myName as $key => $value){
 if(strcmp($key, "path") == False){
  $myName = $value;
  return (string)$myName; 
 }
}
}
$name = GetName($parsed); ///call function with parsed url var//

Viewing 15 lines of 64 lines. View entire code block.

 
$url="https://blubblubblub.blub";
 
$con=mysql_connect("localhost","root","blub") or die("Failed to connect to DB");
 
mysql_select_db("blub", $con);
 
///////////////////////////////////////////////////////////////////////
///START PHP FUNCTION CREATION TO DETERMINE VARIABLES NEEDED FOR DB///
 
$parsed = parse_url($url);
 
 
function GetName($myName){
 
foreach($myName as $key => $value){
 if(strcmp($key, "path") == False){
  $myName = $value;
  return (string)$myName; 
 }
}
}
 
$name = GetName($parsed); ///call function with parsed url var//
 
function GetValue($url){
 
$content = file_get_contents($url);
$valu = json_decode($content);
 
foreach($valu as $kk => $vv){
 // print "KEY:: $kk and VALUE:: $vv <br/>";
  if(strcmp($kk, "value") == False){
   $myValue = $vv;
//   print "$myValue <br/>";
   return (float)$myValue;
 }
}
}
 
 
$value = GetValue($url); ///////////////////GETVALUE////////////////
 
 
//////////////////FUNCTION CREATION DONE ///////////////
/////////////////////////////////////////////////////////////////
 
 
$query = "insert into chart(name,value,date) values('$name',$value,curdate())";
 
$r = mysql_query($query);
 
$delDups = "delete from chart where id not in (select * from (select min(id) from chart n group by value) x)";
 
mysql_query($delDups);
 
 
$queryDate = "select date from chart where id=(select max(id) from chart)";
$myDate = mysql_query($queryDate);
 
 
function sqlDate($z){
$d = mysql_fetch_array($z, MYSQL_NUM);
foreach($d as $key => $value){
return (string)$value;
}
}
 
$tmpdate= sqlDate($myDate);
(string)$tmp2="$tmpdate";
 
 
$queryAll = "select value, date from chart where id<=(select max(id) from chart) limit 10";
 
$dateValue = mysql_query($queryAll);
 
 
 
?>
 
 
<?php
include("FusionCharts/scripts/FusionCharts_Gen.php");
 ?>
<SCRIPT LANGUAGE="Javascript" SRC="FusionCharts/scripts/FusionCharts.js"></SCRIPT>
<?php
 
  $FC = new FusionCharts("Column3d","600","300","",True);
 
  $FC->setSwfPath("FusionCharts/FusionCharts/");
 
  $strParam="caption=No TITLE ;xAxisName=Month;yAxisName=Volume;decimalPrecision=2; formatNumberScale=0";
 
  $FC->setChartParams($strParam);
 
while($row = mysql_fetch_array($dateValue,MYSQL_ASSOC)){
 
  $key = array_shift($row);
  $value = array_shift($row);
 
  $FC->addChartData($key,"name=$value");
}
 
 
  $FC->renderChart();
 
  $FC->setOffChartCaching(true);
 
?>