<?php

            $mysqlHost     = "localhost";
            $mysqlDatabase = "pomiary";
            $mysqlUsername = "pomiary";
            $mysqlPassword = "XxxxxXxxxxX";

mysql_connect ($mysqlHost, $mysqlUsername, $mysqlPassword);
mysql_select_db ($mysqlDatabase);

$dg = date("Y-m-d H:i:s",mktime(date("H"), date("i"), date("s"), date("m"), date("d")-1, date("Y")));

$sql = mysql_query("SELECT * FROM temperatura WHERE data_godz > '$dg' ");

while($row = mysql_fetch_array($sql))
{
$data[] = $row[1];
if ($row[2] == 1) { $term[] = $row[3]; }
if ($row[2] == 2) { $term2[] = $row[3]; }
}

require_once ('jpgraph/jpgraph.php');
require_once ('jpgraph/jpgraph_line.php');
require_once ('jpgraph/jpgraph_date.php');
require_once ('jpgraph/jpgraph_utils.inc.php');

// Setup the graph
$graph = new Graph(1200,700);

$graph->SetScale('textint');

$theme_class=new UniversalTheme;

$graph->SetTheme($theme_class);
$graph->img->SetAntiAliasing(false);
$graph->title->Set('Termometry test');
$graph->SetBox(false);

$graph->img->SetAntiAliasing();

$graph->yaxis->title->Set('OPIOS Y');

$graph->yaxis->HideZeroLabel();
$graph->yaxis->HideLine(false);
$graph->yaxis->HideTicks(false,false);
$graph->yaxis->SetTickLabels();

$graph->xaxis->SetPos('min');
$graph->xaxis->SetLabelAngle(90);
$graph->xaxis->title->Set('OPIOS X');
$graph->xgrid->Show();
$graph->xgrid->SetLineStyle("solid");
$graph->xaxis->SetTickLabels($data);
$graph->xgrid->SetColor('#A1F1A1');

// Create the first line
$p1 = new LinePlot($term);
$graph->Add($p1);
$p1->SetColor("#013131");
$p1->SetLegend('Line 1');

$p2 = new LinePlot($term2);
$graph->Add($p2);
$p2->SetColor("#F13131");
$p2->SetLegend('Line 2');

$graph->legend->SetFrameWeight(1);

// Output line
$graph->Stroke();

?>