--- a/www/cmd_co2meter.php Tue May 12 16:08:30 2020 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,24 +0,0 @@ -<?php -require_once('config.php'); - -#Connect to the database -$connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); -if (! $connect) { - die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); -} -mysqli_set_charset($connect, "utf8" ); - -$sql = "UPDATE `mon_co2meters` SET "; -$sql .= "beername='" . mysqli_real_escape_string($connect, $_POST['beername']); -$sql .= "', beercode='" . mysqli_real_escape_string($connect, $_POST['beercode']); -$sql .= "', beeruuid='" . mysqli_real_escape_string($connect, $_POST['beeruuid']); -$sql .= "' WHERE uuid='" . $_POST['uuid'] . "';"; - -$result = mysqli_query($connect, $sql); -if (! $result) { - syslog(LOG_NOTICE, "cmd_co2meters: result: ".mysqli_error($connect)); -} else { - syslog(LOG_NOTICE, "cmd_co2meters: updated record ".$_POST['uuid']); -} -echo $result; -?>