www/getbrewlog.php

changeset 297
5e2424bfbc4a
parent 296
69fadd1aded2
equal deleted inserted replaced
296:69fadd1aded2 297:5e2424bfbc4a
11 if (! $connect) { 11 if (! $connect) {
12 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); 12 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
13 } 13 }
14 mysqli_set_charset($connect, "utf8" ); 14 mysqli_set_charset($connect, "utf8" );
15 15
16 $query = "SELECT * FROM log_brews WHERE product_code='".$code."' ORDER BY datetime;"; 16 $query = "SELECT * FROM log_brews WHERE code='".$code."' ORDER BY datetime;";
17 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); 17 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
18 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { 18 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
19 $lines[] = array( 19 $lines[] = array(
20 'record' => $row['record'], 20 'record' => $row['record'],
21 'date' => substr($row['datetime'],0,16), 21 'date' => substr($row['datetime'],0,16),
22 'version' => $row['version'], 22 'version' => $row['version'],
23 'code' => $row['product_code'], 23 'code' => $row['code'],
24 'name' => $row['product_name'], 24 'name' => $row['name'],
25 'pv_mlt' => $row['temperature_mlt'], 25 'pv_mlt' => $row['pv_mlt'],
26 'pv_bk' => $row['temperature_bk'], 26 'pv_hlt' => $row['pv_hlt'],
27 'pv_hlt' => $row['temperature_hlt'], 27 'pv_room' => $row['pv_room'],
28 'pv_room' => $row['temperature_room'], 28 'sp_mlt' => $row['sp_mlt'],
29 'sp_mlt' => $row['setpoint_mlt'], 29 'sp_hlt' => $row['sp_hlt'],
30 'sp_bk' => $row['setpoint_bk'], 30 'pwm_mlt' => $row['pwm_mlt'],
31 'sp_hlt' => $row['setpoint_hlt'], 31 'pwm_hlt' => $row['pwm_hlt'],
32 'event' => $row['event'] 32 'event' => $row['event']
33 ); 33 );
34 } 34 }
35 header("Content-type: application/json"); 35 header("Content-type: application/json");
36 echo json_encode($lines); 36 echo json_encode($lines);

mercurial