Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE HTML>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <meta http-equiv="refresh" content="300"> <!-- reload page every 5 minutes !-->
- <title>Temperaturen</title>
- <?php
- $link = mysql_connect("localhost", "YOUR_MYSQL_USER_HERE", "YOUR_MYSQL_PASSWORD_HERE") or die("Error verbinden met DB: " . mysql_error());
- $db = mysql_select_db("artemp", $link);
- if (!$db) {
- mysql_close($link);
- die("Error selecteren DB: " . mysql_error());
- }
- // Alle waardes ophalen voor AANVOER. Query haalt nu alle resultaten op. Met 'DATE_SUB' in query kunnen waarden beperkt worden.
- $result = mysql_query("SELECT unix_timestamp (event) AS ts, celsius AS 'sensor_1' FROM temperature WHERE sensor = '28 92 19 a8 04 00 00 65'"); //AND event >= DATE_SUB(CURDATE(), INTERVAL 1 WEEK)");
- if (!$result) {
- mysql_close($link);
- die("Error met query: " . mysql_error());
- }
- while ($row = mysql_fetch_array($result)) {
- $datetime = (($row['ts']) * 1000) + 7200000; // convert from Unix timestamp to JavaScript time
- $value1 = $row['sensor_1'];
- if (!$meting1)
- $meting1 = $value1;
- $data1[] = "[$datetime, $value1]";
- }
- $data_1 = join($data1, ',');
- // Alle waardes ophalen voor RETOUR. Query haalt nu alle resultaten op. Met 'DATE_SUB' in query kunnen waarden beperkt worden.
- $result = mysql_query("SELECT unix_timestamp (event)AS ts, celsius AS 'sensor_3', event FROM temperature WHERE sensor = '28 f3 86 b5 04 00 00 ec'"); //AND event >= DATE_SUB(CURDATE(), INTERVAL 1 WEEK)");
- if (!$result) {
- mysql_close($link);
- die("Error met query: " . mysql_error());
- }
- while ($row = mysql_fetch_array($result)) {
- $latest_measure = $row['event'];
- $datetime = (($row['ts']) * 1000) + 7200000; // convert from Unix timestamp to JavaScript time
- $value3 = $row['sensor_3'];
- if (!$meting3)
- $meting3 = $value3;
- $data2[] = "[$datetime, $value3]";
- }
- $data_2 = join($data2, ',');
- // Alle waardes ophalen voor WOONKAMER. Query haalt nu alle resultaten op. Met 'DATE_SUB' in query kunnen waarden beperkt worden.
- $result = mysql_query("SELECT unix_timestamp (event)AS ts, celsius AS 'sensor_4', event FROM temperature WHERE sensor = '28 66 df a8 04 00 00 75'"); //AND event >= DATE_SUB(CURDATE(), INTERVAL 1 WEEK)");
- if (!$result) {
- mysql_close($link);
- die("Error met query: " . mysql_error());
- }
- while ($row = mysql_fetch_array($result)) {
- $datetime = (($row['ts']) * 1000) + 7200000; // convert from Unix timestamp to JavaScript time
- $value4 = $row['sensor_4'];
- if (!$meting4)
- $meting4 = $value4;
- $data4[] = "[$datetime, $value4]";
- }
- $data_4 = join($data4, ',');
- ?>
- <script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>
- <script type="text/javascript">
- $(function () {
- $('#container').highcharts({
- chart: {
- zoomType: 'x'
- },
- title: {
- text: 'Arduino temperatuurlogger'
- },
- subtitle: {
- text: document.ontouchstart === undefined ?
- 'Klik en sleep in de grafiek om in te zoomen' :
- 'Maak een knijpbeweging om in te zoomen' //only shown on touch (tablet) devices
- },
- xAxis: {
- type: 'datetime',
- minRange: 5 * 60 * 1000 // Smallest zoominterval (in miliseconds). 5 min. This is matched to the Arduino temperature interval. If your interval is 1 min, change first number to 1
- },
- yAxis: {
- //min: 10, // Schaal instellen, uncomment de min en max voor automatisch
- //max: 80,
- title: {
- text: 'Temperatuur (°C)'
- }
- },
- tooltip: {
- valueSuffix: '°C'
- },
- legend: {
- layout: 'vertical',
- align: 'right',
- verticalAlign: 'middle',
- borderWidth: 0
- },
- plotOptions: {
- area: {
- fillColor: {
- linearGradient: { x1: 0, y1: 0, x2: 0, y2: 1},
- stops: [
- [0, Highcharts.getOptions().colors[0]],
- [1, Highcharts.Color(Highcharts.getOptions().colors[0]).setOpacity(0).get('rgba')]
- ]
- },
- marker: {
- radius: 2
- },
- lineWidth: 1,
- states: {
- hover: {
- lineWidth: 1
- }
- },
- threshold: null
- }
- },
- series: [{
- name: 'Aanvoer',
- pointInterval: 24 * 3600 * 1000,
- color: '#FF0000',
- marker: {
- enabled: false
- },
- data: [<?php
- echo ($data_1);
- ?>]
- },
- {
- name: 'Retour',
- color: '#0000FF',
- marker: {
- enabled: false
- },
- data: [<?php
- echo ($data_2);
- ?>]
- },
- {
- name: 'Woonkamer',
- color: '#008000',
- marker: {
- enabled: false
- },
- data: [<?php
- echo ($data_4);
- ?>]
- },
- ]
- });
- });
- <?
- // Nieuwste enkele waarde voor AANVOER ophalen
- $result = mysql_query("SELECT id as LATEST, celsius FROM temperature WHERE sensor = '28 92 19 a8 04 00 00 65' ORDER BY id DESC LIMIT 1");
- if (!$result) {
- mysql_close($link);
- die("Error met query: " . mysql_error());
- }
- while ($row = mysql_fetch_array($result)) {
- $nieuwste_from_aanvoer = $row['celsius'];
- }
- // Nieuwste enkele waarde voor RETOUR ophalen
- $result = mysql_query("SELECT id as LATEST, celsius FROM temperature WHERE sensor = '28 f3 86 b5 04 00 00 ec' ORDER BY id DESC LIMIT 1");
- if (!$result) {
- mysql_close($link);
- die("Error met query: " . mysql_error());
- }
- while ($row = mysql_fetch_array($result)) {
- $nieuwste_from_retour = $row['celsius'];
- }
- // Nieuwste enkele waarde voor WOONKAMER ophalen
- $result = mysql_query("SELECT id as LATEST, celsius FROM temperature WHERE sensor = '28 66 df a8 04 00 00 75' ORDER BY id DESC LIMIT 1");
- if (!$result) {
- mysql_close($link);
- die("Error met query: " . mysql_error());
- }
- while ($row = mysql_fetch_array($result)) {
- $nieuwste_from_woonkamer = $row['celsius'];
- }
- ?>
- </script>
- <style type="text/css">
- body {
- background-color: #FFFFFF;
- font-family: 'Helvetica, Arial, sans-serif';
- color: black;
- font-size: 20px;
- text-align: center;
- }
- p {
- font-family: 'helvetica, arial, sans-serif';
- }
- </style>
- </head>
- <body>
- <script src="js/highcharts.js"></script>
- <script src="js/modules/exporting.js"></script>
- <div id="container" style="min-width: 310px; height: 400px; margin: 0 auto"></div>
- <p style="font-family:helvetica, tahoma, sans-serif;">
- <span style="color: #000000";>Actueel:</span> <br />
- <span style="color: #FF0000";>Aanvoer: <?php echo (number_format($nieuwste_from_aanvoer, 1)); ?> °C</span>
- <span style="color: #0000FF";> Retour: <?php echo (number_format($nieuwste_from_retour, 1)); ?> °C</span>
- <span style="color: #FFA500";> DeltaT: <?php echo (number_format($nieuwste_from_aanvoer - $nieuwste_from_retour, 1)); ?> °C</span>
- <span style="color: #008000";> Woonkamer: <?php echo (number_format($nieuwste_from_woonkamer, 1)); ?> °C</span><br />
- <br />
- <span style="color: #000000";><font size="2">Laatste meting opgehaald om:</span> <br /> <?php echo $latest_measure; ?></font><br>
- </p>
- <?php
- mysql_close($link);
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement