www/includes/db_inventory_miscs.php

changeset 514
3c680d1dea35
parent 296
69fadd1aded2
child 712
65da479b5542
equal deleted inserted replaced
513:217ba4596c4d 514:3c680d1dea35
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'],

mercurial