www/getfermentlog.php

changeset 172
684c651dd165
child 179
8adaeecd9dc8
equal deleted inserted replaced
171:48cf3ea270f8 172:684c651dd165
1 <?php
2
3 require_once('config.php');
4
5 if (isset($_GET["code"]))
6 $code = $_GET["code"];
7 else
8 $code = "CB0068";
9
10 $query = "SELECT datetime,temperature_air,temperature_beer,temperature_chiller,temperature_room,target_low,target_high,heater_power,cooler_power FROM log_fermentation WHERE product_code='".$code."'";
11 $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
12 if (! $connect) {
13 echo "[]";
14 return;
15 }
16 $result = mysqli_query($connect, $query);
17 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
18 $logs[] = array(
19 'date' => $row['datetime'],
20 'air' => $row['temperature_air'],
21 'beer' => $row['temperature_beer'],
22 'chiller' => $row['temperature_chiller'],
23 'room' => $row['temperature_room'],
24 'tlo' => $row['target_low'],
25 'thi' => $row['target_high'],
26 'heater' => $row['heater_power'],
27 'cooler' => $row['cooler_power']
28 );
29 }
30 echo json_encode($logs);

mercurial