www/includes/db_inventory_water.php

changeset 785
aa79acfdf8a9
parent 767
08c0343b622b
equal deleted inserted replaced
784:d51b05838ac4 785:aa79acfdf8a9
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'],

mercurial