Mercurial > bms / annotate

www/gethopsources.php@11e6bd8d8107 (annotated)

www/gethopsources.php

Thu, 15 Apr 2021 10:57:01 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Thu, 15 Apr 2021 10:57:01 +0200
changeset 738
11e6bd8d8107
parent 705
d77b723f7b35
child 771
9856238e9217
permissions
-rw-r--r--

Added mash SG and pH fields. Fixed default Yeast update. Added mash step SG and pH input datafields. Added a Brix input too. The print report shows the mash measurements too. Other brewing results now show expected and measured values and the difference.

58
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 <?php
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2 require_once('config.php');
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3
69
ca25fdce3b85 Improved hop selection dropdown
Michiel Broek <mbroek@mbse.eu>
parents: 58
diff changeset
4 $query = "SELECT * FROM inventory_hops ORDER BY origin,name";
58
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5 $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
6 if (! $connect) {
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7 echo "[]";
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 return;
83ccc36df675 Added hops inline editor framework
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" );
58
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
11 $result = mysqli_query($connect, $query);
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
13 $hops[] = array(
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
14 'record' => $row['record'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
15 'name' => $row['name'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
16 'alpha' => $row['alpha'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
17 'beta' => $row['beta'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
18 'humulene' => $row['humulene'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
19 'caryophyllene' => $row['caryophyllene'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
20 'cohumulone' => $row['cohumulone'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
21 'myrcene' => $row['myrcene'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
22 'hsi' => $row['hsi'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
23 'total_oil' => $row['total_oil'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
24 'type' => $row['type'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
25 'form' => $row['form'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
26 'origin' => $row['origin'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
27 'inventory' => $row['inventory'],
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
28 'cost' => $row['cost']
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
29 );
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
30 }
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: 219
diff changeset
31 header("Content-type: application/json");
58
83ccc36df675 Added hops inline editor framework
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
32 echo json_encode($hops);

Mercurial Repository: bms

mercurial