32 $sql .= "';"; |
32 $sql .= "';"; |
33 } |
33 } |
34 if (isset($_POST['update'])) { |
34 if (isset($_POST['update'])) { |
35 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
35 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
36 } |
36 } |
37 syslog(LOG_NOTICE, $sql); |
37 //syslog(LOG_NOTICE, $sql); |
38 |
38 |
39 $result = mysqli_query($connect, $sql); |
39 $result = mysqli_query($connect, $sql); |
40 if (! $result) { |
40 if (! $result) { |
41 syslog(LOG_NOTICE, "db_profile_water: ".$sql." result: ".mysqli_error($connect)); |
41 syslog(LOG_NOTICE, "db_profile_water: ".$sql." result: ".mysqli_error($connect)); |
42 } else { |
42 //} else { |
43 if (isset($_POST['update'])) { |
43 // if (isset($_POST['update'])) { |
44 syslog(LOG_NOTICE, "db_profile_water: updated record ".$_POST['record']); |
44 // syslog(LOG_NOTICE, "db_profile_water: updated record ".$_POST['record']); |
45 } else { |
45 // } else { |
46 $lastid = mysqli_insert_id($connect); |
46 // $lastid = mysqli_insert_id($connect); |
47 syslog(LOG_NOTICE, "db_profile_water: inserted record ".$lastid); |
47 // syslog(LOG_NOTICE, "db_profile_water: inserted record ".$lastid); |
48 } |
48 // } |
49 } |
49 } |
50 echo $result; |
50 echo $result; |
51 |
51 |
52 } else if (isset($_POST['delete'])) { |
52 } else if (isset($_POST['delete'])) { |
53 // DELETE COMMAND |
53 // DELETE COMMAND |