www/includes/db_profile_fermentation.php

changeset 716
57118e6a4bdb
parent 217
318aab371497
child 736
d3d8e3b30a34
equal deleted inserted replaced
715:8fb922c00a2d 716:57118e6a4bdb
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

mercurial