www/includes/db_inventory_water_sources.php

changeset 37
9362eb9e9e5b
parent 21
acb2d8098f19
equal deleted inserted replaced
36:4b829f689d7e 37:9362eb9e9e5b
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'];

mercurial