comparison: www/cmd_co2meter.php
www/cmd_co2meter.php
- changeset 506
- 8ab0e87d579e
equal
deleted
inserted
replaced
| 505:c09b67fd8323 | 506:8ab0e87d579e |
|---|---|
| 1 <?php | |
| 2 require_once('config.php'); | |
| 3 | |
| 4 #Connect to the database | |
| 5 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | |
| 6 if (! $connect) { | |
| 7 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
| 8 } | |
| 9 mysqli_set_charset($connect, "utf8" ); | |
| 10 | |
| 11 $sql = "UPDATE `mon_co2meters` SET "; | |
| 12 $sql .= "beername='" . mysqli_real_escape_string($connect, $_POST['beername']); | |
| 13 $sql .= "', beercode='" . mysqli_real_escape_string($connect, $_POST['beercode']); | |
| 14 $sql .= "', beeruuid='" . mysqli_real_escape_string($connect, $_POST['beeruuid']); | |
| 15 $sql .= "' WHERE uuid='" . $_POST['uuid'] . "';"; | |
| 16 | |
| 17 $result = mysqli_query($connect, $sql); | |
| 18 if (! $result) { | |
| 19 syslog(LOG_NOTICE, "cmd_co2meters: result: ".mysqli_error($connect)); | |
| 20 } else { | |
| 21 syslog(LOG_NOTICE, "cmd_co2meters: updated record ".$_POST['uuid']); | |
| 22 } | |
| 23 echo $result; | |
| 24 ?> |
