Svenska ElektronikForumet

Kod: Markera allt

<?php
include ("src/jpgraph.php");
include ("src/jpgraph_line.php");

//Get data
$username="***";
$password="***";
$database="HomeData";
$dateNow=date('Y-m-d');

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

//Get total number of records
$query="select count(*) from lightvalues";
$result=mysql_query($query);
$rowsTotal=mysql_result($result,0);

//Last values
$offset=$rowsTotal-96;

$query="SELECT * FROM lightvalues order by id asc LIMIT 100 OFFSET $offset";

$result=mysql_query($query);
$num=mysql_numrows($result);

mysql_close();

$i=0;
$ydata = array();
$datax = array();
while ($i < $num) {

        $sensor1=mysql_result($result,$i,"sensor1");
        $sensor2=mysql_result($result,$i,"sensor2");
        $sensor3=mysql_result($result,$i,"sensor3");
        $sensor4=mysql_result($result,$i,"sensor4");
        $sensor5=mysql_result($result,$i,"sensor5");
        $time=mysql_result($result,$i,"time");
        $date=mysql_result($result,$i,"date");
        $ydata1[$i] = $sensor1*20;
        $ydata2[$i] = $sensor2;
        $ydata5[$i] = $sensor5*20;

        $temp=$sensor3;
        $ydata3[$i]=str_replace(",",".",$temp);

        $temp=$sensor4;
        $ydata4[$i]=str_replace(",",".",$temp);

        $datax[$i] = $time;
        //echo "$sensor1 $sensor2 $sensor3 $sensor4<br>";

        $i++;
}

// Create the graph. These two calls are always required
$graph = new Graph(1000,600,"auto");
//X&Y linear scale
$graph->SetScale("linlin");
//$graph-> SetScale( "textlin",0,115 );

//Add a second Y-scale
//$graph->SetY2Scale("int",0,115);

// Adjust the margin
$graph->img->SetMargin(40,180,20,40);

// Create the linear plot
$lineplot=new LinePlot($ydata1);
$lineplot->SetColor("blue");

$lineplot2=new LinePlot($ydata2);
$lineplot2->SetColor("red");

$lineplot3=new LinePlot($ydata3);
$lineplot3->SetColor("green");

$lineplot4=new LinePlot($ydata4);
$lineplot4->SetColor("brown");

$lineplot5=new LinePlot($ydata5);
$lineplot5->SetColor("cyan");

// Add the plot to the graph
$graph->Add($lineplot);
$graph->Add($lineplot2);
$graph->Add($lineplot3);
$graph->Add($lineplot4);
$graph->Add($lineplot5);
//$graph->AddY2($lineplot4);

//Legends
$lineplot->SetLegend ("Light outdoor");
$lineplot2->SetLegend ("Outdoor temp");
$lineplot3->SetLegend ("Indoor temp");
$lineplot4->SetLegend ("Air pressure");
$lineplot5->SetLegend ("Light indoor");

// Adjust the legend position
$graph->legend->Pos(0.05,0.5,"right","center");

//Grid lines
$graph->ygrid->Show (true,true);

$graph->xaxis->SetTickLabels($datax);
$graph->xaxis->SetTextTickInterval(5);

$graph->SetTickDensity(TICKD_DENSE,TICKD_NORMAL); // Many Y-ticks


//Title
$graph->title->SetMargin (20);
$graph->tabtitle->Set ( $date );

// Display the graph
$graph->Stroke();

?>