www/getwatersources.php@9856238e9217 (annotated)
www/getwatersources.php
Sun, 11 Jul 2021 15:55:44 +0200
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Sun, 11 Jul 2021 15:55:44 +0200
- changeset 771
- 9856238e9217
- parent 705
- d77b723f7b35
- permissions
- -rw-r--r--
More efficient code for get*sources.php form dropdown lists.
|
54
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | <?php |
|
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | require_once('config.php'); |
|
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
3 | |
|
771
9856238e9217
More efficient code for get*sources.php form dropdown lists.
Michiel Broek <mbroek@mbse.eu>
parents:
705
diff
changeset
|
4 | $query = "SELECT record,name,unlimited_stock,calcium,sulfate,chloride,sodium,magnesium,ph,total_alkalinity,inventory,cost FROM inventory_waters ORDER BY name"; |
|
54
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
|
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
6 | if (! $connect) { |
|
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | echo "[]"; |
|
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
8 | return; |
|
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | } |
|
705
d77b723f7b35
Make sure enumerated values are not empty in database updates. On several data queries set the database connection to UTF-8.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
10 | mysqli_set_charset($connect, "utf8"); |
|
54
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
11 | $result = mysqli_query($connect, $query); |
|
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
12 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
|
771
9856238e9217
More efficient code for get*sources.php form dropdown lists.
Michiel Broek <mbroek@mbse.eu>
parents:
705
diff
changeset
|
13 | $waters[] = $row; |
|
54
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
14 | } |
|
296
69fadd1aded2
Updated design document. Add content header application/json to all scripts that produce json output. Chart prints show the beer code and name in the header. Charts don't display the menu anymore.
Michiel Broek <mbroek@mbse.eu>
parents:
146
diff
changeset
|
15 | header("Content-type: application/json"); |
|
54
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | echo json_encode($waters); |
