Search code examples
phppchart

Pchart prints double values on X-axis


Be gentle..

Using the code below for printing a chart using pchart on a RPI results in the values double printed on the X-axis.

My preferred outcome would be single x axis values slightly rotated but whatever I change in the code below it does not give the good result.

Help would be appreciated!

Maurice

<?php

ini_set('display_errors', 'On');
error_reporting(E_ALL | E_STRICT);

include("class/pDraw.class.php");
include("class/pImage.class.php");
include("class/pData.class.php");

$db = new PDO("sqlite:/home/pi/sensor.db");

$MyData = new pData();  

$tijd=""; 
$lucht="";

$result = $db->query('SELECT tijd, lucht FROM waarden WHERE lucht  > 40');
foreach($result as $row)
{
  $tijd[]   = $row["tijd"];
  $lucht[] = $row["lucht"];
}

$MyData->addPoints($lucht,"lucht");
$MyData->setSerieOnAxis("lucht", 0);
$MyData->setAxisName(0,"lucht");
$MyData->setAxisUnit(0,"%");

$MyData->addPoints($tijd,"tijd");
$MyData->setSerieDescription("tijd","Tijden");
$MyData->setAbscissa("tijd");

$myPicture = new pImage(800,330,$MyData);
$myPicture->setFontProperties(array("FontName"=>"fonts/Forgotte.ttf","FontSize"=>11));
$myPicture->setGraphArea(60,40,740,290);
$myPicture->drawScale(array("AutoAxisLabels"=>FALSE,"RemoveXAxis"=>FALSE)); 
$myPicture->drawLineChart();

//rotate the xaxis values 
$myPicture->drawScale(array("DrawSubTicks"=>False, "LabelRotation"=>20));

$myPicture->autoOutput("mypic.png");
$db = null;
?>

enter image description here


Solution

  • Found my own error.

    It seems that my double instruction

    $myPicture->drawScale(array("
    

    in the initialization at the and isn't handled too well and results in a double Xaxis label

    The correct code:

    <?php
    
    ini_set('display_errors', 'On');
    error_reporting(E_ALL | E_STRICT);
    
    include("class/pDraw.class.php");
    include("class/pImage.class.php");
    include("class/pData.class.php");
    
    $db = new PDO("sqlite:/home/pi/sensor.db");
    
    $MyData = new pData();  
    
    $tijd=""; 
    $lucht="";
    
    $result = $db->query('SELECT tijd, lucht FROM waarden WHERE lucht  > 40');
    foreach($result as $row)
    {
      $tijd[]   = $row["tijd"];
      $lucht[] = $row["lucht"];
    }
    
    $MyData->addPoints($lucht,"lucht");
    $MyData->setSerieOnAxis("lucht", 0);
    $MyData->setAxisName(0,"lucht");
    $MyData->setAxisUnit(0,"%");
    
    $MyData->addPoints($tijd,"tijd");
    $MyData->setAbscissa("tijd");
    $MyData->setAbscissaName("Time of Reading");
    
    $myPicture = new pImage(800,330,$MyData);
    $myPicture->setFontProperties(array("FontName"=>"fonts/Forgotte.ttf","FontSize"=>11));
    $myPicture->setGraphArea(60,40,740,290);
    
    //Remove line below to avoid double Xaxis values
    //$myPicture->drawScale(array("AutoAxisLabels"=>FALSE,"RemoveXAxis"=>FALSE)); 
    $myPicture->drawScale(array("DrawSubTicks"=>False, "LabelRotation"=>20));
    $myPicture->drawLineChart();
    $myPicture->autoOutput("mypic.png");
    $db = null;
    ?>