query("SET NAMES utf8");
		$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		$submitToLog = $pdo->prepare("INSERT INTO log VALUES ('',:time,:sv,:si,:sp,:bv,:bi,:bs,:li,:lp)");
		$submitUptime = $pdo->prepare("UPDATE info SET infoValue=? WHERE infoName='uptime'");
		$submitPiUptime = $pdo->prepare("UPDATE info SET infoValue=? WHERE infoName='piuptime'");
		$submitUpdateTime = $pdo->prepare("UPDATE info SET infoValue=NOW() WHERE infoName='lastupdated'");
		$submitLoadState = $pdo->prepare("UPDATE info SET infoValue=? WHERE infoName='loadstate'");
		$logCount = $pdo->query("SELECT COUNT(*) FROM log");
		$rowCount = $logCount->fetch();
		$rows = $rowCount[0] + 1;
		$rows = number_format($rows);
		
		$submitToLog->bindParam(':time', $_POST['time'], PDO::PARAM_STR);
		$sV = $_POST['sv'];
		if ($sV < 0.0){ $sV = 0.0; }
		 $submitToLog->bindParam(':sv', $sV, PDO::PARAM_STR);
		$sI = $_POST['si'];
		if ($sI < 0.0){ $sI = 0.0; }
		 $submitToLog->bindParam(':si', $sI, PDO::PARAM_STR);
		$sP = round($sV*$sI,2);
		 $submitToLog->bindParam(':sp', $sP, PDO::PARAM_STR);
		$bV = $_POST['bv'];
		if ($bV < 0.0){ $bV = 0.0; }
		 $submitToLog->bindParam(':bv', $bV, PDO::PARAM_STR);
		$bI = $_POST['bi'];
		if ($bI < 0.0){ $bI = 0.0; }
		 $submitToLog->bindParam(':bi', $bI, PDO::PARAM_STR);
		$bS = $_POST['bs'];
		 $submitToLog->bindParam(':bs', $bS, PDO::PARAM_STR);
		$lI = $_POST['li'];
		if ($lI < 0.2){
			$lI = 0.0; 
			$lS = 'Off'; 
		}else{
			$lS = 'On'; 
		}
		 $submitToLog->bindParam(':li', $lI, PDO::PARAM_STR);
		$lP = round($bV*$lI,2);
		 $submitToLog->bindParam(':lp', $lP, PDO::PARAM_STR);
		 
		$submitLoadState->bindParam(1, $lS, PDO::PARAM_STR);
		$submitLoadState->execute();
		 
		$uptime = $_POST['uptime'];
		$uptime = str_replace("_", " ", $uptime);
		$uptime = str_replace("-", ",", $uptime);
		$submitUptime->bindParam(1, $uptime, PDO::PARAM_STR);
		$submitUptime->execute();
		
		$piUptime = $_POST['piuptime'];
		$piUptime = str_replace("_", " ", $piUptime);
		$piUptime = str_replace("-", ",", $piUptime);
		$submitPiUptime->bindParam(1, $piUptime, PDO::PARAM_STR);
		$submitPiUptime->execute();
		
		$submitUpdateTime->execute();

		if ($submitToLog->execute()){
			echo "Database updated with POST, $rows rows";
		}else{
			echo "Submit error: There was a problem with the MySQL query";
		}
		$pdo = null;
	}else{
		echo "Submit error: Missing data or unauthorized submission";
	}
?>