comparison: www/includes/db_profile_water.php
www/includes/db_profile_water.php
- changeset 211
- 63d0e40c58b9
- parent 77
- a9f8de2d7b2b
- child 296
- 69fadd1aded2
equal
deleted
inserted
replaced
| 210:3ced4934e230 | 211:63d0e40c58b9 |
|---|---|
| 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 | 12 |
| 13 // get data and store in a json array | 13 if (isset($_POST['insert']) || isset($_POST['update'])) { |
| 14 $query = "SELECT * FROM profile_water ORDER BY name"; | 14 if (isset($_POST['insert'])) { |
| 15 if (isset($_GET['insert'])) { | 15 $sql = "INSERT INTO `profile_water` SET "; |
| 16 // INSERT COMMAND | 16 } |
| 17 $sql = "INSERT INTO `profile_water` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | 17 if (isset($_POST['update'])) { |
| 18 $sql .= "', calcium='" . $_GET['calcium']; | 18 $sql = "UPDATE `profile_water` SET "; |
| 19 $sql .= "', bicarbonate='" . $_GET['bicarbonate']; | 19 } |
| 20 $sql .= "', sulfate='" . $_GET['sulfate']; | 20 |
| 21 $sql .= "', chloride='" . $_GET['chloride']; | 21 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); |
| 22 $sql .= "', sodium='" . $_GET['sodium']; | 22 $sql .= "', calcium='" . $_POST['calcium']; |
| 23 $sql .= "', magnesium='" . $_GET['magnesium']; | 23 $sql .= "', bicarbonate='" . $_POST['bicarbonate']; |
| 24 $sql .= "', ph='" . $_GET['ph']; | 24 $sql .= "', sulfate='" . $_POST['sulfate']; |
| 25 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | 25 $sql .= "', chloride='" . $_POST['chloride']; |
| 26 $sql .= "', total_alkalinity='" . $_GET['total_alkalinity']; | 26 $sql .= "', sodium='" . $_POST['sodium']; |
| 27 $sql .= "';"; | 27 $sql .= "', magnesium='" . $_POST['magnesium']; |
| 28 $sql .= "', ph='" . $_POST['ph']; | |
| 29 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); | |
| 30 $sql .= "', total_alkalinity='" . $_POST['total_alkalinity']; | |
| 31 if (isset($_POST['insert'])) { | |
| 32 $sql .= "';"; | |
| 33 } | |
| 34 if (isset($_POST['update'])) { | |
| 35 $sql .= "' WHERE record='" . $_POST['record'] . "';"; | |
| 36 } | |
| 37 syslog(LOG_NOTICE, $sql); | |
| 38 | |
| 28 $result = mysqli_query($connect, $sql); | 39 $result = mysqli_query($connect, $sql); |
| 29 if (! $result) { | 40 if (! $result) { |
| 30 syslog(LOG_NOTICE, "db_profile_water: ".$sql." result: ".mysqli_error($connect)); | 41 syslog(LOG_NOTICE, "db_profile_water: ".$sql." result: ".mysqli_error($connect)); |
| 31 } else { | 42 } else { |
| 32 syslog(LOG_NOTICE, "db_profile_water: inserted ".$_GET['name']); | 43 if (isset($_POST['update'])) { |
| 44 syslog(LOG_NOTICE, "db_profile_water: updated record ".$_POST['record']); | |
| 45 } else { | |
| 46 $lastid = mysqli_insert_id($connect); | |
| 47 syslog(LOG_NOTICE, "db_profile_water: inserted record ".$lastid); | |
| 48 } | |
| 33 } | 49 } |
| 34 echo $result; | 50 echo $result; |
| 35 | 51 |
| 36 } else if (isset($_GET['update'])) { | 52 } else if (isset($_POST['delete'])) { |
| 37 // UPDATE COMMAND | 53 // DELETE COMMAND |
| 38 $sql = "UPDATE `profile_water` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | 54 $sql = "DELETE FROM `profile_water` WHERE record='".$_POST['record']."';"; |
| 39 $sql .= "', calcium='" . $_GET['calcium']; | |
| 40 $sql .= "', bicarbonate='" . $_GET['bicarbonate']; | |
| 41 $sql .= "', sulfate='" . $_GET['sulfate']; | |
| 42 $sql .= "', chloride='" . $_GET['chloride']; | |
| 43 $sql .= "', sodium='" . $_GET['sodium']; | |
| 44 $sql .= "', magnesium='" . $_GET['magnesium']; | |
| 45 $sql .= "', ph='" . $_GET['ph']; | |
| 46 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | |
| 47 $sql .= "', total_alkalinity='" . $_GET['total_alkalinity']; | |
| 48 $sql .= "' WHERE record='" . $_GET['record'] . "';"; | |
| 49 $result = mysqli_query($connect, $sql); | 55 $result = mysqli_query($connect, $sql); |
| 50 if (! $result) { | 56 if (! $result) { |
| 51 syslog(LOG_NOTICE, "db_profile_water: ".$sql." result: ".mysqli_error($connect)); | 57 syslog(LOG_NOTICE, "db_profile_water: ".$sql." result: ".mysqli_error($connect)); |
| 52 } else { | 58 } else { |
| 53 syslog(LOG_NOTICE, "db_profile_water: updated record ".$_GET['record']); | 59 syslog(LOG_NOTICE, "db_profile_water: deleted record ".$_POST['record']); |
| 54 } | |
| 55 echo $result; | |
| 56 | |
| 57 } else if (isset($_GET['delete'])) { | |
| 58 // DELETE COMMAND | |
| 59 $sql = "DELETE FROM `profile_water` WHERE record='".$_GET['record']."';"; | |
| 60 $result = mysqli_query($connect, $sql); | |
| 61 if (! $result) { | |
| 62 syslog(LOG_NOTICE, "db_profile_water: ".$sql." result: ".mysqli_error($connect)); | |
| 63 } else { | |
| 64 syslog(LOG_NOTICE, "db_profile_water: deleted record ".$_GET['record']); | |
| 65 } | 60 } |
| 66 echo $result; | 61 echo $result; |
| 67 | 62 |
| 68 } else { | 63 } else { |
| 69 // SELECT COMMAND | 64 // SELECT COMMAND |
| 65 $query = "SELECT * FROM profile_water ORDER BY name"; | |
| 70 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 66 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
| 71 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | 67 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 72 $waters[] = array( | 68 $waters[] = array( |
| 73 'record' => $row['record'], | 69 'record' => $row['record'], |
| 74 'name' => $row['name'], | 70 'name' => $row['name'], |
