comparison: www/includes/db_inventory_fermentables.php
www/includes/db_inventory_fermentables.php
- changeset 37
- 9362eb9e9e5b
- parent 18
- 395833e20f88
- child 39
- 400aae9fb0c8
equal
deleted
inserted
replaced
| 36:4b829f689d7e | 37:9362eb9e9e5b |
|---|---|
| 9 if (! $connect) { | 9 if (! $connect) { |
| 10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | 10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
| 11 } | 11 } |
| 12 | 12 |
| 13 // get data and store in a json array | 13 // get data and store in a json array |
| 14 $query = "SELECT * FROM inventory_fermentables"; | 14 $query = "SELECT * FROM inventory_fermentables ORDER BY supplier,name"; |
| 15 if (isset($_GET['insert'])) { | 15 if (isset($_GET['insert'])) { |
| 16 // INSERT COMMAND | 16 // INSERT COMMAND |
| 17 $sql = "INSERT INTO `inventory_fermentables` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | 17 $sql = "INSERT INTO `inventory_fermentables` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
| 18 $sql .= "', type='" . $_GET['type']; | 18 $sql .= "', type='" . $_GET['type']; |
| 19 $sql .= "', yield='" . $_GET['yield']; | 19 $sql .= "', yield='" . $_GET['yield']; |
