comparison: www/getbrewlog.php
www/getbrewlog.php
- changeset 294
- 1e09d1d102a8
- child 296
- 69fadd1aded2
equal
deleted
inserted
replaced
| 293:db898ec73277 | 294:1e09d1d102a8 |
|---|---|
| 1 <?php | |
| 2 | |
| 3 require_once('config.php'); | |
| 4 | |
| 5 if (isset($_GET["code"])) | |
| 6 $code = $_GET["code"]; | |
| 7 else | |
| 8 $code = "CB0011"; | |
| 9 | |
| 10 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | |
| 11 if (! $connect) { | |
| 12 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
| 13 } | |
| 14 mysqli_set_charset($connect, "utf8" ); | |
| 15 | |
| 16 $query = "SELECT * FROM log_brews WHERE product_code='".$code."' ORDER BY datetime;"; | |
| 17 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | |
| 18 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
| 19 $lines[] = array( | |
| 20 'record' => $row['record'], | |
| 21 'date' => substr($row['datetime'],0,16), | |
| 22 'version' => $row['version'], | |
| 23 'code' => $row['product_code'], | |
| 24 'name' => $row['product_name'], | |
| 25 'pv_mlt' => $row['temperature_mlt'], | |
| 26 'pv_bk' => $row['temperature_bk'], | |
| 27 'pv_hlt' => $row['temperature_hlt'], | |
| 28 'pv_room' => $row['temperature_room'], | |
| 29 'sp_mlt' => $row['setpoint_mlt'], | |
| 30 'sp_bk' => $row['setpoint_bk'], | |
| 31 'sp_hlt' => $row['setpoint_hlt'], | |
| 32 'event' => $row['event'] | |
| 33 ); | |
| 34 } | |
| 35 | |
| 36 echo json_encode($lines); |
