Hello,
i'm trying to test how integreate data from mysql to pchart, i'v read the online documentation on this page :
http://wiki.pchart.net/doc.mysql.integration.html.
And i've all the time the same error :" Fatal error: Unsupported operand types in /home/ah35457/web/www/chart/class/pDraw.class.php on line 1851"
line 1851 = $AutoMargin = (($AxisMax-$AxisMin)/100)*$XReleasePercent;
I really dont understanding where is the error, can someone help me. Thx.
there is my code :
Code:
<?php
/* CAT:Area Chart */
/* pChart library inclusions */
include("class/pData.class.php");
include("class/pDraw.class.php");
include("class/pImage.class.php");
/* Connect to the MySQL database */
$db = mysql_connect("localhost", "turup", "pass");
mysql_select_db("turup",$db);
/* Build the query that will returns the data to graph */
$Requete = "SELECT * FROM `measures`";
$Result = mysql_query($Requete,$db);
while($row = mysql_fetch_array($Result))
{
/* Push the results of the query in an array */
$temperature[] = $row["temperature"];
$humidity[] = $row["humidity"];
}
/* Create and populate the pData object */
$MyData = new pData();
$MyData->addPoints(array($temperature),"temperature");
$MyData->addPoints(array($humidity),"humidity");
$MyData->setSerieTicks("humidity",4);
$MyData->setAxisName(0,"");
$MyData->addPoints(array("1","2","3"),"Labels");
$MyData->setSerieDescription("Labels","Months");
$MyData->setAbscissa("Labels");
/* Create the pChart object */
$myPicture = new pImage(700,230,$MyData);
/* Turn of Antialiasing */
$myPicture->Antialias = FALSE;
/* Add a border to the picture */
$myPicture->drawRectangle(0,0,699,229,array("R"=>0,"G"=>0,"B"=>0));
/* Write the chart title */
$myPicture->setFontProperties(array("FontName"=>"fonts/Forgotte.ttf","FontSize"=>11));
$myPicture->drawText(150,35,"Average temperature",array("FontSize"=>20,"Align"=>TEXT_ALIGN_BOTTOMMIDDLE));
/* Set the default font */
$myPicture->setFontProperties(array("FontName"=>"fonts/pf_arma_five.ttf","FontSize"=>6));
/* Define the chart area */
$myPicture->setGraphArea(60,40,650,200);
/* Draw the scale */
$scaleSettings = array("XMargin"=>10,"YMargin"=>10,"Floating"=>TRUE,"GridR"=>200,"GridG"=>200,"GridB"=>200,"DrawSubTicks"=>TRUE,"CycleBackground"=>TRUE);
$myPicture->drawScale($scaleSettings);
/* Write the chart legend */
$myPicture->drawLegend(540,20,array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL));
/* Turn on Antialiasing */
$myPicture->Antialias = TRUE;
/* Draw the area chart */
$myPicture->drawAreaChart();
/* Render the picture (choose the best way) */
$myPicture->autoOutput("pictures/example.drawAreaChart.simple.png");
?>