22 } |
22 } |
23 } |
23 } |
24 |
24 |
25 |
25 |
26 // get data and store in a json array |
26 // get data and store in a json array |
27 $query = "SELECT * FROM inventory_water_sources"; |
27 $query = "SELECT * FROM inventory_water_sources ORDER BY name"; |
28 if (isset($_GET['insert'])) { |
28 if (isset($_GET['insert'])) { |
29 // INSERT COMMAND |
29 // INSERT COMMAND |
30 $sql = "INSERT INTO `inventory_water_sources` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
30 $sql = "INSERT INTO `inventory_water_sources` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
31 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
31 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
32 $sql .= "', calcium='" . $_GET['calcium']; |
32 $sql .= "', calcium='" . $_GET['calcium']; |