Sun, 23 May 2021 16:41:35 +0200
Fermentables, hops, miscs and yeast now have tests against the added moment with the brewing stage. Added to inventory edit rows, delete rows, and pick choices for the moment to add or edit. Some more popups to explain certain blocks.
28 | 1 | <?php |
2 | ||
3 | require($_SERVER['DOCUMENT_ROOT']."/config.php"); | |
4 | require($_SERVER['DOCUMENT_ROOT']."/version.php"); | |
5 | ||
6 | #Connect to the database | |
7 | $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | |
8 | if (! $connect) { | |
9 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
10 | } | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
48
diff
changeset
|
11 | mysqli_set_charset($connect, "utf8" ); |
28 | 12 | |
217
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
13 | if (isset($_POST['insert']) || isset($_POST['update'])) { |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
14 | if (isset($_POST['insert'])) { |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
15 | $sql = "INSERT INTO `profile_styles` SET "; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
16 | } |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
17 | if (isset($_POST['update'])) { |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
18 | $sql = "UPDATE `profile_styles` SET "; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
19 | } |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
20 | |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
21 | $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
22 | $sql .= "', category='" . mysqli_real_escape_string($connect, $_POST['category']); |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
23 | $sql .= "', category_number='" . $_POST['category_number']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
24 | $sql .= "', style_letter='" . mysqli_real_escape_string($connect, $_POST['style_letter']); |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
25 | $sql .= "', style_guide='" . mysqli_real_escape_string($connect, $_POST['style_guide']); |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
26 | $sql .= "', type='" . $_POST['type']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
27 | $sql .= "', og_min='" . $_POST['og_min']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
28 | $sql .= "', og_max='" . $_POST['og_max']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
29 | $sql .= "', fg_min='" . $_POST['fg_min']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
30 | $sql .= "', fg_max='" . $_POST['fg_max']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
31 | $sql .= "', ibu_min='" . $_POST['ibu_min']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
32 | $sql .= "', ibu_max='" . $_POST['ibu_max']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
33 | $sql .= "', color_min='" . $_POST['color_min']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
34 | $sql .= "', color_max='" . $_POST['color_max']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
35 | $sql .= "', carb_min='" . $_POST['carb_min']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
36 | $sql .= "', carb_max='" . $_POST['carb_max']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
37 | $sql .= "', abv_min='" . $_POST['abv_min']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
38 | $sql .= "', abv_max='" . $_POST['abv_max']; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
39 | $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
40 | $sql .= "', profile='" . mysqli_real_escape_string($connect, $_POST['profile']); |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
41 | $sql .= "', ingredients='" . mysqli_real_escape_string($connect, $_POST['ingredients']); |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
42 | $sql .= "', examples='" . mysqli_real_escape_string($connect, $_POST['examples']); |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
43 | if (isset($_POST['insert'])) { |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
44 | $sql .= "';"; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
45 | } |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
46 | if (isset($_POST['update'])) { |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
47 | $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
48 | } |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
49 | |
28 | 50 | $result = mysqli_query($connect, $sql); |
51 | if (! $result) { | |
45
95251bedfab4
Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents:
37
diff
changeset
|
52 | syslog(LOG_NOTICE, "db_profile_styles: ".$sql." result: ".mysqli_error($connect)); |
716
57118e6a4bdb
Remove log messages if database profile updates are successfull.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
53 | //} else { |
57118e6a4bdb
Remove log messages if database profile updates are successfull.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
54 | // if (isset($_POST['update'])) { |
57118e6a4bdb
Remove log messages if database profile updates are successfull.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
55 | // syslog(LOG_NOTICE, "db_profile_styles: updated record ".$_POST['record']); |
57118e6a4bdb
Remove log messages if database profile updates are successfull.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
56 | // } else { |
57118e6a4bdb
Remove log messages if database profile updates are successfull.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
57 | // $lastid = mysqli_insert_id($connect); |
57118e6a4bdb
Remove log messages if database profile updates are successfull.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
58 | // syslog(LOG_NOTICE, "db_profile_styles: inserted record ".$lastid); |
57118e6a4bdb
Remove log messages if database profile updates are successfull.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
59 | // } |
28 | 60 | } |
61 | echo $result; | |
62 | ||
217
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
63 | } else if (isset($_POST['delete'])) { |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
64 | // DELETE COMMAND |
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
65 | $sql = "DELETE FROM `profile_styles` WHERE record='".$_POST['record']."';"; |
28 | 66 | $result = mysqli_query($connect, $sql); |
67 | if (! $result) { | |
45
95251bedfab4
Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents:
37
diff
changeset
|
68 | syslog(LOG_NOTICE, "db_profile_styles: ".$sql." result: ".mysqli_error($connect)); |
28 | 69 | } else { |
217
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
70 | syslog(LOG_NOTICE, "db_profile_styles: deleted record ".$_POST['record']); |
28 | 71 | } |
72 | echo $result; | |
73 | ||
74 | } else { | |
75 | // SELECT COMMAND | |
217
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
76 | $query = "SELECT * FROM profile_styles ORDER BY style_guide,style_letter,name"; |
28 | 77 | $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
78 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
79 | $styles[] = array( | |
80 | 'record' => $row['record'], | |
81 | 'name' => $row['name'], | |
82 | 'category' => $row['category'], | |
83 | 'category_number' => $row['category_number'], | |
84 | 'style_letter' => $row['style_letter'], | |
85 | 'style_guide' => $row['style_guide'], | |
86 | 'type' => $row['type'], | |
87 | 'og_min' => $row['og_min'], | |
88 | 'og_max' => $row['og_max'], | |
89 | 'fg_min' => $row['fg_min'], | |
90 | 'fg_max' => $row['fg_max'], | |
91 | 'ibu_min' => $row['ibu_min'], | |
92 | 'ibu_max' => $row['ibu_max'], | |
93 | 'color_min' => $row['color_min'], | |
94 | 'color_max' => $row['color_max'], | |
95 | 'carb_min' => $row['carb_min'], | |
96 | 'carb_max' => $row['carb_max'], | |
97 | 'abv_min' => $row['abv_min'], | |
98 | 'abv_max' => $row['abv_max'], | |
99 | 'notes' => $row['notes'], | |
100 | 'profile' => $row['profile'], | |
101 | 'ingredients' => $row['ingredients'], | |
102 | 'examples' => $row['examples'] | |
103 | ); | |
104 | } | |
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:
217
diff
changeset
|
105 | header("Content-type: application/json"); |
28 | 106 | echo json_encode($styles); |
107 | } | |
108 | ?> |