8 if (! $connect) { |
8 if (! $connect) { |
9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
10 } |
10 } |
11 |
11 |
12 // get data and store in a json array |
12 // get data and store in a json array |
13 $query = "SELECT * FROM inventory_miscs"; |
13 $query = "SELECT * FROM inventory_miscs ORDER BY name"; |
14 if (isset($_GET['insert'])) { |
14 if (isset($_GET['insert'])) { |
15 // INSERT COMMAND |
15 // INSERT COMMAND |
16 $sql = "INSERT INTO `inventory_miscs` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
16 $sql = "INSERT INTO `inventory_miscs` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
17 $sql .= "', type='" . $_GET['type']; |
17 $sql .= "', type='" . $_GET['type']; |
18 $sql .= "', use_use='" . $_GET['use_use']; |
18 $sql .= "', use_use='" . $_GET['use_use']; |