60 $sql .= "';"; |
60 $sql .= "';"; |
61 } |
61 } |
62 if (isset($_POST['update'])) { |
62 if (isset($_POST['update'])) { |
63 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
63 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
64 } |
64 } |
65 syslog(LOG_NOTICE, $sql); |
65 //syslog(LOG_NOTICE, $sql); |
|
66 |
66 $result = mysqli_query($connect, $sql); |
67 $result = mysqli_query($connect, $sql); |
67 if (! $result) { |
68 if (! $result) { |
68 syslog(LOG_NOTICE, "db_profile_fermentation: ".$sql." result: ".mysqli_error($connect)); |
69 syslog(LOG_NOTICE, "db_profile_fermentation: ".$sql." result: ".mysqli_error($connect)); |
69 } else { |
70 //} else { |
70 if (isset($_POST['update'])) { |
71 // if (isset($_POST['update'])) { |
71 syslog(LOG_NOTICE, "db_profile_fermentation: updated record ".$_POST['record']); |
72 // syslog(LOG_NOTICE, "db_profile_fermentation: updated record ".$_POST['record']); |
72 } else { |
73 // } else { |
73 $lastid = mysqli_insert_id($connect); |
74 // $lastid = mysqli_insert_id($connect); |
74 syslog(LOG_NOTICE, "db_profile_fermentation: inserted record ".$lastid); |
75 // syslog(LOG_NOTICE, "db_profile_fermentation: inserted record ".$lastid); |
75 } |
76 // } |
76 } |
77 } |
77 echo $result; |
78 echo $result; |
78 |
79 |
79 } else if (isset($_POST['delete'])) { |
80 } else if (isset($_POST['delete'])) { |
80 // DELETE COMMAND |
81 // DELETE COMMAND |