1 <?php |
1 <?php |
2 |
2 |
3 require($_SERVER['DOCUMENT_ROOT']."/config.php"); |
3 require($_SERVER['DOCUMENT_ROOT']."/config.php"); |
4 require($_SERVER['DOCUMENT_ROOT']."/version.php"); |
4 require($_SERVER['DOCUMENT_ROOT']."/version.php"); |
|
5 require($_SERVER['DOCUMENT_ROOT']."/includes/constants.php"); |
5 |
6 |
6 #Connect to the database |
7 #Connect to the database |
7 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
8 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
8 if (! $connect) { |
9 if (! $connect) { |
9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
17 if (isset($_POST['update'])) { |
18 if (isset($_POST['update'])) { |
18 $sql = "UPDATE `inventory_miscs` SET "; |
19 $sql = "UPDATE `inventory_miscs` SET "; |
19 } |
20 } |
20 |
21 |
21 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); |
22 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); |
22 $sql .= "', type='" . $_POST['type']; |
23 $sql .= "', type='" . array_search($_POST['type'], $misctype); |
23 $sql .= "', use_use='" . $_POST['use_use']; |
24 $sql .= "', use_use='" . array_search($_POST['use_use'], $miscuse); |
24 $sql .= "', time='" . $_POST['time']; |
25 $sql .= "', time='" . $_POST['time']; |
25 ($_POST['amount_is_weight'] == 'true') ? $sql .= "', amount_is_weight='1" : $sql .= "', amount_is_weight='0"; |
26 ($_POST['amount_is_weight'] == 'true') ? $sql .= "', amount_is_weight='1" : $sql .= "', amount_is_weight='0"; |
26 $sql .= "', use_for='" . mysqli_real_escape_string($connect, $_POST['use_for']); |
27 $sql .= "', use_for='" . mysqli_real_escape_string($connect, $_POST['use_for']); |
27 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); |
28 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); |
28 ($_POST['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
29 ($_POST['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
75 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
76 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
76 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
77 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
77 $miscs[] = array( |
78 $miscs[] = array( |
78 'record' => $row['record'], |
79 'record' => $row['record'], |
79 'name' => $row['name'], |
80 'name' => $row['name'], |
80 'type' => $row['type'], |
81 'type' => $misctype[$row['type']], |
81 'use_use' => $row['use_use'], |
82 'use_use' => $miscuse[$row['use_use']], |
82 'time' => $row['time'], |
83 'time' => $row['time'], |
83 'amount_is_weight' => $row['amount_is_weight'], |
84 'amount_is_weight' => $row['amount_is_weight'], |
84 'use_for' => $row['use_for'], |
85 'use_for' => $row['use_for'], |
85 'notes' => $row['notes'], |
86 'notes' => $row['notes'], |
86 'always_on_stock' => $row['always_on_stock'], |
87 'always_on_stock' => $row['always_on_stock'], |