Mercurial > bms / annotate

www/gethopsources.php@d77b723f7b35 (annotated)

www/gethopsources.php

Wed, 15 Jul 2020 16:03:23 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Wed, 15 Jul 2020 16:03:23 +0200
changeset 705
d77b723f7b35
parent 296
69fadd1aded2
child 771
9856238e9217
permissions
-rw-r--r--

Make sure enumerated values are not empty in database updates. On several data queries set the database connection to UTF-8.

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