22 $sql = "INSERT INTO `inventory_hops` SET "; |
22 $sql = "INSERT INTO `inventory_hops` SET "; |
23 } |
23 } |
24 if (isset($_POST['update'])) { |
24 if (isset($_POST['update'])) { |
25 $sql = "UPDATE `inventory_hops` SET "; |
25 $sql = "UPDATE `inventory_hops` SET "; |
26 } |
26 } |
27 |
27 |
28 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); |
28 if (isset($_POST['uuid']) && (strlen($_POST['uuid']) == 36)) { |
|
29 $sql .= "uuid='" . $_POST['uuid']; |
|
30 } else { |
|
31 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); |
|
32 $sql .= "uuid='" . $uuid; |
|
33 } |
|
34 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']); |
29 $sql .= "', alpha='" . $_POST['alpha']; |
35 $sql .= "', alpha='" . $_POST['alpha']; |
30 $sql .= "', beta='" . $_POST['beta']; |
36 $sql .= "', beta='" . $_POST['beta']; |
31 $sql .= "', humulene='" . $_POST['humulene']; |
37 $sql .= "', humulene='" . $_POST['humulene']; |
32 $sql .= "', caryophyllene='" . $_POST['caryophyllene']; |
38 $sql .= "', caryophyllene='" . $_POST['caryophyllene']; |
33 $sql .= "', cohumulone='" . $_POST['cohumulone']; |
39 $sql .= "', cohumulone='" . $_POST['cohumulone']; |
81 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
87 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
82 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
88 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
83 $hops[] = array( |
89 $hops[] = array( |
84 'record' => $row['record'], |
90 'record' => $row['record'], |
85 'name' => $row['name'], |
91 'name' => $row['name'], |
|
92 'uuid' => $row['uuid'], |
86 'alpha' => $row['alpha'], |
93 'alpha' => $row['alpha'], |
87 'beta' => $row['beta'], |
94 'beta' => $row['beta'], |
88 'humulene' => $row['humulene'], |
95 'humulene' => $row['humulene'], |
89 'caryophyllene' => $row['caryophyllene'], |
96 'caryophyllene' => $row['caryophyllene'], |
90 'cohumulone' => $row['cohumulone'], |
97 'cohumulone' => $row['cohumulone'], |