comparison: www/cmd_ispindel.php
www/cmd_ispindel.php
- changeset 570
- c8a20234d7e7
- child 578
- e75ce5bbda73
equal
deleted
inserted
replaced
| 569:d0e7ab1fc245 | 570:c8a20234d7e7 |
|---|---|
| 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_ispindels` 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 node='" . $_POST['node'] . "';"; | |
| 16 | |
| 17 $result = mysqli_query($connect, $sql); | |
| 18 if (! $result) { | |
| 19 syslog(LOG_NOTICE, "cmd_ispindel: result: ".mysqli_error($connect)); | |
| 20 } else { | |
| 21 syslog(LOG_NOTICE, "cmd_ispindel: updated record ".$_POST['node']); | |
| 22 } | |
| 23 echo $result; | |
| 24 ?> |
