View unanswered posts | View active topics It is currently Mon Apr 29, 2024 2:46 am



Reply to topic  [ 1 post ] 
Mysql integration Help 
Author Message
New pChart user
New pChart user

Joined: Thu Jun 21, 2012 12:16 pm
Posts: 1
Post Mysql integration Help
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");
?>


Thu Jun 21, 2012 12:21 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 1 post ] 

Who is online

Users browsing this forum: No registered users and 33 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron