www/includes/db_inventory_water_profiles.php@99c02fa797f9 (annotated)
www/includes/db_inventory_water_profiles.php
Sat, 18 Aug 2018 14:21:21 +0200
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Sat, 18 Aug 2018 14:21:21 +0200
- changeset 22
- 99c02fa797f9
- child 37
- 9362eb9e9e5b
- permissions
- -rw-r--r--
Added inventory water profiles
| 22 | 1 | <?php |
| 2 | ||
| 3 | require($_SERVER['DOCUMENT_ROOT']."/config.php"); | |
| 4 | require($_SERVER['DOCUMENT_ROOT']."/version.php"); | |
| 5 | ||
| 6 | #Connect to the database | |
| 7 | $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | |
| 8 | if (! $connect) { | |
| 9 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
| 10 | } | |
| 11 | ||
| 12 | // get data and store in a json array | |
| 13 | $query = "SELECT * FROM inventory_water_profiles"; | |
| 14 | if (isset($_GET['insert'])) { | |
| 15 | // INSERT COMMAND | |
| 16 | $sql = "INSERT INTO `inventory_water_profiles` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | |
| 17 | $sql .= "', calcium='" . $_GET['calcium']; | |
| 18 | $sql .= "', bicarbonate='" . $_GET['bicarbonate']; | |
| 19 | $sql .= "', sulfate='" . $_GET['sulfate']; | |
| 20 | $sql .= "', chloride='" . $_GET['chloride']; | |
| 21 | $sql .= "', sodium='" . $_GET['sodium']; | |
| 22 | $sql .= "', magnesium='" . $_GET['magnesium']; | |
| 23 | $sql .= "', ph='" . $_GET['ph']; | |
| 24 | $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | |
| 25 | $sql .= "', total_alkalinity='" . $_GET['total_alkalinity']; | |
| 26 | $sql .= "';"; | |
| 27 | $result = mysqli_query($connect, $sql); | |
| 28 | if (! $result) { | |
| 29 | syslog(LOG_NOTICE, "db_inventory_water_profiles: ".$sql." result: ".mysqli_error($connect)); | |
| 30 | } else { | |
| 31 | syslog(LOG_NOTICE, "db_inventory_water_profiles: inserted ".$_GET['name']); | |
| 32 | } | |
| 33 | echo $result; | |
| 34 | ||
| 35 | } else if (isset($_GET['update'])) { | |
| 36 | // UPDATE COMMAND | |
| 37 | $sql = "UPDATE `inventory_water_profiles` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | |
| 38 | $sql .= "', calcium='" . $_GET['calcium']; | |
| 39 | $sql .= "', bicarbonate='" . $_GET['bicarbonate']; | |
| 40 | $sql .= "', sulfate='" . $_GET['sulfate']; | |
| 41 | $sql .= "', chloride='" . $_GET['chloride']; | |
| 42 | $sql .= "', sodium='" . $_GET['sodium']; | |
| 43 | $sql .= "', magnesium='" . $_GET['magnesium']; | |
| 44 | $sql .= "', ph='" . $_GET['ph']; | |
| 45 | $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | |
| 46 | $sql .= "', total_alkalinity='" . $_GET['total_alkalinity']; | |
| 47 | $sql .= "' WHERE record='" . $_GET['record'] . "';"; | |
| 48 | $result = mysqli_query($connect, $sql); | |
| 49 | if (! $result) { | |
| 50 | syslog(LOG_NOTICE, "db_inventory_water_profiles: ".$sql." result: ".mysqli_error($connect)); | |
| 51 | } else { | |
| 52 | syslog(LOG_NOTICE, "db_inventory_water_profiles: updated record ".$_GET['record']); | |
| 53 | } | |
| 54 | echo $result; | |
| 55 | ||
| 56 | } else if (isset($_GET['delete'])) { | |
| 57 | // DELETE COMMAND | |
| 58 | $sql = "DELETE FROM `inventory_water_profiles` WHERE record='".$_GET['record']."';"; | |
| 59 | $result = mysqli_query($connect, $sql); | |
| 60 | if (! $result) { | |
| 61 | syslog(LOG_NOTICE, "db_inventory_water_profiles: ".$sql." result: ".mysqli_error($connect)); | |
| 62 | } else { | |
| 63 | syslog(LOG_NOTICE, "db_inventory_water_profiles: deleted record ".$_GET['record']); | |
| 64 | } | |
| 65 | echo $result; | |
| 66 | ||
| 67 | } else { | |
| 68 | // SELECT COMMAND | |
| 69 | $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | |
| 70 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
| 71 | $waters[] = array( | |
| 72 | 'record' => $row['record'], | |
| 73 | 'name' => $row['name'], | |
| 74 | 'calcium' => $row['calcium'], | |
| 75 | 'bicarbonate' => $row['bicarbonate'], | |
| 76 | 'sulfate' => $row['sulfate'], | |
| 77 | 'chloride' => $row['chloride'], | |
| 78 | 'sodium' => $row['sodium'], | |
| 79 | 'magnesium' => $row['magnesium'], | |
| 80 | 'ph' => $row['ph'], | |
| 81 | 'notes' => $row['notes'], | |
| 82 | 'total_alkalinity' => $row['total_alkalinity'] | |
| 83 | ); | |
| 84 | } | |
| 85 | echo json_encode($waters); | |
| 86 | } | |
| 87 | ?> |
