Sat, 11 Feb 2023 15:53:16 +0100
Version 0.3.42 added yeast_lo and yeast_hi fields to the iSpindel records and structures.
580
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | <?php |
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | |
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
3 | require_once('config.php'); |
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
4 | |
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | if (isset($_GET["code"])) |
837
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
6 | $code = $_GET["code"]; |
580
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | else |
837
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
8 | $code = "CB0111"; |
580
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | |
837
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
10 | $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
11 | if (! $connect) { |
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
12 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
601
112c278be803
All graph displays now check if the log excists.
Michiel Broek <mbroek@mbse.eu>
parents:
580
diff
changeset
|
13 | } |
837
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
14 | mysqli_set_charset($connect, "utf8" ); |
580
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
15 | |
837
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
16 | $query = "SELECT * FROM log_ispindel WHERE code='".$code."' ORDER BY datetime;"; |
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
17 | $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
18 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
580
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
19 | |
837
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
20 | $logs[] = array( |
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
21 | 'date' => substr($row['datetime'],0,16), |
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
22 | 'temperature' => $row['temperature'], |
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
23 | 'plato' => $row['plato'], |
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
24 | 'sg' => $row['sg'], |
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
25 | 'battery' => $row['battery'] |
b5e2ff72cc73
Switch ispindel graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
627
diff
changeset
|
26 | ); |
580
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
27 | } |
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
28 | header("Content-type: application/json"); |
9cd6873bda75
Fixed ispindel_death. Added ispindel log graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
29 | echo json_encode($logs); |