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_styles"; |
13 $query = "SELECT * FROM inventory_styles ORDER BY name"; |
14 if (isset($_GET['insert'])) { |
14 if (isset($_GET['insert'])) { |
15 // INSERT COMMAND |
15 // INSERT COMMAND |
16 $sql = "INSERT INTO `inventory_styles` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
16 $sql = "INSERT INTO `inventory_styles` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
17 $sql .= "', category='" . mysqli_real_escape_string($connect, $_GET['category']); |
17 $sql .= "', category='" . mysqli_real_escape_string($connect, $_GET['category']); |
18 $sql .= "', category_number='" . $_GET['category_number']; |
18 $sql .= "', category_number='" . $_GET['category_number']; |