21 } |
21 } |
22 if (isset($_POST['update'])) { |
22 if (isset($_POST['update'])) { |
23 $sql = "UPDATE `inventory_waters` SET "; |
23 $sql = "UPDATE `inventory_waters` SET "; |
24 } |
24 } |
25 |
25 |
26 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); |
26 if (isset($_POST['uuid']) && (strlen($_POST['uuid']) == 36)) { |
|
27 $sql .= "uuid='" . $_POST['uuid']; |
|
28 } else { |
|
29 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); |
|
30 $sql .= "uuid='" . $uuid; |
|
31 } |
|
32 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']); |
27 ($_POST['unlimited_stock'] == 'true') ? $sql .= "', unlimited_stock='1" : $sql .= "', unlimited_stock='0"; |
33 ($_POST['unlimited_stock'] == 'true') ? $sql .= "', unlimited_stock='1" : $sql .= "', unlimited_stock='0"; |
28 $sql .= "', calcium='" . $_POST['calcium']; |
34 $sql .= "', calcium='" . $_POST['calcium']; |
29 $sql .= "', bicarbonate='" . $_POST['bicarbonate']; |
35 $sql .= "', bicarbonate='" . $_POST['bicarbonate']; |
30 $sql .= "', sulfate='" . $_POST['sulfate']; |
36 $sql .= "', sulfate='" . $_POST['sulfate']; |
31 $sql .= "', chloride='" . $_POST['chloride']; |
37 $sql .= "', chloride='" . $_POST['chloride']; |
67 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
73 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
68 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
74 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
69 $waters[] = array( |
75 $waters[] = array( |
70 'record' => $row['record'], |
76 'record' => $row['record'], |
71 'name' => $row['name'], |
77 'name' => $row['name'], |
|
78 'uuid' => $row['uuid'], |
72 'unlimited_stock' => $row['unlimited_stock'], |
79 'unlimited_stock' => $row['unlimited_stock'], |
73 'calcium' => $row['calcium'], |
80 'calcium' => $row['calcium'], |
74 'bicarbonate' => $row['bicarbonate'], |
81 'bicarbonate' => $row['bicarbonate'], |
75 'sulfate' => $row['sulfate'], |
82 'sulfate' => $row['sulfate'], |
76 'chloride' => $row['chloride'], |
83 'chloride' => $row['chloride'], |