Kod: Markera allt
<html>
<head>
<title>Flot Examples</title>
<script src="../jquery.js"></script>
<script src="../jquery.flot.js"></script>
<script src="../jquery.flot.time.js"></script>
</head>
<body>
<h1>Flot Examples</h1>
<div id="placeholder" style="width:600px;height:300px;"></div>
<?php
$db = mysql_connect("localhost", "user", "password");
mysql_select_db("temperaturen",$db);
$query = "SELECT energy.timegroup as Hour, round( sum( energy.countdiff ) / 1000, 1) as kWhDiff
FROM( SELECT i.counter_c - c.counter_c as countdiff, c.counter_c as startcounter, date_format( c.timestamp,'%Y-%m-%d %T' ) as timegroup
FROM elmatare c join (select * FROM elmatare) i on c.index=i.index-1 and c.timestamp between timestampadd( hour, -24, Now() ) and Now()) energy,
(SELECT min(s.counter_c) as countstart FROM elmatare s join (select * FROM elmatare) t on s.index=t.index and s.timestamp between timestampadd(hour,-24, Now()) and Now()) input group by energy.timegroup";
$result = mysql_query($query,$db);
while($row = mysql_fetch_array($result))
{
// $arr[] = array($row->Hour,$row->kWhDiff);
$arr[] = array($row["Hour"],$row["kWhDiff"]);
}
?>
<script type="text/javascript">
$(function () {
var dataset1 = <?php echo json_encode($arr); ?>;
$.plot($("#placeholder"), [ dataset1 ] );
});
</script>
</body>
</html>
Kod: Markera allt
SELECT energy.timegroup as 'Hour', round( sum( energy.countdiff ) / 1000, 1) as 'kWhDiff'
FROM(SELECT i.counter_c - c.counter_c as 'countdiff', c.counter_c as 'startcounter', date_format( c.timestamp,'%H:00:00') as 'timegroup'
FROM elmatare c join (select * FROM elmatare) i on c.index=i.index-1 and c.timestamp between timestampadd( hour, -24, Now() ) and Now()) energy,
(SELECT min(s.counter_c) as 'countstart'
FROM elmatare s join (select * FROM elmatare) t on s.index=t.index and s.timestamp between timestampadd(hour,-24, Now()) and Now()) input group by energy.timegroup
Kod: Markera allt
$query = "SELECT UNIX_TIMESTAMP(timestamp)*1000 \"timestamp\", temperature FROM ute WHERE timestamp > NOW() - INTERVAL 1 DAY ORDER by timestamp";
$result = @mysql_query ($query);
$utetemp = array();
while($row = mysql_fetch_object($result))
$arr[] = array($row->timestamp, $row->temperature);
mysql_close();
?>
<script type="text/javascript">
$(function () {
var dataset1 = <?php echo json_encode($arr); ?>;
$.plot($("#placeholder"), [ dataset1 ] );
});
</script>
De ä tur a man gillar att pilla o joxa med diverse då...motoz skrev:Utan att vara speciellt insatt i sql eller php så ser ditt readsensor.php skript ut att vara vidöppet för sql-injection attacker så lägg inte ut webbsidan åtkomlig på internet.