comparison: www/includes/db_profile_water.php
www/includes/db_profile_water.php
- changeset 785
- aa79acfdf8a9
- parent 768
- ae1195153fa2
equal
deleted
inserted
replaced
| 784:d51b05838ac4 | 785:aa79acfdf8a9 |
|---|---|
| 21 } | 21 } |
| 22 if (isset($_POST['update'])) { | 22 if (isset($_POST['update'])) { |
| 23 $sql = "UPDATE `profile_water` SET "; | 23 $sql = "UPDATE `profile_water` 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 $sql .= "', calcium='" . $_POST['calcium']; | 33 $sql .= "', calcium='" . $_POST['calcium']; |
| 28 $sql .= "', bicarbonate='" . $_POST['bicarbonate']; | 34 $sql .= "', bicarbonate='" . $_POST['bicarbonate']; |
| 29 $sql .= "', sulfate='" . $_POST['sulfate']; | 35 $sql .= "', sulfate='" . $_POST['sulfate']; |
| 30 $sql .= "', chloride='" . $_POST['chloride']; | 36 $sql .= "', chloride='" . $_POST['chloride']; |
| 31 $sql .= "', sodium='" . $_POST['sodium']; | 37 $sql .= "', sodium='" . $_POST['sodium']; |
| 63 $query = "SELECT * FROM profile_water ORDER BY name"; | 69 $query = "SELECT * FROM profile_water ORDER BY name"; |
| 64 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 70 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
| 65 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | 71 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 66 $waters[] = array( | 72 $waters[] = array( |
| 67 'record' => $row['record'], | 73 'record' => $row['record'], |
| 74 'uuid' => $row['uuid'], | |
| 68 'name' => $row['name'], | 75 'name' => $row['name'], |
| 69 'calcium' => $row['calcium'], | 76 'calcium' => $row['calcium'], |
| 70 'bicarbonate' => $row['bicarbonate'], | 77 'bicarbonate' => $row['bicarbonate'], |
| 71 'sulfate' => $row['sulfate'], | 78 'sulfate' => $row['sulfate'], |
| 72 'chloride' => $row['chloride'], | 79 'chloride' => $row['chloride'], |
