www/includes/db_profile_styles.php

changeset 785
aa79acfdf8a9
parent 768
ae1195153fa2
equal deleted inserted replaced
784:d51b05838ac4 785:aa79acfdf8a9
20 $sql = "INSERT INTO `profile_styles` SET "; 20 $sql = "INSERT INTO `profile_styles` SET ";
21 } 21 }
22 if (isset($_POST['update'])) { 22 if (isset($_POST['update'])) {
23 $sql = "UPDATE `profile_styles` SET "; 23 $sql = "UPDATE `profile_styles` SET ";
24 } 24 }
25 25 if (isset($_POST['uuid']) && (strlen($_POST['uuid']) == 36)) {
26 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); 26 $sql .= "uuid='" . $_POST['uuid'];
27 } else {
28 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid'));
29 $sql .= "uuid='" . $uuid;
30 }
31 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']);
27 $sql .= "', category='" . mysqli_real_escape_string($connect, $_POST['category']); 32 $sql .= "', category='" . mysqli_real_escape_string($connect, $_POST['category']);
28 $sql .= "', category_number='" . $_POST['category_number']; 33 $sql .= "', category_number='" . $_POST['category_number'];
29 $sql .= "', style_letter='" . mysqli_real_escape_string($connect, $_POST['style_letter']); 34 $sql .= "', style_letter='" . mysqli_real_escape_string($connect, $_POST['style_letter']);
30 $sql .= "', style_guide='" . mysqli_real_escape_string($connect, $_POST['style_guide']); 35 $sql .= "', style_guide='" . mysqli_real_escape_string($connect, $_POST['style_guide']);
31 $sql .= "', type='" . $_POST['type']; 36 $sql .= "', type='" . $_POST['type'];
75 $query = "SELECT * FROM profile_styles ORDER BY style_guide,style_letter,name"; 80 $query = "SELECT * FROM profile_styles ORDER BY style_guide,style_letter,name";
76 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); 81 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
77 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { 82 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
78 $styles[] = array( 83 $styles[] = array(
79 'record' => $row['record'], 84 'record' => $row['record'],
85 'uuid' => $row['uuid'],
80 'name' => $row['name'], 86 'name' => $row['name'],
81 'category' => $row['category'], 87 'category' => $row['category'],
82 'category_number' => $row['category_number'], 88 'category_number' => $row['category_number'],
83 'style_letter' => $row['style_letter'], 89 'style_letter' => $row['style_letter'],
84 'style_guide' => $row['style_guide'], 90 'style_guide' => $row['style_guide'],

mercurial