www/getispindel.php@aa79acfdf8a9 (annotated)
www/getispindel.php
Thu, 10 Feb 2022 22:15:10 +0100
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Thu, 10 Feb 2022 22:15:10 +0100
- changeset 785
- aa79acfdf8a9
- parent 587
- 31caffee8c9c
- permissions
- -rw-r--r--
Added uuid field in inventory equipments, fermentables, hops, miscs, suppliers, water and yeasts. Added uuid field in profiles mash, styles and water.
|
570
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | <?php |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
3 | require_once('config.php'); |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
4 | |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | if (isset($_GET["uuid"])) |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
6 | $uuid = $_GET["uuid"]; |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | else |
|
587
31caffee8c9c
Changed several float precision values. Changed some database fields to double. Everything has now the same precision as received values from the iSpindel.
Michiel Broek <mbroek@mbse.eu>
parents:
578
diff
changeset
|
8 | $uuid = "'c0ffeeee-cafe-dead-bee0-2af236d50dc9'"; |
|
570
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
10 | |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
11 | $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
|
578
e75ce5bbda73
Changed the interface from the iSpindels to be the same as other devices. A webpage converts each call to two standard MQTT messages. The nodes MQTT message extended with an interval parameter. iSpindels now have a generated uuid made up from the chipid.
Michiel Broek <mbroek@mbse.eu>
parents:
570
diff
changeset
|
12 | $query = "SELECT * FROM mon_ispindels WHERE uuid=".$uuid.""; |
|
570
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
13 | $result = $mysqli->query($query); |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
14 | $resultArray = $result->fetch_array(MYSQLI_ASSOC); |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
15 | header("Content-type: application/json"); |
|
c8a20234d7e7
Added iSpindel monitor screen design.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | echo json_encode($resultArray); |
