comparison: www/includes/db_inventory_water.php
www/includes/db_inventory_water.php
- changeset 99
- f433193f7bb6
- parent 77
- a9f8de2d7b2b
- child 205
- 08488ac3bbb1
equal
deleted
inserted
replaced
| 98:92d6bc8a4cdd | 99:f433193f7bb6 |
|---|---|
| 7 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | 7 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
| 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 mysqli_set_charset($connect, "utf8" ); | 11 mysqli_set_charset($connect, "utf8" ); |
| 12 | |
| 13 /* | |
| 14 * If a new default will be set, clear the old default. | |
| 15 */ | |
| 16 function clear_default() { | |
| 17 global $connect; | |
| 18 | |
| 19 $usql = "UPDATE inventory_waters SET default_water='0' WHERE (default_water = '1');"; | |
| 20 $result = mysqli_query($connect, $usql); | |
| 21 if (! $result) { | |
| 22 syslog(LOG_NOTICE, "db_inventory_waters: " . $usql . " result: ".mysqli_error($connect)); | |
| 23 } | |
| 24 } | |
| 25 | 12 |
| 26 | 13 |
| 27 // get data and store in a json array | 14 // get data and store in a json array |
| 28 $query = "SELECT * FROM inventory_waters ORDER BY name"; | 15 $query = "SELECT * FROM inventory_waters ORDER BY name"; |
| 29 if (isset($_GET['insert'])) { | 16 if (isset($_GET['insert'])) { |
| 37 $sql .= "', sodium='" . $_GET['sodium']; | 24 $sql .= "', sodium='" . $_GET['sodium']; |
| 38 $sql .= "', magnesium='" . $_GET['magnesium']; | 25 $sql .= "', magnesium='" . $_GET['magnesium']; |
| 39 $sql .= "', ph='" . $_GET['ph']; | 26 $sql .= "', ph='" . $_GET['ph']; |
| 40 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | 27 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
| 41 $sql .= "', total_alkalinity='" . $_GET['total_alkalinity']; | 28 $sql .= "', total_alkalinity='" . $_GET['total_alkalinity']; |
| 42 if ($_GET['default_water'] == 'true') { | |
| 43 clear_default(); | |
| 44 $sql .= "', default_water='1"; | |
| 45 } else { | |
| 46 $sql .= "', default_water='0"; | |
| 47 } | |
| 48 $sql .= "', inventory='" . $_GET['inventory']; | 29 $sql .= "', inventory='" . $_GET['inventory']; |
| 49 $sql .= "', cost='" . $_GET['cost']; | 30 $sql .= "', cost='" . $_GET['cost']; |
| 50 $sql .= "';"; | 31 $sql .= "';"; |
| 51 $result = mysqli_query($connect, $sql); | 32 $result = mysqli_query($connect, $sql); |
| 52 if (! $result) { | 33 if (! $result) { |
| 67 $sql .= "', sodium='" . $_GET['sodium']; | 48 $sql .= "', sodium='" . $_GET['sodium']; |
| 68 $sql .= "', magnesium='" . $_GET['magnesium']; | 49 $sql .= "', magnesium='" . $_GET['magnesium']; |
| 69 $sql .= "', ph='" . $_GET['ph']; | 50 $sql .= "', ph='" . $_GET['ph']; |
| 70 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | 51 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
| 71 $sql .= "', total_alkalinity='" . $_GET['total_alkalinity']; | 52 $sql .= "', total_alkalinity='" . $_GET['total_alkalinity']; |
| 72 if ($_GET['default_water'] == 'true') { | |
| 73 clear_default(); | |
| 74 $sql .= "', default_water='1"; | |
| 75 } else { | |
| 76 $sql .= "', default_water='0"; | |
| 77 } | |
| 78 $sql .= "', inventory='" . $_GET['inventory']; | 53 $sql .= "', inventory='" . $_GET['inventory']; |
| 79 $sql .= "', cost='" . $_GET['cost']; | 54 $sql .= "', cost='" . $_GET['cost']; |
| 80 $sql .= "' WHERE record='" . $_GET['record'] . "';"; | 55 $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
| 81 $result = mysqli_query($connect, $sql); | 56 $result = mysqli_query($connect, $sql); |
| 82 if (! $result) { | 57 if (! $result) { |
| 112 'sodium' => $row['sodium'], | 87 'sodium' => $row['sodium'], |
| 113 'magnesium' => $row['magnesium'], | 88 'magnesium' => $row['magnesium'], |
| 114 'ph' => $row['ph'], | 89 'ph' => $row['ph'], |
| 115 'notes' => $row['notes'], | 90 'notes' => $row['notes'], |
| 116 'total_alkalinity' => $row['total_alkalinity'], | 91 'total_alkalinity' => $row['total_alkalinity'], |
| 117 'default_water' => $row['default_water'], | |
| 118 'inventory' => $row['inventory'], | 92 'inventory' => $row['inventory'], |
| 119 'cost' => $row['cost'] | 93 'cost' => $row['cost'] |
| 120 ); | 94 ); |
| 121 } | 95 } |
| 122 echo json_encode($waters); | 96 echo json_encode($waters); |
