www/includes/db_inventory_fermentables.php

changeset 514
3c680d1dea35
parent 296
69fadd1aded2
child 712
65da479b5542
equal deleted inserted replaced
513:217ba4596c4d 514:3c680d1dea35
1 <?php 1 <?php
2 2
3 require($_SERVER['DOCUMENT_ROOT']."/config.php"); 3 require($_SERVER['DOCUMENT_ROOT']."/config.php");
4 require($_SERVER['DOCUMENT_ROOT']."/version.php"); 4 require($_SERVER['DOCUMENT_ROOT']."/version.php");
5 require($_SERVER['DOCUMENT_ROOT']."/includes/constants.php");
5 6
6 7
7 #Connect to the database 8 #Connect to the database
8 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); 9 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME);
9 if (! $connect) { 10 if (! $connect) {
19 if (isset($_POST['update'])) { 20 if (isset($_POST['update'])) {
20 $sql = "UPDATE `inventory_fermentables` SET "; 21 $sql = "UPDATE `inventory_fermentables` SET ";
21 } 22 }
22 23
23 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); 24 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']);
24 $sql .= "', type='" . $_POST['type']; 25 $sql .= "', type='" . array_search($_POST['type'], $fermentabletype);
25 $sql .= "', yield='" . $_POST['yield']; 26 $sql .= "', yield='" . $_POST['yield'];
26 $sql .= "', color='" . $_POST['color']; 27 $sql .= "', color='" . $_POST['color'];
27 ($_POST['add_after_boil'] == 'true') ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0"; 28 ($_POST['add_after_boil'] == 'true') ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0";
28 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_POST['origin']); 29 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_POST['origin']);
29 $sql .= "', supplier='" . mysqli_real_escape_string($connect, $_POST['supplier']); 30 $sql .= "', supplier='" . mysqli_real_escape_string($connect, $_POST['supplier']);
33 $sql .= "', diastatic_power='" . $_POST['diastatic_power']; 34 $sql .= "', diastatic_power='" . $_POST['diastatic_power'];
34 $sql .= "', protein='" . $_POST['protein']; 35 $sql .= "', protein='" . $_POST['protein'];
35 $sql .= "', dissolved_protein='" . $_POST['dissolved_protein']; 36 $sql .= "', dissolved_protein='" . $_POST['dissolved_protein'];
36 $sql .= "', max_in_batch='" . $_POST['max_in_batch']; 37 $sql .= "', max_in_batch='" . $_POST['max_in_batch'];
37 ($_POST['recommend_mash'] == 'true') ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0"; 38 ($_POST['recommend_mash'] == 'true') ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0";
38 $sql .= "', added='" . $_POST['added']; 39 $sql .= "', added='" . array_search($_POST['added'], $added);
39 ($_POST['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; 40 ($_POST['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0";
40 $sql .= "', di_ph='" . $_POST['di_ph']; 41 $sql .= "', di_ph='" . $_POST['di_ph'];
41 $sql .= "', acid_to_ph_57='" . $_POST['acid_to_ph_57']; 42 $sql .= "', acid_to_ph_57='" . $_POST['acid_to_ph_57'];
42 $sql .= "', graintype='" . $_POST['graintype']; 43 $sql .= "', graintype='" . array_search($_POST['graintype'], $graintype);
43 $sql .= "', inventory='" . $_POST['inventory']; 44 $sql .= "', inventory='" . $_POST['inventory'];
44 $sql .= "', cost='" . $_POST['cost'] . "'"; 45 $sql .= "', cost='" . $_POST['cost'] . "'";
45 if ($_POST['production_date'] == '') 46 if ($_POST['production_date'] == '')
46 $sql .= ", production_date=NULL"; 47 $sql .= ", production_date=NULL";
47 else 48 else
88 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); 89 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
89 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { 90 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
90 $fermentables[] = array( 91 $fermentables[] = array(
91 'record' => $row['record'], 92 'record' => $row['record'],
92 'name' => $row['name'], 93 'name' => $row['name'],
93 'type' => $row['type'], 94 'type' => $fermentabletype[$row['type']],
94 'yield' => $row['yield'], 95 'yield' => $row['yield'],
95 'color' => $row['color'], 96 'color' => $row['color'],
96 'add_after_boil' => $row['add_after_boil'], 97 'add_after_boil' => $row['add_after_boil'],
97 'origin' => $row['origin'], 98 'origin' => $row['origin'],
98 'supplier' => $row['supplier'], 99 'supplier' => $row['supplier'],
102 'diastatic_power' => $row['diastatic_power'], 103 'diastatic_power' => $row['diastatic_power'],
103 'protein' => $row['protein'], 104 'protein' => $row['protein'],
104 'dissolved_protein' => $row['dissolved_protein'], 105 'dissolved_protein' => $row['dissolved_protein'],
105 'max_in_batch' => $row['max_in_batch'], 106 'max_in_batch' => $row['max_in_batch'],
106 'recommend_mash' => $row['recommend_mash'], 107 'recommend_mash' => $row['recommend_mash'],
107 'added' => $row['added'], 108 'added' => $added[$row['added']],
108 'always_on_stock' => $row['always_on_stock'], 109 'always_on_stock' => $row['always_on_stock'],
109 'di_ph' => $row['di_ph'], 110 'di_ph' => $row['di_ph'],
110 'acid_to_ph_57' => $row['acid_to_ph_57'], 111 'acid_to_ph_57' => $row['acid_to_ph_57'],
111 'graintype' => $row['graintype'], 112 'graintype' => $graintype[$row['graintype']],
112 'inventory' => $row['inventory'], 113 'inventory' => $row['inventory'],
113 'cost' => $row['cost'], 114 'cost' => $row['cost'],
114 'production_date' => $row['production_date'], 115 'production_date' => $row['production_date'],
115 'tht_date' => $row['tht_date'] 116 'tht_date' => $row['tht_date']
116 ); 117 );

mercurial