Remote-Temperator-Monitor/ajaxhome.php at master · ranacse05/Remote-Temperator-Monitor · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?php

require_once 'db.php';
  $data= array();

  $results= $db->query("select minutes,temp,time_stamp from minutes order by time_stamp desc limit 1");
  $data= array();

  while ($res= $results->fetchArray())
  {
    //print_r($res);
    $temp = array();
    $temp[]  = $res['minutes'];
    $temp[] = $res['temp'];
    $temp[] = $res['time_stamp'];

    array_push($data, $temp);
  }

  $results= $db->query("select minutes,temp,time_stamp from minutes2 order by time_stamp desc limit 1");

  while ($res= $results->fetchArray())
  {
    //print_r($res);
    $temp = array();
    $temp[]  = $res['minutes'];
    $temp[] = $res['temp'];
    $temp[] = $res['time_stamp'];

    array_push($data, $temp);
  }


echo json_encode($data);


   $db->close();
   unset($db);
  ?>