' . $timestamp . '

'; $OnOff = $_GET['OnOff']; if ($OnOff == '') { $OnOff = '0'; } $TFeed = $_GET['Feed']; if ($TFeed == '') { $TFeed = '0.0'; } $TReturn = $_GET['Return']; if ($TReturn == '') { $TReturn = '0.0'; } $UAC = $_GET['UAC']; if ($UAC == '') { $UAC = '0'; } $PumpOnCnt = $_GET['PumpOnCnt']; if ($PumpOnCnt == '') { $PumpOnCnt = '0'; } $RunTime = $_GET['RunTime']; if ($RunTime == '') { $RunTime = '0.0'; } $Comment = $_GET['Comment']; if ($Comment == '') { $Comment = ''; } $mysqli = new mysqli('localhost', 'user', 'password', 'MyHome'); if ($mysqli->connect_errno) { echo '

Failed to connect to MySQL: (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error . '

'; } $sql = sprintf("INSERT INTO WWCircPump (timestamp, OnOff, TFeed, TReturn, UAC, PumpOnCnt, RunTime, Comment) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", $mysqli->real_escape_string($timestamp), $mysqli->real_escape_string($OnOff), $mysqli->real_escape_string($TFeed), $mysqli->real_escape_string($TReturn), $mysqli->real_escape_string($UAC), $mysqli->real_escape_string($PumpOnCnt), $mysqli->real_escape_string($RunTime), $mysqli->real_escape_string($Comment)); if (!$mysqli->query($sql)) { echo '

Error: ' . $mysqli->error . '

'; } $mysqli->close(); ?>