www/includes/db_inventory_hops.php

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

mercurial